ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Replacing text in Excel files on disk? (https://www.excelbanter.com/excel-discussion-misc-queries/15502-replacing-text-excel-files-disk.html)

Desperate Don

Replacing text in Excel files on disk?
 
I wish to replace a text spring with another, in about 50 Excel workbooks.
Some of these strings are held in a ceIl alone, others are part of a formula.
To avoid opening all 50 workbooks and using Find/Replace, is there a utility
that works directly on the files themselves?

I don't want to write a macro to do this as most workbooks have multi-sheets
with some hidden sheets, snd possibly protected sheets as well. Messy.

I have found a few shareware/freeware programs, and got one to operate, but
they seem to skip the formulae.

A straight textual replace leaves the files unreadable by Excel. It seems
to need a special utility written for Excel.

Donald


All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com