Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Code in Macro to specify file/folder to look in. | Excel Programming | |||
VBA code to change registry value of existing DSN | Excel Programming | |||
Macro code to change tab name | Excel Programming | |||
macro code to change file-opening password | Excel Programming | |||
Macro to change Macro code? | Excel Programming |