Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Save warning message in Excel 97 (97 and 2002)

    I'm developing an application in Excel 2002, but want it to be able to run independently in 97 as well.

    Whenever 97 saves the workbookit displays a mindless warning about potential loss of features (because the creator was a more recent version of Excel). Even if I do a saveas in 97, the NEW file when reopened will still create the warning.

    I coded a BeforeSave event routine but find the warning is coming up BEFORE the routine executes. I thought of saying a naughty word, but it didn't help.

    Anyone have any clues? Am I doomed to having to copy all the content sheet by sheet into a 97 created workbook - even then, will 2002 just 'improve' it again later?

    Andrew

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save warning message in Excel 97 (97 and 2002)

    I don't have XL97 or 2002, so I have no way of testing. However, if the message is displayed before the Before Save event routine, then I don't think that there is going to be any way around it. The best solution I can offer is to create the workbook in XL97 and send that version to 2002.
    Legare Coleman

Posting Permissions

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