| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple workbooks, one task
Please help to solve a puzzle!
I have excel file (workbook.1) with column A (old variables names) and column E (new variables names). On the other hand I got 40 excel files (workbook.2 .... .40), where those old variables names used here and there, sometimes in a middle of the text. The goal is to replace all old variables with the new ones. Exp.: if A5 has a match, replace with E5, and etc. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple workbooks, one task
Where are the 40 files ? in the same folder ? Are all the files of this
folder to be treated ? Regards. Daniel Please help to solve a puzzle! I have excel file (workbook.1) with column A (old variables names) and column E (new variables names). On the other hand I got 40 excel files (workbook.2 .... .40), where those old variables names used here and there, sometimes in a middle of the text. The goal is to replace all old variables with the new ones. Exp.: if A5 has a match, replace with E5, and etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated Excel Workbooks and Task Scheduler | Excel Programming | |||
| Same task for Multiple fields | Excel Programming | |||
| Multiple Task needed in Excel | Excel Discussion (Misc queries) | |||
| Viewing multiple excell spreadsheets on the task bar | Excel Discussion (Misc queries) | |||
| Multiple Excel on Task bar | Excel Discussion (Misc queries) | |||
Linear Mode
