View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Bedows Scott Bedows is offline
external usenet poster
 
Posts: 1
Default 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