Docmd.SendObject raises error 2282

[Guest]

Hi,

I have some applications in Access 2000 to send reports in emails, and
install Office XP in my PC yesterday. This applications ran on my laptop for
one year with Office 2000.

Now when try to run sendobject (reports) with excel format raise an 2282
error, but not with snapshot and html formats.

I was looking for some answer and just find about snapshot sends errors, not
for excel.

I try changing code using cuotes, adding codes, using acFormatXLS constant,
"Microsoft Excel (*.xls)" string, "MicrosoftExcel (*.xls)" with same result.
Also asigned this values to a variant and string variable.

Also verify if msexcl40.dll and ACCWIZ.DLL was defined in registry.

Someone know what is happening???

 

[AverageBear]

Ignore the rediculous resolution at Microsoft's Knowledge base http://support.microsoft.com/default.aspx?scid=kb;en-us;226526 for Article 226526. I am a Microsoft Ceritified Professional and I could have cleared this up a long time ago. There are many forums with this similar error. The guys apparently didn't do enough research to realize that you have an unneeded reference checked in your VBA Project References. Go to References and make sure Visual Basic for Applications Extensibility 5.3 is unchecked. Then re-run your code. Waaa laah. Fixed! You're welcome. Spread this to all the forums!