Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Excelerate2004
  • Content: Threads
  • Order by date
  1. Excelerate2004

    Need assistance in outputting to a Text file

    Hello to all, I have a text file with customers names and their purchases over a 5 month period. It would look like similar to whats below: "Name", "M1", "M2", "M3", "M4", "M5" "Harry Jones", 250, 300, 450, 100, 250 "Henny Penny", 100, 200, 150, 300, 250 "Tom Mack", 110, 320, 150, 345, 430...
  2. Excelerate2004

    How can you Export from word to Excel using VBA??

    Hello all, I took a quick scan thru the archives but didnt see anything relating to what I'm trying to do. So I decided to post here. I'm trying to export text from a word document using VBA to Excel. I tried running a macro but it didnt quite give me what I wanted. I'd like to be able to...
  3. Excelerate2004

    WORD: Highlight replaced text using VBA code

    Hello, I'm trying to use VBA code via a button click sub procedure in MS word 2000 to highlight text that has just been replaced via a find & replace. I used a Macro just to see the syntax for highlighted text and got the following: <code> Selection.Range.HighlightColorIndex = wdYellow...
  4. Excelerate2004

    Excel-VBA: Finding the 2nd highest value

    Is there a function to find the 2nd highest value amongst a range of values? I have 4 columns, labeled: A, B, C, D. If I take the Max value of those 4 columns, then subtract the max from each of the individual columns then the lowest resulting value is the 2nd highest. Is there an easier way...
  5. Excelerate2004

    Help with a subtraction function

    I'm wondering if I could have some help in trying to set up this procedure to subtract 2 cells and then divide. The code is as follows: Dim rngLastcell As Integer With Sheets("affy data") For z = 2 To rngLastcell '(L2-N2)/K2 Cells(z, "O").Value = .Range("L" & _ z).Value - .Range("N" &...
  6. Excelerate2004

    Return Max value of a range of cells using VBA?

    Hello to all, I'm trying to get the following to work in VBA for excel: If Sheets("affydata").Range(Max("C2:F2")).Value = C2 Then I2 = "A" End If If Sheets("affydata").Range(Max("C2:F2")).Value = D2 Then I2 = "C" End If If Sheets("affydata").Range(Max("C2:F2")).Value = E2 Then I2...
  7. Excelerate2004

    Writing an IF statement in Excel

    How can I write this in excel? IF (C2>D2 AND C2>E2 AND C2>F2) Then "A" ELSEIF (D2>C2 AND D2>E2 AND D2>F2)Then "T" ELSEIF (E2>C2 AND E2>D2 AND E2>F2) Then "G" ELSEIF (F2>C2 AND F2>D2 AND F2>E2) Then "C" END IF I keep getting caught up on the brackets!!
  8. Excelerate2004

    IF statements in SQL

    Is it possible to execute the following If statements in Access? IF cola > colc AND cola > colg AND cola > colt THEN sig = "A" ELSEIF colc > cola AND colc > colg AND colc > colt THEN sig = "C" ELSEIF colg > cola AND colg > colc AND colg > colt THEN sig = "G" ELSEIF colt > cola AND colt >...
  9. Excelerate2004

    Being Spammed by myself?

    Hello to all, I'm just wondering if anyone has heard anything like this: Last week I received an email with my exact email address sent to myself with a subject line like RE: Your website which is very regularly used as a spam subject line. I obviously didn't send it to myself! What is...
  10. Excelerate2004

    VBA script - export selected record to a text file

    Hello, I've taken a look at previous posts on this issue, but all solutions seem much more complicated than what I'm trying to do. I have a simple 1-table access database, whereby I want to export 1 field of a selected record to a text file. This field that I require to be exported is text...
  11. Excelerate2004

    help with Iterative loop

    Hello to all, I have a range of cells from B2:B536 (Vertically). There is a text value in B2 and 2 empty cells below that, text value in B5 and 2 empty cells below that, text value in B8, 2 empty cells etc...all the way to B536 I want to be able to look in B2, B5, B8 etc. and based on what...
  12. Excelerate2004

    Excel: Nested IF's

    Is it possible to nest the following IF's in an excel function or would i be easier to do this in VBA? IF C2 = "C" Then C3 = "C" AND C4 = "C" ELSEIF C2 = "CT" Then C3 = "C" AND C4 = "T" ELSEIF C2 = "T" Then C3 = "T" AND C4 = "T" ELSEIF C2 = " " Then C3 = "?" AND C4 = "?" I'd like...
  13. Excelerate2004

    help with code to repeat a copy & paste macro

    How can I iterate or repeat the following copy & paste macro so that it goes thru the entire recordset and carries out the required task? Sub Macro2() ' ' Macro2 Macro ' Macro recorded 27/06/2005 by bam ' ' Keyboard Shortcut: Ctrl+p ' Selection.Copy Sheets("Sheet2").Select...
  14. Excelerate2004

    Unable to execute erase, restore, backup etc.

    Hello Everybody, I'm running backup Exec 9.0 SP3 on 2 small servers, however just yesterday when I went to run an erase job or even a regular backup job when I go into Backupexec administration console or even manually on the server the console is completely unresponsive and so when a job is...
  15. Excelerate2004

    install WIN 2K O/S over WIN NT O/S

    Hello, I'm not sure if I'm in the right forum or not, but I have been tasked with installing windows 2000 on a windows NT machine. I read the min requirements for the win 2000 o/s and the NT box does have them. However, my issue comes from the fact that the NT box has 2 harddrives. A 2 GB...
  16. Excelerate2004

    EXCEL: Sum of Values adding incorrectly

    Hello all, I think this is a relatively easy thing to solve but so far its perplexed me. I have an application whereby NUMEROUS calculations are carried out on various numbers over 5 tab sheets. I get down to my very last step and my numbers are sometimes off by 1. I should mention that...
  17. Excelerate2004

    Unable to receive Groupwise email, can send though

    My ISP changed my IP address last week, since then I've been unable to receive any groupwise email. See Thread entitled: "SERVER ip address changed, GWWEB access down." I've since solved that issue and I can now access groupwise thru the web, however I am unable to receieve any outside email...
  18. Excelerate2004

    Implications of deleting Security certificates for DNS and IP

    Hello to all who can help or make some use of my upcoming question, Late last week my ISP changed my IP address, obviously this had disastrous ramifications on many of my network processes. I first noticed my groupwise webaccess system went down and much later I noticed that I was unable to...
  19. Excelerate2004

    Server IP address changed, GWWEB access down

    Hello everybody, I'm not quite sure where to look next so I figured I'd give the forums a try to see if i can get some direction. This morning I had the IP address of my server changed as an ISP was upgrading our DSL connection. This of course affects Groupwise webaccess as the link for the...
  20. Excelerate2004

    Excel - Explanation of code

    Hello, I used the following code in a project a while back, but now a user is having difficulty with one of the calculations that uses this code. Would someone be able to help me decipher just what exactly this code is actually doing in pseudo-code? I'm not completely sure since its been a...

Part and Inventory Search

Back
Top