Macro to Validate Other Macros

P

pabsf3

I have some modules and macros in MSProject files that are distributed
to several client sites. Before they are run, I want to ensure that
they have not been modified, but I do want the clients to be able to
add their own modules and macros.

I am trying to write a macro that can check to see if
1) my module exists
2) if my module contains specific macros
3) if a checksum generated from the lines in those individual macros
match previously calculated values.

I cannot find an object to represent the module collection, the macro
collection, or the code in the macro, so I am not getting very far with
my code.

An alternate solution is to have the user export the modules to a text
file, using the Generic / Text Printer to File and then process the
result, but I would like to avoid that if possible.
 
J

Jan De Messemaeker

Hi,

Last year, when working on a similar procedure, Iwas faced with this
problem.
I dod not find the sort of solution you look for either.
In my case, the client was allowed own modules but not own macros in "my"
modules
This being said, to make sure all my modules were up-to-date, I simply
deleted them from his global (using on error resume next) then copied the
fresh version.

Even then, some users gave troubles because in their modules they yuse
public names I use as well...

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top