Using Macro to export from Access to excel. Error message


G

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
 
Ad

Advertisements

W

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
 
Ad

Advertisements

W

william Bull via AccessMonster.com

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

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top