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

Can I use code/macro to change code/macro in an existing file?
 

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

Can I use code/macro to change code/macro in an existing file
 

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