OutputTo excel gets Run-Time error 2282 in Access 2000




I have a command button to export a forms data to an excel
spreadsheet. Works fine in Access 2002. Here's the code.

DoCmd.OutputTo acOutputForm, "frmFormName", acSpreadsheetTypeExcel9,
CurrentProject.path & "\" & "SpreadSheetName.xls", True

But in Access 2000, I get a Run-Time error 2282 (formats are missing
from the Windows Registry). I could use the TransferSpreadsheet
method, but then I don't get some calculated fields that are only on
the form.

Anyone know what to do to get the OutputTo method to work in Access


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