Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes if project is not compiled (urgent help please!)
Hi,
I wonder if it is possible to compile my project on startup. The problem is, I protect my project with a password. If I switch from Office XP to Office 2003, it crashes. The reason is, it only works if it is compiled on the same excel version. If I compile my project on XP, it works on XP. If I open the project on 2003 (without macro's enabled), I can see the Compile Project is Black (not greyed out), so if I compile it on 2003, save it and close it, it works on 2003! I tried with sendkeys to open the code, but I cannot accomplish to send the password. Can anyone help (is there a command in VBA that enforce a compilation on startup?). I found this command vWB.VBProject.MakeCompiledFile but it does not seem to work. Thanks! Jos Vens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help -- URGENT -- need to resolve the issue before submittingmy project | Excel Discussion (Misc queries) | |||
Time calculation problem (URGENTProject due) | Excel Discussion (Misc queries) | |||
Compiled Excel macros | Excel Discussion (Misc queries) | |||
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. | Excel Programming | |||
call VBA compiled code within vba | Excel Programming |