Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch MS Visual Basic = Error in loading DLL
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch MS Visual Basic = Error in loading DLL
Are you using OFFICE10, OFFICE11, OFFICE12? Make sure you are in the right
subdirectory XLSTART under OFFICEXX. "MDubbelboer" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch MS Visual Basic = Error in loading DLL
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 On May 30, 8:40 am, Joel wrote: Are you using OFFICE10, OFFICE11, OFFICE12? Make sure you are in the right subdirectory XLSTART under OFFICEXX. "MDubbelboer" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch MS Visual Basic = Error in loading DLL
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. "MDubbelboer" wrote: 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 On May 30, 8:40 am, Joel wrote: Are you using OFFICE10, OFFICE11, OFFICE12? Make sure you are in the right subdirectory XLSTART under OFFICEXX. "MDubbelboer" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch MS Visual Basic = Error in loading DLL
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 On May 30, 8:58 am, MDubbelboer wrote: 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 On May 30, 8:40 am, Joel wrote: Are you using OFFICE10, OFFICE11, OFFICE12? Make sure you are in the right subdirectory XLSTART under OFFICEXX. "MDubbelboer" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
MS Visual Basic error | Excel Discussion (Misc queries) | |||
MS Visual Basic error on Launch | Setting up and Configuration of Excel | |||
Loading a linked spreadsheet, Microsoft Visual Basic, error while. | Excel Discussion (Misc queries) | |||
Problems Loading Analysis ToolPak when automating from Visual Basic | Excel Programming |