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..
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..