VBA- Open workbooks if cell B25 is >=5,000,000

[Chase1]

I want to begin by stating that I am a complete novice when it comes to VBA, and have looked for suitable code to no avail.

I'm using Excel 2007 and I am looking for VBA code to complete the following task:

1. VBA code to search through folders and subfolders
2. Open a closed workbook if cell B25 on the "Pricing Details (input)" worksheet is >= 5,000,000

There are hundreds of workbooks(different names), in each subfolder (approx 40).

Your assistance is greatly appreciated!

 

[Simon Lloyd]

you should be able to adapt this to open each workbook it comes across and check the range if it matches then move on to the next workbook without opening.
http://www.mrexcel.com/forum/showthread.php?t=494023

 

[Chase1]

Thanks Simon. I unfortunately don't have enough VBA knowledge to modify code. Any additional help that would help resolve my issue would be great!

 

[Chase1]

Can anyone else help?