Search results for query: *

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...

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...

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...

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...

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" &...

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...

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!!

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 >...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...