| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to edit VB code programmatically
All,
I have a large set of excel files with which I need to add a VB module then Find and Replace existing VB code with new VB code. Is there a way to do this programmatically? In other words I don't want to manually open every Excel file, add the module, and then run the Find and Replace. Instead Id like to build a program/script to handle it all. Any help would be appreciated. Thanks in advance! -- J |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to edit VB code programmatically
Take a look at www.cpearson.com/excel/vbe.htm
-- HTH RP (remove nothere from the email address if mailing direct) "Jon" wrote in message ... All, I have a large set of excel files with which I need to add a VB module then Find and Replace existing VB code with new VB code. Is there a way to do this programmatically? In other words I don't want to manually open every Excel file, add the module, and then run the Find and Replace. Instead I' d like to build a program/script to handle it all. Any help would be appreciated. Thanks in advance! -- J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace Code Programmatically | Excel Programming | |||
| How to programmatically access sheets in a workbook by code name | Excel Programming | |||
| Excel VBA - How do I programmatically change source code in another file? | Excel Programming | |||
| Programmatically open / edit vba-editor | Excel Programming | |||
| how to add code programmatically to a macro for a button | Excel Programming | |||
Linear Mode
