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

here is a web site that has a lot of code examples to modify other code

http://www.cpearson.com/excel/vbe.htm

It's a good starting point

david

"Scott Bedows" wrote:

> 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

Scott:

You may also want to consider add-ins. This way the macros are all kept
seperate and easy to update.

Although it is more difficult to move the file around because the code is in
the addin and that does not get copied.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"dkinn" wrote:

> here is a web site that has a lot of code examples to modify other code
>
> http://www.cpearson.com/excel/vbe.htm
>
> It's a good starting point
>
> david
>
> "Scott Bedows" wrote:
>
> > 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