File Versioning in Excel???

Aimster · 10-25-2005, 12:05 PM

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.

Bob Phillips · 10-25-2005, 01:05 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

Aimster · 10-25-2005, 02:05 PM

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

Bob Phillips · 10-25-2005, 04:05 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >

Tom Ogilvy · 10-25-2005, 05:05 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >

Aimster · 10-25-2005, 06:05 PM

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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.
> > >
> > >
> > >
>
>
>