Find a Dir and File

[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 Nurick]

Hi John,

The code here http://www.mvps.org/access/api/api0001.htm lets you bring
up the standard File|Open dialog so the user can select the file and you
get the filespec in a variable.

 

[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]

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