there is a visual basic macro I need to updated in a workbook. There are
well over 100 workbooks that need this update. There are also many changes
to the worksheets in the workbooks. I have written several procedures that
update the worksheet data in an separate workbook that automatically runs
when opened, but I don't know how, within this macro, to execute getting to
visual basic and editing the macro that needs to be updated. Can anyone
point me in the right direction?
Chip Pearson - 14 Sep 2007 22:03 GMT
See www.cpearson.com/Excel/VBE.htm for example code that you can adapt to
your purposes.

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
> there is a visual basic macro I need to updated in a workbook. There are
> well over 100 workbooks that need this update. There are also many
[quoted text clipped - 6 lines]
> visual basic and editing the macro that needs to be updated. Can anyone
> point me in the right direction?