Exporting different file names?

[Randy]

I need a way to name exported files (Excel) differently each day using
tranferspreadsheet in a macro. That is have the ability to name the
exported file at will, not be stuck with a preset file name the way it it
now. I hope this makes sense..Thanks..Randy

 

[Steve Schapel]

Randy,

Put an unbound textbox on a form which will be open at the time that you
execute your transferspreadsheet, and type the required name for the
exported file in this textbox. Then, in the File Name argument of the
macro, refer to this textbox using syntax such as...
="C:\YourFolder\" & [Forms]![YourForm]![YourTextbox] & ".xls"

 

[Randy]

That worked great, will this work the same for importing different file
names using transfer spreadsheet using a macro?

Randy,

Put an unbound textbox on a form which will be open at the time that you
execute your transferspreadsheet, and type the required name for the
exported file in this textbox. Then, in the File Name argument of the
macro, refer to this textbox using syntax such as...
="C:\YourFolder\" & [Forms]![YourForm]![YourTextbox] & ".xls"

--
Steve Schapel, Microsoft Access MVP

I need a way to name exported files (Excel) differently each day using
tranferspreadsheet in a macro. That is have the ability to name the
exported file at will, not be stuck with a preset file name the way it it
now. I hope this makes sense..Thanks..Randy

 

[Steve Schapel]

Randy,

I believe so.

--
Steve Schapel, Microsoft Access MVP

That worked great, will this work the same for importing different file
names using transfer spreadsheet using a macro?

Randy,

Put an unbound textbox on a form which will be open at the time that you
execute your transferspreadsheet, and type the required name for the
exported file in this textbox. Then, in the File Name argument of the
macro, refer to this textbox using syntax such as...
="C:\YourFolder\" & [Forms]![YourForm]![YourTextbox] & ".xls"

--
Steve Schapel, Microsoft Access MVP

I need a way to name exported files (Excel) differently each day using
tranferspreadsheet in a macro. That is have the ability to name the
exported file at will, not be stuck with a preset file name the way it

it

now. I hope this makes sense..Thanks..Randy