Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to edit Deployed VBA Macro 3

Status
Not open for further replies.

sri91

Mechanical
Aug 29, 2019
42
IN
Hello All,
I have deployed some of the macros as vba projects in my company. Now I want to edit few lines of code in that. But as all the people are using that i can not edit that. Is there any way to over write it?
Can any one help me in this.

Thanks
Sri
 
Replies continue below

Recommended for you

Suppose the file is shared on a network location. The issue that can be found is that the catvba file is locked (by Windows OS on the server).

The first solution I did was to go into Computer Management and see the list of Open Files on the server, and force the files to close. This required IT to teach me and enable me to do it on the server. In reality, this is an IT department question and is probably never enabled to most people. So, you could request your IT help to do it for you. (By the way, I don't do that any more)

The second solution that some of my colleagues did was to end the macro code with a section that would call an external batch file. The batch file called a process killer program that would kill the 'CATVBAHostingApplication.exe' process on the user's PC. Not sure it's a great solution, but it seems to work. I didn't figure that one out, somebody who was savvy with programming did that.

Hope that helps point you in the right direction.

Mark
 
Thanks Mark and ferdo.

@Mark: First solution I cant depend on IT people every time. 2nd not asking about force stopping of catvba application. Users will be adding macro library that should be removed then only i can save the catvba file. how to do this.

@fedro: I am not sure how to remove library or kill by timer. Can you please explain.

Thanks
SURYASRI
 
Thanks ferdo for the info.
But I dont want to force close the form. I want to remove the added library in catia, then only I am able to edit the catvba project. Any help will be appreciated.

Thanks
Sri

 
We distribute a local copy of the vba project to the users. Any change to the original instance is pushed to the clients, and when they restart their CATIA, they get the new deployment.

regards,
LWolf
 
Thanks a lot LWolf.

I have created a shortcut of this and given to the users. Let me check whether it is working or not.

Thanks
Sri
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top