| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic replace of VBE code for multiple files
Automatic replace of VBE code for multiple files I have few excel files with "C:\Documents and Settings\" couple of time in the VBE code and in the sheet itself. Is it possible to loop via al the files (they are all saved in the same folder) and automatically replace "C:\Documents and Settings\" with "C:\Dan\" both in the code and on the sheets Many thanks, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tidy up multiple find and replace code | Excel Worksheet Functions | |||
| Automatic update multiple files | Links and Linking in Excel | |||
| Modify macro code to export multiple cell contents to multiple Text Files | Excel Programming | |||
| VBA in Microsoft Excel: Find & Replace method macro across multiple files | Excel Programming | |||
| Serach and Replace across multiple files | Excel Programming | |||
Threaded Mode
