Export to Excel

[mikeyb540]

Hello, got a strange problem

I have a command button on a form that exports a Query to Excel.
<b>Private Sub Command11_Click()
DoCmd.OutputTo acOutputQuery, "qryMonthly", acSpreadsheetTypeExcel9, , True
End Sub</B>

On click I get the following Run-Time Error

<b>Run-Time Error 2282
The formats that enable you to output data as a Microsoft Excel, rich- text format, MS-DOS text, or HTML file are missing from the Windows Registry</b>

Any idea whats the problem? Am I missing Controls?

Txs in Advance,
Mike

 

[PHV]

Maybe the conversion filters aren't installed.
Have you tried the DoCmd.TransferSpreadsheet method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mikeyb540]

Txs PHV for the feedback.

The problem is that it works on other Win 2000 PCs with Access 2000. Just one of the PCs has this issue.

All the Access and Excel components with the sample databases are installed. Any other ideas?

 

[mikeyb540]

Can anyone help?

 

[Terpsfan]

I would uninstall and reinstall Office 2000 on the offending PC with all options selected.

 

[mikeyb540]

aha...found the nasty bug...well FYI

DoCmd.OutputTo acOutputQuery, "qryMonthly", acFormatXLS

 

[gillianleec]

What does the mean?

 

[mikeyb540]

just a typo...was trying to make it Italic

DoCmd.OutputTo acOutputQuery, "qryMonthly", acFormatXLS