TransferSpreadsheet

[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!

 

[Ken Snell \(MVP\)]

Use an expression for the File Name argument:

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

 

[Lina]

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 -