| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - open text file, replace text, save file?
I have a spreadsheet with 287 rows.
Column 1 is a short text string. (string1) Column 2 is a slightly different text string. (string2) I need to search through approximately 25,000 short text files (in a variety of different folders) and REPLACE all occurences of string1 with string2. Can I [fairly easily] write a VBA routine to do this automatically? It's going to take me DAYS to make all the changes by hand. If I can't do it with Excel is there another tool that would do the trick? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an excel file as a file with undelimited text | Excel Discussion (Misc queries) | |||
| How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
| How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
| Excel VBA to save .xls file as UTF-8 text file | Excel Programming | |||
| Open delimited text file to excel without changing data in that file | Excel Programming | |||
Threaded Mode
