add in persistent properties
Thanks Keith!
I will try using custom document properties for my solution.
Regards,
faffo1980
"ker_01" wrote:
Are you interested in adding your properties to the add-in, or the actual
user workbooks? If it is the latter, consider using custom document
properties- in VBA they are easy to use (I don't have VSTO2008, but I assume
it is easy there too). These are generally not noticable to most users, they
will be workbook-specific (meaning the user can have two different workbooks
and have different settings on each), and your settings will travel with the
workbook even if opened on different PCs. If you need to have one set of
settings that affect every workbook for the same user, then you need to store
your values in your add-in or the registry.
HTH,
Keith
"faffo1980" wrote:
Hi,
I'm developing an Excel AddIn with VSTO 2008.
I would like to add to the workbook some addin specific properties and make
them persistent.
Which is the best way in your opinion?
The simplest solution is to make a hidden worksheet containg these
properties but I don't like it very much.
Is there another way?
Thanks for your help,
faffo1980
|