Update Microsoft Project VBA code without opening Project

[pruettae]

Is there a way to modify VBA Code within Project without opening the file?

I currently have code that runs when a project file opens, it opens a global
file that contains specific coding that is used by every project file we
have. The global file is going to be moved to a different location and I do
not want to open each individual project file and make this change manually.

Is there a way to create a piece of code in .Net (or some other language)
that will open the VBA code of a project file and make the appropriate change
without harming the existing project file?

Thanks.

 

[Rod Gill]

You can't modify the code remotely but when opening a file, hold the shift
key down and auto-open macros won't run. This works in all Office programs.

I would re-design the code so the location of the common file is either in a
registry entry or in a text file that your vba code reads which can be
remotely replaced by your IT team when a change is required.


--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com