Naming files automatically

  • Thread starter Thread starter grantschneider
  • Start date Start date
G

grantschneider

I am running OutputTo macro that takes a query and exports it to
excel. I would like it to automatically make the file name one of the
fields in the form that I use to run the query.

Currently I have the Output File set to: S:\Sales\Grant Temp\Exports
\Forms!SVP!SVP.xls

this does not work. Is this eveen possible. I have tried 4
combinations.
 
Hello "".

I am running OutputTo macro that takes a query and exports it to
excel. I would like it to automatically make the file name one of
the fields in the form that I use to run the query.

Currently I have the Output File set to: S:\Sales\Grant Temp\Exports
\Forms!SVP!SVP.xls
Click to expand...

Try this:
="S:\Sales\Grant Temp\Exports\" & Forms!SVP!SVP & ".xls"
 
Back
Top