TransferSpreadsheet Range?

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

Hi experts,

using Access '03...

I need a macro that transfers the results of an .mdb query to a
preexisting .xls doc.

I accomplished most of this by creating a transferspreadsheet macro
and populating the Range argument of the macro.

Problem is, however; I want the macro to create a new spreadsheet
everytime the macro executes (the query is a monthly report) without
user intervention. I tried to code the range arguement with something
like: Date() & "monthly" >> This argument, however, takes all text
literally and the spreadsheet name comes out Date___monthly.

I need to code this argument (Range) with something that will
automatically change the spreadsheet name each time the macro runs,
else, it will overwrite whatever is in the Range argument. Any
suggestions?

alex
 
Range argument for the macro would look like this:

=Date() & "_monthly"

Be sure to include the = sign at the beginning of the argument.
 
Thanks Ken...never thought to use =

alex
Range argument for the macro would look like this:

=Date() & "_monthly"

Be sure to include the = sign at the beginning of the argument.
Click to expand...
 
Back
Top