Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2008
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Dirty Flag (O2000SR1)

    You answered an earlier post in part by suggesting that I check the "file dirty flag" to see if a workbook had been updated. I'm afraid I am too stupid to figure out which property this is and how to find it. ??

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Dirty Flag (O2000SR1)

    I believe that what Legare was referring to was creating your own "dirty flag" i.e. setting a boolean to true or false as the result of user input and then taking the proper action depending upon the value of that variable. As far as I know, there is not a dirty flag property.

    Thanks,

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

    Re: File Dirty Flag (O2000SR1)

    Check the Saved property of the Workbook object. If that property is True, then no changes have been made since the workbook was last saved.
    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
  •