Find a Dir and File

  • Thread starter Thread starter John
  • Start date Start date
J

John

I need to import a .txt delimited file using VBA in A2003.
The file name will be different each import time except for the .txt
extension, and the field structure will always be the same..
Like 040907.txt or 041007.txt
I'm planning to use the TransferText method, along with an Import
Specification file.

The problem I can't figure out is how to code for the user to go out to the
G: drive, find the specific filename, and capture the Path and Filename as a
variable to pass on to my TransferText FileName argument.

Would appreciate any help.
Thankyou,
John
 
John
Thanks for that info. Looks pretty difficult, but I'll give it a go.
I'll try to let you know how it goes. It will take a while for me to check
it out.
Thanks
John
 
John,
Thanks for the link. I finally figured out what the code was doing,
extracted what I needed from it, and got it to work just the way I wanted.
Thanks again!!
John
 
Back
Top