Using Macro to export from Access to excel. Error message

[Guest]

I'm trying to export a table in access to excel. I get the error that the
"you tried to use a form,report,or datasheet that contains an OLE object, but
the OLE server(the application used to create the object) may not be
registered properly.Reinstall the OLE server to register it correctly.

I don't know what to do. Should I contact IT to have them reistall the OLE
server or maybe I can do it myself.

Thanks for the help

 

[John Nurick]

Hi William,

One of these articles may cover the case.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;302507
http://support.microsoft.com/default.aspx?scid=kb;EN-US;280557
If you have Access 2003, try the solution in the second article.

If this doesn't fix it, post back here.

 

[william Bull via AccessMonster.com]

I don't get this message if I try to use tools/ analyze with excel. I only
get it if I try to use the output to macro.

Thanks

 

[william Bull via AccessMonster.com]

I forgot to say that I did try this and it didn't change the error.

Thanks