Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Thanked 0 Times in 0 Posts

    Workbook.Saved=Ture not setting (Excel 2000/SR1 Sp3)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    We develop a lot of enhance Excel and Word templates using VBA and COM addins and have run into a strange problem with Excel 2000 with the latest service packs, etc. We are not abl to set the "saved" state of the workbook object to True. We are using ThisWorkbook.Saved = True but it remains False and sure enough we get the prompt asking do we want to save the workbook. Even if we try to set the saved state usign the immediate window it still remains set to false. In additon no error is generated which would help us figure out the problem. We do not expereince this problem when using Office XP or Office 2003, only Office 2000 and we have the latest SPs. Also we have looked at knowledge base article located at


  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Salt Lake City, Utah, USA
    Thanked 5 Times in 5 Posts

    Re: Workbook.Saved=Ture not setting (Excel 2000/SR1 Sp3)

    Did you check out <!post=this thread,392552>this thread<!/post>?
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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