ranuse
11-02-2010, 11:30 AM
Hi,
I'm trying to figure out how to write code that will check a specified directory for all excel files starting with "Project" in their file name. If the project workbooks are found, the macro should open each workbook, one at a time, and compare cell A1 of that workbook with cell C1 of the orginal workbook (the workbook that contains the macro).
Cells A1 and C1 should be in date format (e.g., 11/01/10) and the comparision should check if A1 is less than C1.
If true, copy A1 into a temporary variable stored in the original workbook and close project workbook. If false, do nothing and go to next workbook wih "Project" in file name. Loop until all files with "Project" in name have been checked.
Thanks very much for your help and time.
I'm trying to figure out how to write code that will check a specified directory for all excel files starting with "Project" in their file name. If the project workbooks are found, the macro should open each workbook, one at a time, and compare cell A1 of that workbook with cell C1 of the orginal workbook (the workbook that contains the macro).
Cells A1 and C1 should be in date format (e.g., 11/01/10) and the comparision should check if A1 is less than C1.
If true, copy A1 into a temporary variable stored in the original workbook and close project workbook. If false, do nothing and go to next workbook wih "Project" in file name. Loop until all files with "Project" in name have been checked.
Thanks very much for your help and time.