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

Access "OutputTo" Command HTML Template 0
Access "OutputTo" Command HTML Template 0
run-time error 2282 -- trying to write to Word 3
Menu Macro Not Executing - Need Help 1
VSTO C# add in Outlook.Appointment error 0
Autonumber field in Excel that behaves the same as Access 0
OutputTo Excel File Name 2
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0

Top