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 :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.