Building a dynamic file name using OutputTo

[Bill@DS]

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

 

[Steve Schapel]

Bill,

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