Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Make visual basic truely visual! | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |