Hey folks, new here, but lurked forever.
I am using Excel07.
Here is my problem:
I want to open 2 raw data files- already in .xlsx format. (one 30 days in the past and one 14 days in the past) and paste each of the files to a new workbook. Each raw data file contains only one worksheet.
The names of the raw data files are their dates (MMDDYYYY).
Ex.: Today is 6/8/11- the 30 day file is named 05092011.xlsx and the 14 day file is named 05252011.xlsx.
The 30 day file will be pasted into Sheet1 of the new workbook.
The 14 day file will be pasted into Sheet2.
Thanks in advance for your help.
I am using Excel07.
Here is my problem:
I want to open 2 raw data files- already in .xlsx format. (one 30 days in the past and one 14 days in the past) and paste each of the files to a new workbook. Each raw data file contains only one worksheet.
The names of the raw data files are their dates (MMDDYYYY).
Ex.: Today is 6/8/11- the 30 day file is named 05092011.xlsx and the 14 day file is named 05252011.xlsx.
The 30 day file will be pasted into Sheet1 of the new workbook.
The 14 day file will be pasted into Sheet2.
Thanks in advance for your help.
Last edited:
