Exporting different file names?

  • Thread starter Thread starter Randy
  • Start date Start date
R

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
 
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"
 
That worked great, will this work the same for importing different file
names using transfer spreadsheet using a macro?
Steve Schapel said:
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
Click to expand...
Click to expand...
 
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
Click to expand...
it
now. I hope this makes sense..Thanks..Randy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top