I can compile fine ... no errors ... but the VBA does not stay compiled.
I open a file, Debug --> Compile, the Compile option is now diabled (meaning compilation was sucessful). Save the file, Close the file, Open the file ... Compile is enabled again (meaning the code is in an uncompiled state) .
I appreciate any insight and/or suggestions,
Steve
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
"VBA is not really a compiled language" - not relevant given the context of the Q.
"the application will simply compile the code as needed " - why waste resources?
The file says compiled just fine if not accessed via Citrix.
I have narrowed the issue down to Forms 2.0 controls. If I remove my form altogether then it stays compiled but seeing as it is a major part of the functionality this is not really an option.
Steve
I tested the "different path" scenario (I already determined that the FM20.dll is the same version) because my PC is XP and the Citrix server is Win2000 (both have Office 2003 SP3) ... I created a new spreadsheet while connected through Citrix, I added a form and then added 1 textbox onto that form and it will not stay compiled.
So even odder is that if I add controls directly onto a worksheet (yes I am using the Forms 2.0 controls and not the native Excel form controls) the code stay compiled.
I guess this is further evidence that I can try to get the server group to investigate what is up with the Citrix server.
Maybe I can see if they will log onto that box directly and see if we can recreate it directly there instead of going through Citrix.
This is all really long and roundabout chasing down sporadic "bad file" messages when opening the Excel files ... the code does actually execute correctly but I am just trying to eliminate anything that is not *perfect*
Steve
Business Accounts
Answer for Membership
by: roryaPosted on 2008-05-30 at 05:08:34ID: 21676937
VBA is not really a compiled language and the application will simply compile the code as needed at run-time anyway. Do you have any activex controls or workbook open code?