OutputTo excel gets Run-Time error 2282 in Access 2000


S

Sierras

Hello

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
2000?

Thanks..
 

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


Top