Search results for query: *

OK, I have it working now. I decided to create a master .txt file with the coders initials on it, so it will be easier to add and remove them as they come and go. So that part is done and complete. What I have now is a .xls document that contains the same data as before, only all the sheet are...

I have an excel spreadsheet that lists in rows. 1. I need to read starting with Column A3 and create a new sheet with exactly what is in Column A, (going down)until A is blank. 2. Next I need A2 through AK2 COPIED onto each sheet. (copy into A1:AK2) 3. Last I need to read each cell in A...

I forgot I changed it a little bit from my original description. I created a masterlist.txt document of all codes and the corresponding supervisors e-mails addresses. I read this document instead, then search for the .csv document that matches. I thought this would be easier to maintain...

I figured it out Wednesday, thanks for replying we approached it the same way only I decided at the end to make a "Master.txt" document to easily adjust the e-mail addresses later. Thanks again, here's what I'm using. "Const ForReading = 1 Set objFSO =...

OK, I have a direcotry of documents, that list like this 600_20101122.csv "Dim ctr,arrDocList, i ctr = 0 Const ForReading = 1 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.OpenTextFile ("\\Directory\FileList.txt", ForReading) Do Until...

TSUJI... amazing.. thank you. that is great. it works and very quickly without any hesitation. It produced over 400 documents without even the slightest hesitation.

Thanks mrmovie, I couldn't figure out the instr and such features. that helped. jges: Yes I'm taking the comma's out and putting spaces, actually tab keys char(16). which i haven't done yet. NO, I want to stop on all Revenue code lines. I'm trying to seperate this .csv Revenue Code...

Yes, I need the script to stop when it sees "Revenue Code: " on this line is a bunch of stuff totals and such all together so I"m guessing it needs an InStr to search for Revenue Code: Then once I find Revenue code: there are always 2 spaces, then a 2 to 5 digit number and 2 more spaces...

Here's the script to read the file, but I can't make it stop at "Revenue Code: $%^&*(" there is a bunch of info on this line. {On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &H0001 Dim LINE , LINEa, LINEb Set objConnection =...

Hello everyone, First post and I need some assistance. master document is a .csv however each record is divided by a row: "information","information", and such. " " (space, and empty line) "Revenue Code: #### (this line is the key. code is 2 to 5 digits) I need to read the file storing each...