Recent content by ThomasLafferty

Skip and willif - I'm grateful for the suggestions and will take them under advisement. Thanks again guys! Tom Born once die twice; born twice die once.

Got it! It turns out I needed to add a line feed after the carriage return, and only add the tab if I hadn't arrived at the last column. Here's the ammended code: 'determine last invoice row on send sheet LastSendRow = Worksheets("Send").Range("A65536").End(xlUp).Row Open...

Hi willif - Access is an interesting notion, but the problems I see is that there is no clear indication of what the field names would be - each "record" does not have a header. The start of the invoice is flagged with "B3" and there is a series of values, and the end of the invoice is flagged...

Hi Skip - you are right! If I open Word and use it to do an edit replace of """ with ", that will certainly do the trick. The problem is that I need this to be a hands off process. I have a routine which correctly analyzes which invoices pass muster and separates them from those that don't...

Hi Skip - I should have been a bit more specific in my reply. The problem remains that if I leave the quotes in the sheet tab in my book which I then save as text, then when I open the text file, I discover that "B3" has become """B3""" in the text file itself, not in the sheet tab - it remains...

Thanks for the reply! I have tried the above to no avail, so I have decided to write directly to the file. I have investigated the forum and found several attempts at this, but can't quite get it to work. I need a carriage return at the end of each line, and I also need to strip out the last tab...

I have written a routine in VBA for Excel XP which imports a tab delimited text file into my workbook. The original file looks like this: "B3" "2421835" "2421835" "TP" 05/17/07 1175.00 "CEI" 05/06/07 "N9" "IT" "KUP" "N9" "BF" "YA" "N9" "PO" "CA23WHSEF" "N1" "SH" "CONOCO PHILLIPS" "N3" "KUPARUK...

Thanks for the reply! This sounds like a decent way to go, and I will try it on Monday. As for which way to sort it, I will have to hash that out with the collections manager. I agree that the DATE field is an absolutely bad idea, but I am stuck with it - it's an export from a legacy database...

Hi there - I need to be able to compare the percentage change for amounts over due (>60 Days, >90, >120). The table in which the data resides is Current Month Aging History. Here is the field list: CUSTNO NAME DATE OVER60 OVER90 OVER120 Here is the query I am currently using...

This does not appear to be the case. I have only 1 signature, and it only applies to outgoing email messages, replies and forwards. Tom Born once die twice; born twice die once.

Sorry about the repost, but I received no replies, probably because I wrote a follow on so it looked like someone had responded. Microsoft Outlook appends the following text to the bottom of meeting invitations: =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~= Click the following link...

Follow on to previous: apparently it is only doing this in meeting invitations. I am running Outlook 2007. Thanks in advance. Born once die twice; born twice die once.

I recently noticed that Outlook has been adding the following to the bottom of my outbound messages: =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~= Click the following link to get a map and driving directions in Live Search Maps: http://go.microsoft.com/fwlink/?LinkId=65850&WIP=12...

Thanks a million! As usual, you were right on the money. [medal] Born once die twice; born twice die once.

Hi there. I have a crosstab query for reporting survey results by department. Currently it returns the number of times individuals in a given department chose a certain category. This works fine. In my report which references this query, I need to know how many individuals as a total percentage...