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


use the comments field as this will show up at the bottom
in the addin dialog.

can be edited when isaddin=false via file properties dialog
or in code via workbook.comments

(it can ALSO be set via explorer/ file properties)

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


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