asked on

Best way to handle Outlook VBA code changes with users

I have found a solution that we have implemented with each user's outlook from the following question:

Q27835522

Going forward if we want to make changes we will now have to go and edit each users VBA code. Is there any way to have some code that would check for a file in a public file location and "update" the code? Say if we wanted to add/edit some conditions from the original code, or perhaps have the code check some sort of text table to determine conditions to check for? This would permit multi user changes without having to edit Outlook's VBA code for each work station.

Thank you.

Chris Bottomley

There is nothing we can do with the code itself but we can for example store the data values on the server, upload them when the script runs and process the user specific keywords that way .. and if that will help then we can certainly proceed on that basis.

Chris

ASKER CERTIFIED SOLUTION

p912s

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thandel

ASKER

So do I understand this correctly but I would have to first manually edit the code on a computer, copy that .OTM file and then distribute that same .OTM with a batch?

Is it possible to edit a .OTM file without having to use the Outlook VBA editor?

Chris Bottomley

I thought the intent was to change the conditions run by the code and this is perfectly feasible without code changes via a commonly named data file in the user area.

Chris

p912s

So do I understand this correctly but I would have to first manually edit the code on a computer, copy that .OTM file and then distribute that same .OTM with a batch? Yes

Is it possible to edit a .OTM file without having to use the Outlook VBA editor? No

thandel

ASKER

Ok perhaps I can have a batch file that on startup sees if there is a replacment OTM file and then if so replaces it. One final question, if the project is protected will the protection remain with the OTM replacement?

Chris Bottomley

Okay message received i'll leave you to it.

Chris