Automatically import file and also get the file name

  • Thread starter Challenged by boss
  • Start date
C

Challenged by boss

Is there a vba code that automatically imports a file and also gets the file
name. The filename will be populating one of the fields.
 
K

keith

Need a little bit more to go on. Will the user be selecting the file using a
Common Dialog or will you need to look in a specific folder to import a file
with a filename matching a pattern (such as MyFIle_*.xls where * is the file
date)? Also, what type of file are you importing (Access, Excel, text, etc.)
 
Top