Visual Basic v6.3 and Excel v2002
 

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?

Visual Basic v6.3 and Excel v2002
 

See www.cpearson.com/Excel/VBE.htm for example code that you can adapt to
your purposes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Shapirotwin1" wrote in message
...
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?