Opening Excel files in same folder through a Macro - but not subfolders?

Hi All,

I have over 300 excel documents i want to put some code into, so i am creating a Macro that runs in one, and then opens up each Excel document it finds in a specified directory, puts in the characters i need,and then closes them.

I've created a test one to try it out, and my code is as below... and it works!! Just one problem though - it opens all Excel documents in the specified folder, but it does not open any in subfolders (which is where most of the actual documents will be).

Can anyone offer a suggestion as to how to make it work for sub-folders too? Thanks in advance

PS - I am using Excel 2007, most searches ive found say to use a ".SearchSubFolders = False" line, which i believe only works in pre-2007 software?

Please Login or Register  to view this content.

If it's not clear what Arlu meant, EDIT post #1, click the GO ADVANCED button, then highlight the code in your post, then click on the # icon to wrap it all in code tags, looks like this when done:

Please Login or Register  to view this content.

Be sure to take a moment to read all the helpful forum rules, link is above in the menu bar.

This method will open all the first level subfolders in the main folder you indicate:

Please Login or Register  to view this content.

One level deeper?

Try this to go one level deeper, it will not process files in the first level of subfolders, but will process the files in the SUB-subfolders:

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.