Hi.

I have about 100 files that have the same embedded macro in them. I
need to update one of the functions that is contained in the macro
code.

I know how to loop through all the files, open each one, and save/
close them.

What I don't know how to do is modify the embedded macro functions.

Can someone please tell me how I can replace a function with a new one
automatically so I don't have to open the code editor for each one.

Thanks