Bulk Macro Update Utility

[Joseph]

Does anyone know of or already have a util or macro that can open multiple
..dot and add/edit/delete pre-existing macros? I have about 4500 templates
that I need to go back and edit.

Thanks,

Joseph

 

[Word Heretic]

G'day "Joseph" <[email protected]>,

I do the coding myself for 4GL projects like this. You combine the
batch file processor at http://word.mvps.org/FAQs/index.htm along with
some iterations of each Documents(n).VbProject.VbComponent(n)

If you need commercial help with this, contact me offlist. I have done
this sort of thing several times.

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Joseph reckoned:

 

[Peter Hewett]

Hi Joseph

Do you mean 4,500 templates or documents. I work with some large organisations (1400+
users) and they run at something in the region of 450 corporate templates!

Yes you can use either the Word Application.FileSearch object or the FileSystemObject
object to create a list of files that you can then iterate over and modify. It's pretty
simple.

The tricky bit is modifying the code, it's quite doable, but it depends on exactly what it
is you have to change. Maybe you can provide more info on these two points.

HTH + Cheers - Peter