View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Saving values during installation of Add-In

Hi Red,

The ideal is for the value to be stored somehow within
the add-in. Possible?


I guess the simplest thing to do would be to write the info to a
worksheet in the addin and save the addin itself after a change of
settings. (That is, if you are not planning to have a single addin on a
central location)

An alternative might be to create an extra folder in the documents and
settings folder of the user. Chances are good that everyone has
read/write permissions to that location. Otherwise, also the My
Documents folder should be open to read/write access, so maybe adding a
folder there might help.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com