From: mls via AccessMonster.com on
I have a button when clicked does the following ..

DoCmd.OpenQuery "qry_ExpToXl_LotNo"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qc_details", "c:
\work\QC_Details.xlsx", True

transfersheet fails if I use .xlsx , i.e I could not open the spreasheet
after creation, but it works fine if I give .xls extension.

Any thoughts?

Thank you

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201004/1