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

Error outlook.com 0xc0000005 trying to open custom controls 0
Incorporating the User Profile location into a document template path 1
Mail Merge Directory Conditional Page Break 0
Default local file location - folder redirection slowness 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Word VBA - Want to test if Full Name is NOT Present in document 0
How to insert Certificated digital signature in Word for Mac 0
Word macro that can call cells out of Excel for a find and replace 0

Top