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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferSpreadsheet macro action is not available. 1
NO Transferspreadsheet option in 2007? 1
TransferSpreadsheet 4
Send Results of Two Queries to One Spreadsheet 3
cannot expand named range 1
Question about "TransferSpreadsheet" action 4
Transferspreadsheet w/multiple worksheets 2
MIssing Transferspreadsheet Action 1

Top