VBA Code Not Refreshing External Query Data in Excel 2010

Hi All

I have a small Excel file with VBA code. We use the task scheduler in Windows to open this small file which then runs a macro to open, refresh, and save various reports that we have automated. The file works fine in Windows 2000 and Excel 2003, but we are converting to Windows 7 and Excel 2010. The task scheduler opens the small file which then then opens the appropriate report. It looks like it refreshes, and then it deletes the prior report and saves the new report to a particular location. But when I open the saved report, the data from the external query has not changed. If I run the same report manually by opening up the report and hitting refresh all, the data does get updated. Also I do not encounter any errors in the VBA. Here is the code:

Please Login or Register  to view this content.

Is there something I need to change so that it will work in Excel 2010?