for Excel document, I want to know how many times the document gotopened. My thought is: in one cell, I type 1 into it, next time whensomebody opened this document, it will automatically changed into 2,etc.
Have a look at the OnOpen event. You can add one to a cell when theworkbook is opened by grabbing that event.That won't actually count the number of times it's been opened, of course.But it'll count the number of times it's been opened and saved.
If you wanted to you could add a save to the OnOpen event macro Dave Ssuggests.