Hi community,
I have a problem that reared its ugly head with how VBA acts.
We have a VBA project that we load from a server so that our users can have the same commands for regular everyday work.
We also have templates that have embedded projects in them so we can send the file to other offices on a needs basis.
In these templates I have tied AutoCAD system commands to specific modules in the embedded code.
Some of the code is duplicate between the server project and the embedded project, although the embedded project is self referencing.
The problem:
When I open AutoCAD in morning, I am usually the first and therefore gain control of the server VBA project so I can write and save the project throughout the day.
When other users try to to run the commands that are tied to AutoCAD system commands (in the embedded project), AutoCAD locks up for about a minute, and when it completes its cycle, nothing has happened.
I close AutoCAD to release control of the server code and the next person who gains control can then run the AutoCAD system commands successfully on the embedded projects.
Also If I unload the server project from another user (who does not have control) and restart AutoCAD, that user can run the embedded commands.
We need to be able to run the embedded project on the template from a computer that does not have control of the server project code.
Any help would be greatly appreciated.
