Export from Access 2000 into Excel 2000

[Kanaan]

Hi all,

I have a user who ran a report in Access 2000 and clicked on the option in the toolbar called Analyze It with MS Excel. It started to create the XLS file but right away gave this error:

"Microsoft Access can't complete the Output operation
The Visual Basic code you entered contains a syntax error or the Output procedures are not available."

I cannot find anything on Microsoft's Kbase about this. Any ideas?

Thx!

 

[genomon]

Have you tried adding a breakpoint to the VB code and debugging it line-by-line?

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.