Hello,
I need to copy all workbooks in a folder (call it C:\2009) to a new folder (C:\2010). Each workbook contains at least 1 worksheet for each month of the year so I need to delete all worksheets except the Dec 09 worksheet(s). (The worksheet names will not always be the same from workbook to workbook so I need to delete the sheets that do not contain "Dec" and "09".) Then I'll need to make a copy of the first sheet, rename it to 'Jan 10', save, close, and do the same thing for each workbook in the new folder.
I haven't been able to create a code that will execute everything I need to do.
Help please!!
Thanks!
I need to copy all workbooks in a folder (call it C:\2009) to a new folder (C:\2010). Each workbook contains at least 1 worksheet for each month of the year so I need to delete all worksheets except the Dec 09 worksheet(s). (The worksheet names will not always be the same from workbook to workbook so I need to delete the sheets that do not contain "Dec" and "09".) Then I'll need to make a copy of the first sheet, rename it to 'Jan 10', save, close, and do the same thing for each workbook in the new folder.
I haven't been able to create a code that will execute everything I need to do.