Launch MS Visual Basic = Error in loading DLL

M

MDubbelboer

I just had my harddrive re-imaged. I'm using Windows XP SP2 with excel
2003.

I copied over my Personal.xls and Excel11.xlb from my backup and they
both seemed to work properly.

Problem is every time i run excel and go into the vba editor I get an
"Error in Loading DLL" error.
It'll only pop up the first time I go into the editor, but it will
happen with every instance of excel i have running.

Any idea what's going on? everything seems to be running properly but
it's annoying to get this message every time.

thanks in advance,
mark
 
J

Joel

Are you using OFFICE10, OFFICE11, OFFICE12? Make sure you are in the right
subdirectory XLSTART under OFFICEXX.
 
M

MDubbelboer

Alright, definitely a problem with my personal.xls

I tried deleting it and re-opening the file as an excel file (renamed
Personal_backup.xls) and when loading this file I get the error
message.
Might have to go back and export all my modules, userforms,
etc...that'll be a pain
 
J

Joel

there are two possiblities I can think of
1) Check you add-ins on your worksheet under Tools - Addins and make sure
you have selected the correct add-ins
2) check in VBA menu Tools - References and make sure you 've checked all
the libraries you are using.
 
M

MDubbelboer

K, well I cheated.
I opened my old Personal.xls as Personal_backup.xls. then disabled
macros on the file.
Then i was able to just drag and drop all the modules/userforms to the
new Personal.xls and everything seems to be working fine.

Still don't really know what went wrong but it seems to be working
now.

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