version numbers on spreadsheets

[phil in evansville indiana]

can i have version numbers on a spreadsheet. when i close the sheet, can
excel append a new version number so i can keep old copies?

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/CustomDocumentProperties.zip

The workbook has a family of VBA routines to help you create, amend, and
delete Custom Document Properties

It's in the "Administration Utilities" section on page:
http://www.bygsoftware.com/examples/examples.htm

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"phil in evansville indiana"