What is equivalent to "acSpreadsheetTypeExcel9" in 2007 i.e .xlsx

  • Thread starter mls via AccessMonster.com
  • Start date
M

mls via AccessMonster.com

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
 

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

Top