Ammending Excel Macros
I am currently upgrading our infrastructure which involves new equipment hosted in a different place. As part of the data move we have huge amounts of Excel spreadsheets which have entries in their macros pointing to a particular server. Does anyone know of any tools available whereby I can interrogate macro's remotely and ammend entries within the macros which point to a particular URL? The current version is office 2003 which has been updated to 2007 in the new environment.
Updating workbook macros
Hi
It's possible to look up for files, open them and update a complete module but quite tough, and tougher for a piece of code like your server path. Through a network, it might be tougher. Old posts may provide all these codes.
Can you replace some of these files by a new version ?
Do you need to replace the code sheets or just the path string ?
For future developpements, you may use add-ins are the recommended excel solution for better deployment/distribution.
http://www.ozgrid.com/VBA/excel-add-in-create.htm
Here's some ways to set up add-in update for future workbooks : http://www.jkp-ads.com/articles/updateanaddin.asp