Automatically import file and also get the file name

  • Thread starter Thread starter Challenged by boss
  • Start date 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.
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import External Data by Date Automatically 0
Import 4 Different Excel Files from One Folder 0
Importing Text Files Into Access 1
Hyperlink field that does not link to the file 3
Access Importing csv daily files into access 2007 1
Wanting to grab group of files and PkZip them. 6
Find a Dir and File 3
Importing any excel files with any sheet name into different tables in MSAccess using code 0

Back
Top