revision number of excel worksheet..

Is there any way I can get a cell to show the revision number of the
current document (ie how many times it has been saved)?

In Word, this is done by inserting the field {DOCPROPERTY "RevisionNumber"}

Is there any way (eg a function) which I can use to access this property?
Alternatively, is there any other way to do it, so that it has one added
every time the fil is saved?

--
Steve ("PhantomSteve")
__ _ __
o|\('')/|o |_)|_ _ __ _|_ _ __ _ _|_ _ _ o|\('')/|o
\_ _/ | | |(_|| | |_(_)|||_ |_(/_\_/(/_ \_ _/
/___/ (ASCII art design by Marion Koslowski) \___\

"On the outskirts of nowhere, On the ringroad to somewhere,
On the verge of indecision, I'll always take the roundabout way."

You are looking for "BuiltinDocumentProperties"

A function demonstrating it is in:
http://www.bygsoftware.com/udf_untra...n_excel_97.htm

If you have Excel 97 the rest of the workbook might also be interesting!
--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"


"PhantomSteve" wrote in message
...
Is there any way I can get a cell to show the revision number of the
current document (ie how many times it has been saved)?

In Word, this is done by inserting the field {DOCPROPERTY
"RevisionNumber"}

Is there any way (eg a function) which I can use to access this property?
Alternatively, is there any other way to do it, so that it has one added
every time the fil is saved?

--
Steve ("PhantomSteve")
__ _ __
o|\('')/|o |_)|_ _ __ _|_ _ __ _ _|_ _ _ o|\('')/|o
\_ _/ | | |(_|| | |_(_)|||_ |_(/_\_/(/_ \_ _/
/___/ (ASCII art design by Marion Koslowski) \___\

"On the outskirts of nowhere, On the ringroad to somewhere,
On the verge of indecision, I'll always take the roundabout way."