Run time error 50034 method export of object vb component failed

**Libster78** · 01-30-2010, 07:36 PM

I keep getting this error on this line

Please Login or Register  to view this content.

I have scanned for registry errors but it is still happening can anyone help?

Thank you in advance
Libby

**shg** · 01-30-2010, 08:16 PM

Have you ticked Trust access to Visual Basic project?

**Libster78** · 01-30-2010, 08:38 PM

I think so. In 2007 in the trust centre I have allowed all acess to everything so I presume I have.
I'll double check. The rest of my code within the module works too.

**pike** · 01-31-2010, 05:16 AM

Libster78
dont you think this is a duplicate post!!!!!

you will need the enabled the reference "Microsoft Visual Basic for Applications Extensibility 5.3 Library"
have a look at the latest attachment !!!!
http://www.excelforum.com/excel-prog...modules-2.html
the reason why is because you have closed the workbookis the previous sub !!!!!!