The file name when importing

  • Thread starter Thread starter Crystal
  • Start date Start date
C

Crystal

I need to be able to import an Excel file with a macro.
The transfer spreadsheet requires the path to the file
name. I need to be able to prompt the user for the
location instead of specifying the full path. Is this
possible?

Thanks
 
Use an expression similar to this in the file name box:

= InputBox("enter the path and filename:")
 

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

Importing EXCEL data into ACCESS 1
Import 4 Different Excel Files from One Folder 0
Access Print Files from Query Results 0
prompting file name 1
Importing Text Files Into Access 1
MACRO QUERY - how to enable user to "browse" for the "file name" 1
Import Named Ranged 7
prompt for function arguments? 1

Back
Top