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