Can I use code/macro to change code/macro in an existing file?
I have a rather extensive excel file (131 pages and 4MB) that it used by 80
different users each in a remote location. I'm trying to make some updates
to the file without copying over each users copy of the file. I thought
about writing a macro/code to make changes to the necessary cells/worksheets,
which I can do. Where I'm running into problems is that some of the changes
need to be made to a few of the macros. Is it possible to setup one excel
file macro to change the macros in another file? If so, how?
Thanks so much,
Scott
|