PDA

View Full Version : Solved: using macro to edit macro



benong
12-07-2010, 10:36 PM
hi,
is it possible to update an existing macro by running another macro?
eg. run macro A to edit the program/content/values in macro B.

Bob Phillips
12-08-2010, 01:00 AM
It is possible, but it is not a good idea. It is far better to code or each possibility, and then have a switch that controls which possibility is actually run.

benong
12-08-2010, 01:09 AM
thanks xld,
i need to change a value in many workbook macro frequently, so i was thinking about automating it.
Can you show me any online example/tutorial/script as i failed to search for one.

Bob Phillips
12-08-2010, 01:28 AM
It is not clear what editing you want to do, but Chip has a lot of info at http://www.cpearson.com/Excel/VBE.aspx

benong
12-08-2010, 01:41 AM
thanks xld :)