View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Best way to identify the "version" of your Add-in code?

A lot of people use a "Help|about" button/menuitem for that kind of thing. It
makes it easy to ask the remote user to click on it and read the results.



pmax wrote:

I have an Excel Add-in that has been around since Office 97. We have
recently made a lot of changes and we want to easily identify the
"version" of the add-in that the customer is using. The only way I know
to do this is to maintain it manually in the code by creating a
constant and updating the value each time we update the add-in. In
addtion to this I add a custom property to each sheet identifying the
version the spreadsheet was created with. We then could add a way for
the customer to identify the version they are running when they contact
us for support.

I am wondering if there is a better way to do this? Is there a way you
can version an .xla file?

Thanks for any input...pmax


--

Dave Peterson