Importing multiple files

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

Greetings!

I want to use VBA to automate the import of fixed width
files (docmd.TransferText), but the file that will be
imported will always be changed. How do I allow the user
the flexibility to chose which file that should be
imported? All the files have the same format and I have
set the specs for that format, but the actual file will
constantly change. Is there anyway to allow the user to
type in the file location or maybe have a drop down box
that allows them to search for the file location??

Any help would be appreciated!

thanks!

Jessica
 
Back
Top