Solved

Write Macro or other method to search for word in a folder

Posted on 2014-09-17
4
61 Views
Last Modified: 2014-11-21
Need assistance writing a macro that can open every single excel file located inside a given folder, and find/replace as below.  Where the specified find is inside the body of the file or a part of the file name.  This could be two separate searches

Example
Find value1 and replace it with value2,
Find value3 and replace it with value4,
Find value5 and replace it with value6, and so on…
0
Comment
Question by:mcthomas00
4 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 40329135
Is the question above an extension of your existing question, "search folder to replace text"?

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28520596.html ]
0
 

Accepted Solution

by:
mcthomas00 earned 0 total points
ID: 40330312
yes, It appeared to not have submitted so I reposted.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40456949
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now