migration tool that reads macro code

[Ellen]

Does anyone know if there is a migration tool available
that will search macro code for UNC/drive mappings? We
are moving from Novell to W2K servers and need to find a
tool to help us convert our macros. We need to do this
for all the office products, but word is the one we are
going to have the most conversion issues with.

 

[Jezebel]

I just had exactly this problem on a huge Access project. I wrote a simple
VB app that iterated the code modules:

Application.VBE.VBProjects(...).VBComponents(...)

The VBComponent object has a Find method (in my case it was sufficient to
search for :\ and \\) to find the lines that may need changing, and a
Replace method to insert the corrected line.

Alternatively, you can export the code modules. Open them as text files,
Find and Replace, re-import.