ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Reference Missing (https://www.excelbanter.com/excel-programming/427268-vba-reference-missing.html)

George Lee

VBA Reference Missing
 
After moving from an Excel 2007 computer to an Excel 2003 one, I am missing a
reference (to Excel 12), as I would expect. What I didn't excecpt is that now
I can't even open the code module but get an "Error in loading DLL."
Unchecking the reference doesn't work (same error).

How can I open the module?

How can I remove the reference?

Nigel[_2_]

VBA Reference Missing
 
I think you should disable macros when opening the workbook then edit the
code and save it as an xlsm.

--

Regards,
Nigel




"George Lee" wrote in message
...
After moving from an Excel 2007 computer to an Excel 2003 one, I am
missing a
reference (to Excel 12), as I would expect. What I didn't excecpt is that
now
I can't even open the code module but get an "Error in loading DLL."
Unchecking the reference doesn't work (same error).

How can I open the module?

How can I remove the reference?




All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com