Launch MS Visual Basic = Error in loading DLL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MDubbelboer - 30 May 2008 15:26 GMT

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

Reply to this Message

Joel - 30 May 2008 15:40 GMT

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

> I just had my harddrive re-imaged. I'm using Windows XP SP2 with excel
> 2003.
[quoted text clipped - 12 lines]
> thanks in advance,
> mark

Reply to this Message

MDubbelboer - 30 May 2008 15:58 GMT

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

> Are you using OFFICE10, OFFICE11, OFFICE12? Make sure you are in the right
> subdirectory XLSTART under OFFICEXX.
[quoted text clipped - 15 lines]
> > thanks in advance,
> > mark

Reply to this Message

Joel - 30 May 2008 16:09 GMT

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.

> Alright, definitely a problem with my personal.xls
>
[quoted text clipped - 23 lines]
> > > thanks in advance,
> > > mark

Reply to this Message

MDubbelboer - 30 May 2008 16:13 GMT

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

> Alright, definitely a problem with my personal.xls
>
[quoted text clipped - 23 lines]
> > > thanks in advance,
> > > mark

Reply to this Message