Hi, all. I just got upgraded to MSOffice 2007 and mostly it's fine, with the usual bugs that come with such moves. However, one of my duties is to upload an .xls file to a website for display. The last time I did this with 2003 it worked just fine, but the first time I did it w/ 2007 it did not. I manually re-saved the file as an Excel 97-2003 workbook and then it did upload OK. He's a slice: Sheets("MySheet").Select Set WebsiteUpdate = ActiveWorkbook ActiveSheet.Copy Set MyBook = ActiveWorkbook With MyBook .SaveAs ("G:\Huge\Large\Medium\Particular\MYFILE.xls") End With Is the ".xls" sufficient to ensure a 97-2003 format save? It appears not, so I'm wondering what would be the trick to ensure it still saves as the old file until the webmasters can upgrade their portals? Thanks.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Is .xls sufficient for old format saves?

Thread starter corquando
Start date Jan 28, 2010
Tags

.xls 2003 2007 format save

corquando

Board Regular

Jan 28, 2010

Hi, all.

I just got upgraded to MSOffice 2007 and mostly it's fine, with the usual bugs that come with such moves.

However, one of my duties is to upload an .xls file to a website for display. The last time I did this with 2003 it worked just fine, but the first time I did it w/ 2007 it did not. I manually re-saved the file as an Excel 97-2003 workbook and then it did upload OK.

He's a slice:

Code:

        Sheets("MySheet").Select
        Set WebsiteUpdate = ActiveWorkbook
        ActiveSheet.Copy
        Set MyBook = ActiveWorkbook
        With MyBook
            .SaveAs ("G:\Huge\Large\Medium\Particular\MYFILE.xls")
        End With

Is the ".xls" sufficient to ensure a 97-2003 format save? It appears not, so I'm wondering what would be the trick to ensure it still saves as the old file until the webmasters can upgrade their portals?

Thanks.