I have a workbook made in Excel 2003 and wrote VBA code to open a predefined directory containing approx. 20 woorkbooks, code then goes to a specific sheet in each workbook and copies a range of cells (range varies) to this new workbook. In this new workbook I then merge all those copied worksheets into a single worksheet. Code work great if all my files are Excel 2003 or earlier. We have been slowly migrating to Office 2007 and now Excel 2007 files will not open using this code. I have downloaded and installed the converter.exe file but I still can not open Excel 2007 using Excel 2003. I want to continue automating this task but it is getting frustrating having to open each 2007 spreadsheet and save as a 2003 file.