Docmd.SendObject raises error 2282

[Carlos E. Mosquera]

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 bas
http://support.microsoft.com/default.aspx?scid=kb;en-us;226526 fo
Article 226526. I am a Microsoft Ceritified Professional and I coul
have cleared this up a long time ago. There are many forums with thi
similar error. The guys apparently didn't do enough research t
realize that you have an unneeded reference checked in your VBA Projec
References. Go to References and make sure Visual Basic fo
Applications Extensibility 5.3 is unchecked. Then re-run your code.
Waaa laah. Fixed! You're welcome. Spread this to all the forums