Hi All
I have looked at, and tried many variants of this from google searches, but
none thus far do what it is i'm looking to do.
I recall seeing something similar to what I am hoping to achieve, but for the
life of me, I can't remember where or when.
All the text files have the same "," delimitation and the data structures are
identical, there will be as many as a 100 files in the folder.
Ideally the code will loop through each file, then copy/append the data into
Sheets("Import") starting at Row(2)
I will then add the code to move all the copied files into a new
"Folder:\\Processed Files" so the main folder will always be empty for the
daily Rinse/Repeat.
As always, many thanks in advanced for your time.
Cheers
Mark.
Hi Mark,
Can you provide a sample file AND the File Explorer Address to your network
share? A sample of the target worksheet headings (row1 fieldnames) will also be
helpful!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion