Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
phil in evansville indiana
 
Posts: n/a
Default version numbers on spreadsheets

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?
  #2   Report Post  
Andy Wiggins
 
Posts: n/a
Default

This file might be a help:
http://www.bygsoftware.com/examples/...Properties.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"
wrote in message
...
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insertion of *Objects* Into Spreadsheets (Version Differences) Rif Excel Discussion (Misc queries) 1 April 13th 05 05:27 AM
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Converting Numbers to Text properly Shirley Munro Excel Discussion (Misc queries) 1 February 16th 05 03:01 PM
How can I copy column sums to another spreadsheets as numbers auntpat Excel Worksheet Functions 3 January 3rd 05 06:49 PM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"