Hi,

I am using individual excel files in separate folders to store inspection plans for thousands of parts. I have created close to 3,000 excel files, and now I am told I need to change the header and footer, or else we may get dinged in an audit. I need a way to cycle through each folder (which we will call MOLD#) in a main folder (which we will call Q), and open every excel file in the folder called INSPECTION PLAN, and change the footer/header.

Q
~~MOLD#1
~~~~INSPECTION PLAN
~~~~~~Excel file1 <------ need to change this
~~MOLD#2
~~~~INSPECTION PLAN
~~~~~~Excel file1 <------ need to change this
~~~~~~Excel file2 <------ need to change this
etc....

Also to complicate things, the folder INSPECTION PLAN may or may not exist. If it doesn't exist, then it should just skip to the next MOLD#.

I can take care of the rest of the programming, I just cannot seem to find a program to do the folder cycling I am looking for. Any help will be much appreciated.