I have a folder of Excel files. They were created in an earlier version of Excel (2007). Without getting into all of the details, they need to be recreated in a newer version of Excel (2010). For everything that is going to need to be done, it is going to be a big, multi-step process that I'll have to do in stages. However, as a start, what I need is the following:
1. There are approximately 50 Excel files in MyFolder on my Desktop. They were all created in Excel 2007 and obviously all have different names. They are macro-enabled.
2. Using an existing blank Excel file that was created in Excel 2010, I need to make 50 copies of that Excel 2010 file and rename (or name) and save each one into another folder using the same exact names as the 2007 versions.
So, all I'm trying to do is make copies of the Excel 2007 versions in Excel 2010. I could obviously just do it one by one but I have multiple folders with multiple files that have this issue, so it would take a very long time. I'm hoping someone could show me a routine to accomplish this. Thank you.