The file name when importing

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
 
K

Ken Snell

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

Access Subscript out of range when importing into access 2010 from excel 0
prompt for function arguments? 1
prompting file name 1
MACRO QUERY - how to enable user to "browse" for the "file name" 1
Import Excel to Acsess using Macro 3
Access Print Files from Query Results 0
Access MS Access 2010 - problem importing file 0
TransferText 3

Top