Export Query Results to New Spreadsheet

  • Thread starter Thread starter Carlee
  • Start date Start date
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?
 
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
 
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?
 
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
 
Back
Top