+ Reply to Thread
Results 1 to 8 of 8

Save() fails on some 2003 excel files.

  1. #1
    Registered User
    Join Date
    07-15-2010
    Location
    Riga,Latvia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Save() fails on some 2003 excel files.

    Hi

    Im trying to apdopt a software that was initially designed for Office 2003 to work with Office 2007. And Im having trouble with save() method of Workbook class. When I use Excel 2003 it works just fine though. I thought that this is happening because i work with excel 2003 files but actually error happens only on excel files that were created like 2 years ago. If i create a excel 2003 file now everything works.

    Any ideas why this is happening?

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Save() fails on some 2003 excel files.

    What version of Excel were the old files created in and do you have Office 2003 Service Pack 3 installed?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    07-15-2010
    Location
    Riga,Latvia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Save() fails on some 2003 excel files.

    Quote Originally Posted by romperstomper View Post
    What version of Excel were the old files created in and do you have Office 2003 Service Pack 3 installed?
    On Office 2003 that creates the files that work with 2007 only Service Pack 1 is installed. Unfortunately I have no way of knowing what service packs were installed on the computer that created files that doesnt work in 2007.
    Last edited by naurispunk; 07-15-2010 at 05:15 AM.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Save() fails on some 2003 excel files.

    What actual error are you getting?

  5. #5
    Registered User
    Join Date
    07-15-2010
    Location
    Riga,Latvia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Save() fails on some 2003 excel files.

    Quote Originally Posted by romperstomper View Post
    What actual error are you getting?
    Save method of Workbook class failed

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Save() fails on some 2003 excel files.

    What happens if you manually open the files in 2007 and save?

  7. #7
    Registered User
    Join Date
    07-15-2010
    Location
    Riga,Latvia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Save() fails on some 2003 excel files.

    Quote Originally Posted by romperstomper View Post
    What happens if you manually open the files in 2007 and save?
    'file.xls' cannot be saved in the current format. To save your changes, click OK, then save it as the latest format.

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Save() fails on some 2003 excel files.

    At a guess I would say they have been saved in Excel5/95 compatible format. You will have to save them as 97-2003 format or later.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1