TransferSpreadsheet Macro

S

steve12173

I have a query that gives me sales figures for our department. I am trying
to create a macro to export these numbers to Excel. I have tried the
Transferspreadsheet Action but, I get an error saying that I must use an
updateable query. I already have an Excel spreadsheet created with two
different worksheets for two different queries (qryReps and qryDepartment).
 
S

Steve Schapel

Steve,

Can you please let us know the full details of the macro? I am puzzled
about where the problem lies at the moment. I know of no requirement for a
TransferSpreadsheet to be based on an updateable query, so I am wondering
what else may be going on. Thanks.
 
Top