Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Versioning in Excel???
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Versioning in Excel???
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Versioning in Excel???
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Versioning in Excel???
Then you will have to maintain such a thing, as there is no built-in file
version. -- HTH RP (remove nothere from the email address if mailing direct) "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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Versioning in Excel???
Thanks much! All is well...
"Tom Ogilvy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creative Ways to use Versioning or Tracking in Excel | Excel Discussion (Misc queries) | |||
Versioning in Excel | Excel Discussion (Misc queries) | |||
Versioning Management | Excel Programming | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) | |||
Versioning/tracking changes | Excel Programming |