LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default File Versioning in Excel???

close the file. Right click on it in Windows Explorer and select properties.
Go to the Custom tab. Type in the word Version, then leave the next box as
text and go to the value box and type in 1.1.1.1 or some such. Then click
Add and down at the bottom Apply.

You can also edit this in File=Properties in Excel.

If you make the document read only, it can't be changed (although the user
can just uncheck readonly and make the changes).

--
Regards,
Tom Ogilvy

"Aimster" wrote in message
...
I was thinking more in lines of the file version, not the application

version.

"Bob Phillips" wrote:

With VBA

Function ExcelVersion()
ExcelVersion = Application.Version
End Function

And use with =ExcelVersion() in some worksheet cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Aimster" wrote in message
...
Is there a way to include a version number in an Excel file? I have a
template that I update as needed, and need to ensure that users are

using
the
correct version. I would like to include a version number for the

template
that they can check before using.








 
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
Creative Ways to use Versioning or Tracking in Excel atlcharm Excel Discussion (Misc queries) 0 March 3rd 08 06:17 AM
Versioning in Excel Dave M Excel Discussion (Misc queries) 0 January 17th 06 04:31 PM
Versioning Management Arturo Excel Programming 3 February 26th 05 03:37 PM
How do I avoid saving multiple Excel/Wordfiles for versioning purp Neil Excel Discussion (Misc queries) 1 December 13th 04 12:57 PM
Versioning/tracking changes Poseur Excel Programming 3 August 10th 04 11:18 AM


All times are GMT +1. The time now is 12:38 PM.

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

About Us

"It's about Microsoft Excel"