Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in hidden module
Hello all,
We have developed a VBA-program in Excel 97 which works fine in Excel 2000 and Excel XP but when we test it with Excel 2003 we recieve the error message "Compile error in hidden module: Module 1". Does anyone know the reason to this error message? Totte |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in hidden module
Hello,
Try opening the Visual Basic Editor, then go to <Tools then <References and look for missing references. Uncheck them. You may need to locate current versions of some of them, or it may be okay to just uncheck the missing ones... HTH "Totte" wrote: Hello all, We have developed a VBA-program in Excel 97 which works fine in Excel 2000 and Excel XP but when we test it with Excel 2003 we recieve the error message "Compile error in hidden module: Module 1". Does anyone know the reason to this error message? Totte |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in hidden module
"XP" skrev i meddelandet
... Hello, Try opening the Visual Basic Editor, then go to <Tools then <References and look for missing references. Uncheck them. You may need to locate current versions of some of them, or it may be okay to just uncheck the missing ones... HTH "Totte" wrote: Hello all, We have developed a VBA-program in Excel 97 which works fine in Excel 2000 and Excel XP but when we test it with Excel 2003 we recieve the error message "Compile error in hidden module: Module 1". Does anyone know the reason to this error message? Totte Thanks for the tip! Totte |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in hidden module
Hi,
I had the same problem. I found a .XLA -file from Adobe in the XLSTART folder in OFFICE11. I deleted it and then it worked fine. It was from an old Adobe Acrobat product. Thanks for the other tip though "Totte" wrote: "XP" skrev i meddelandet ... Hello, Try opening the Visual Basic Editor, then go to <Tools then <References and look for missing references. Uncheck them. You may need to locate current versions of some of them, or it may be okay to just uncheck the missing ones... HTH "Totte" wrote: Hello all, We have developed a VBA-program in Excel 97 which works fine in Excel 2000 and Excel XP but when we test it with Excel 2003 we recieve the error message "Compile error in hidden module: Module 1". Does anyone know the reason to this error message? Totte Thanks for the tip! Totte |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in hidden module
Totte Wrote: Hello all, We have developed a VBA-program in Excel 97 which works fine in Excel 2000 and Excel XP but when we test it with Excel 2003 we recieve the error message "Compile error in hidden module: Module 1". Does anyone know the reason to this error message? Totte The references are most likely missing however because it says Hidden module more than likely the project is protected. does this workbook email itself or anything. as a lot of time it has a reference to outlook say 2000 or xp then you try 97 it does not recognise it. you will find if you have the complete package of office 2000 and xp. if you run the workbook on 2000 save the file open it on xp it save it then try open the file again in 2000 you should get the same message this is because it can upgrade the references but not the downgrade them. hope this helps as i have had similar problems with a workbook which emails data off. -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=516859 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compile error in hidden module | Excel Discussion (Misc queries) | |||
Compile Error in Hidden Module: | Setting up and Configuration of Excel | |||
Compile error in hidden module | Excel Programming | |||
compile error in hidden module | Excel Programming | |||
Compile error in hidden module | Excel Programming |