TransferSpreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lina - 20 Apr 2007 17:05 GMT

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!

Reply to this Message

Ken Snell (MVP) - 20 Apr 2007 21:01 GMT

Use an expression for the File Name argument:

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

Signature

Ken Snell
<MS ACCESS MVP>

> Hello,
> I have a macro where I use TransferSpreadsheet to export a table into
[quoted text clipped - 9 lines]
>
> Thanks!

Reply to this Message

Lina - 23 Apr 2007 16:19 GMT

Thank you very much, it worked perfectly!

On Apr 20, 4:01 pm, "Ken Snell \(MVP\)"
<kthsneisll...@ncoomcastt.renaetl> wrote:

> Use an expression for the File Name argument:
>
[quoted text clipped - 21 lines]
>
> - Show quoted text -

Reply to this Message