Export Query Results to New Spreadsheet

C

Carlee

Hi,
I have a query called 'SystemResults' that i want to be able to export to a
new spreadsheet by clicking a button. I have tried the transfer spreadsheet
technique but havent gotten the syntax right. Can anyone help me?
 
J

Jeanette Cunningham

Carlee,
for explanation of the syntax, type TransferSpreadsheet in the immediate
window, put the cursor in the word and press F1.
If you care to post the code that doesn't work with a little detail about
what you are trying to do, it makes it easier for us to help you.


Jeanette Cunningham -- Melbourne Victoria Australia
 
C

Carlee

hello,
I have looked at the help section, and have attempted to fix the problem,
but to no avail. Could i garner a bit more assistance?
 
J

Jeanette Cunningham

Carlee,
which is the bit that doesn't work?
Would you give us a copy of the code that doesn't work.
In the code window, highlight and copy that line of code and post it into
your reply here and send it.
Please give details of version of Access and version of Excel.


Jeanette Cunningham -- Melbourne Victoria Australia
 

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

Export Access Query to Excel 7
Export to Passworded Excel spreadsheet 1
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
Using DAO to export access query results to excel 5
Exporting separate query results to same workbook diff worksheets 2
Exporting multiple queries into Excel workbook tabs 10
Export to Pocket Excel 1
export query and add date to file name? 3

Top