Macro to Replace A Value in Multiple Files

Question

Hi,

I am wondering if a macro could be written to replace a value in a specific cell in several files.  I have about 100 files located in several different folders that all need to have a value in a formula updated each month.  The formula is in cell C11 in each file and normally I would just replace the 08 with an 09 in each file each month.  I am hoping that a macro would save me the trouble of opening each file to do this update.  The files are located in 6 different folders (based on city office location), so I am wondering if the macro could "ask" which folder to do the replace process in.  For this month I need to replace an 08 in the formula with an 09.

Thanks you very much for your time and expertise!

Patrick

Answer 1

Suggest you check out Ron deBruin's site for code.

http://www.rondebruin.nl/win/s3/win010.htm

Gord

Answer 2

I am not equipped at present to assist with code for your project.

Have a browse through these search results.

https://search.yahoo.com/yhs/search?p=excel+make+same+change+to+all+files+in+a+folder&ei=UTF-8&hspart=mozilla&hsimp=yhs-003

Gord

Answer 3

Thanks Gord.  I looked at the website you stated and I don't see where the cell to be changed is located.  The cell due to change has a formula in it and I just need to change part of that formula.  In the past I have recorded a macro to replace the "08" with an "09".  I am just not good enough with VBA to revise what is on the website to what I need.  Any chance you can help me with that.

Thanks