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:")
 
Top