How to edit Deployed VBA Macro 3

[sri91]

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

 

[MarkAF]

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

 

[ferdo]

Another solution is to put a timer to close it (I do this for my vb.net apps).

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[sri91]

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

 

[ferdo]

Google

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[sri91]

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

 

[LWolf]

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

 

[sri91]

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