Export to Excel

[dmgg]

Using Office 2007. I am trying to export some data to Excel. I would like to send to a specific worksheet but am satisfied now if I can just export the data. The simplest method that I tried is:

DoCmd.TransferSpreadsheet acExport, , "Query1", "C:\Users\Mine\Documents\TypesExamplesHints\Book1. xlsx", True

I get no error message and the excel file update time shows that it was updated when I sent the data. But, there is no data in the spreadsheet! Query1 is not blank. It does have one row of data. What am I missing? Any help much appreciated.

[June7]

The code works for me. Cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post.

[ranman256]

to a SPECIFIC WORKSHEET, you must assign it...

DoCmd.TransferSpreadsheet acExport, , "Query1", "C:\Users\Mine\Documents\TypesExamplesHints\Bo ok1. xlsx", True, "myWorksheet"

[dmgg]

After reading your reply, I reinserted the program cd, ran the repair feature. And, just for extra' ran a decompile procedure I found on google. It works now, but embarrassingly, I must say that it may have worked before. Without the "Sheet1" on end of expression, I found that there was a new worksheet "query1" created in the workbook and it had the data. It may have been there before.

Thank you so much for reply. I would just give up without this site.

I am sending this to both moderators as I don't know if you see the other reply.

The code works for me. Cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post.