Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listing which documents were changed by macro
I have a macro which goes through hundreds of documents
and changes old product names to new product names. This uses Excel's find and replace functions. After the macro is finished, I would like to have a list of which documents were changed and which were not. I have to redistribute hard copies of the documents that were changed, so I don't want to worry about the documents that were not changed. Is there a way to know whether a find/replace search for a document made any changes or not? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro in worksheet with changed name | Excel Discussion (Misc queries) | |||
Listing multiple values in a macro | Excel Worksheet Functions | |||
Listing of excel files in My Documents | Excel Discussion (Misc queries) | |||
Macro name listing | Excel Programming |