Building a dynamic file name using OutputTo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to automatically change the spreadsheet name each time i
export data from an Access query using the OutputTo action? The output file
name needs to consist of (1) some literal values, (2) a variable entered into
the form the user uses to start the process, and (3) a value from a second
query based on a value also entered into the form
 
Bill,

Yes, in the Output File argument of the macro, use an expression to
concatenate the pieces of the required path/file name together.
 
Back
Top