TransferSpreadsheet

  • Thread starter Thread starter Lina
  • Start date Start date
L

Lina

Hello,
I have a macro where I use TransferSpreadsheet to export a table into
excel. The file path where the file is saved is always the same and
the last character of the file name would vary every week: example -
Input_Week1.xls, Input_Week2.xls...

I would like to input most of the path to save the file except for the
last character, the week #. I would like it to prompt the user to
enter the week #.

Is there a way to do this?

Thanks!
 
Use an expression for the File Name argument:

="C:\YourFolderName\BaseFileName" & InputBox("Enter week number:","Week
Number") & ".xls"
 
Thank you very much, it worked perfectly!






Use an expression for the File Name argument:

="C:\YourFolderName\BaseFileName" & InputBox("Enter week number:","Week
Number") & ".xls"

--

Ken Snell
<MS ACCESS MVP>









- Show quoted text -
Click to expand...
 
Back
Top