boots
Last Activity: Nov 20 '07, 07:47 PM
Joined: Nov 7 '07
Location:
-
thanks, I will give that a shot. -
compare matching data in different sheets
I have a file with two worksheets. Column C of Sheet1 has FILE IDs, as does Column D of Sheet2. I would like to find any matches and then copy all of the data from the matching row in Sheet1 to the end of the matching row on Sheet2. -
thanks, that works very well!!Leave a comment:
-
saving a file without opening it (using VBA
The MACRO below opens a file. I need this MACRO to save the selected file "test.txt" without actually opening the file.
Can somebody please help me with the backside of this MACRO???
This is what I have:
Sub marine()
FilterIndex = 5
Title = "Please select a different File"
FileName = Application.Get OpenFileName(Fi leFilter:=Filt, _
FilterIndex:=Fi lterIndex,... -
All the records are the same length and there are no delimiters....Leave a comment:
-
Could this be done within the parameters that I described? I have a massive amount of files and any automation that gets me what I want would be worth it....Leave a comment:
-
The header doesn't exactly jumble the column. The fields do not line up with the rest of the document.
header record:
HDRSH0590460106 122720061227PRO D20070104100538 03
I need data from 1-3, 4-8, 9-19 in the header records. Some files have multiple header records.
I need data from 1-3, 10-12, 365-371....Leave a comment:
-
importing flat text files
I have many text files to import into EXCEL. They are flat files and the data I need is in columns 1-3, 10-12 and 365-371. The files also have header records that jumble up the columns 1-3, 4-12 and 12-25.
I also need a way to load the files as part of the MACRO so the users will have less problems.
No activity results to display
Leave a comment: