Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error HELP !
Hi experts,
I made an application on my pc (XP, Excel 2003) I compiled my application and it works fine on this pc. Then i copied the application to another PC (XP, Excel 2002) and tried to start the application. It did not work and i got the following messages - compile error in hidden module i went to VBA and put in the password and then i tried to compile the project again. then i got the message - cannot find project or library and the program stopped at a line with CHR (13) in it. i clicked OK and the program jumps to the menu extra, references, to Ref Edit Control Does anybody know what the cause of my problem could be ? Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error HELP !
after the error, go to Tools=References in the VBE and you should find at
least on reference marked as MISSING. If so, you need to correct this reference. If it is not needed, then uncheck it. (you might have to close and reopen the file to do this). If you need it, then you need to use the browse button to find the file referenced. -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:58ebc8a4d6222@uwe... Hi experts, I made an application on my pc (XP, Excel 2003) I compiled my application and it works fine on this pc. Then i copied the application to another PC (XP, Excel 2002) and tried to start the application. It did not work and i got the following messages - compile error in hidden module i went to VBA and put in the password and then i tried to compile the project again. then i got the message - cannot find project or library and the program stopped at a line with CHR (13) in it. i clicked OK and the program jumps to the menu extra, references, to Ref Edit Control Does anybody know what the cause of my problem could be ? Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error HELP !
Hi Tom,
You were right, i was missing ms office web components. However, i would like to distribute my application throug several outlet which all have different excel versions (all 2000). Is there a way to prevent this from happening somewhere in the future ? thanks, Pierre Tom Ogilvy wrote: after the error, go to Tools=References in the VBE and you should find at least on reference marked as MISSING. If so, you need to correct this reference. If it is not needed, then uncheck it. (you might have to close and reopen the file to do this). If you need it, then you need to use the browse button to find the file referenced. Hi experts, [quoted text clipped - 16 lines] Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error HELP !
Perhaps use Late Binding:
http://support.microsoft.com/default...b;EN-US;244167 INFO: Writing Automation Clients for Multiple Office Versions http://support.microsoft.com/default...b;en-us;245115 INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com/default...b;en-us;247579 INFO: Use DISPID Binding to Automate Office Applications Whenever Possible -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:58ed43538f6ee@uwe... Hi Tom, You were right, i was missing ms office web components. However, i would like to distribute my application throug several outlet which all have different excel versions (all 2000). Is there a way to prevent this from happening somewhere in the future ? thanks, Pierre Tom Ogilvy wrote: after the error, go to Tools=References in the VBE and you should find at least on reference marked as MISSING. If so, you need to correct this reference. If it is not needed, then uncheck it. (you might have to close and reopen the file to do this). If you need it, then you need to use the browse button to find the file referenced. Hi experts, [quoted text clipped - 16 lines] Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |