68678

VSTO - Best place to store Excel workbook settings

I have a legacy Excel AddIn implemented in VBA which I am slowly porting to .net using VSTO. Using this AddIn I am storing settings per workbook within a hidden sheet. I was wondering if there is a better approach to do this using VSTO.

Answer1:

You can use Custom Document Properties to store the settings.

Recommend

  • How to get the document-level templates into Visual Studio Tools for Office (VSTO)
  • Solve the error installation package is not supported by this processor type
  • Why glBufferSubData need to wait until the VBO is not used by glDrawElements?
  • how to know which word version is installed from my add-in (Ribbon)? with c#
  • Get Office Addin Publish Version
  • Renderscript usage
  • Implementing Porter-Duff Rules in Direct3D
  • Can't find link in Excel Workbook
  • Excel AddIn in Excel 2011 for MAC
  • Tab through XML documentation fields
  • Improving JQGrid Tree Grid performance
  • Calling ssh with system in R shell eats subsequent commands
  • Very Basic JS Coding, and SoundManager2 or not?
  • SQL Server : slow query with 3 “OR” condition and order by Id
  • Excel - How to create button upon Workbook_Open event
  • VB Brackets in Enum?
  • Formula to remove entire words that start with certain characters
  • Java compiler under Eclipse/Ant defaults to %JAVA_HOME%?
  • Importing a module into access programmatically from a *.cls or similar file
  • GCC error: Cannot apply offsetof to member function MyClass::MyFunction
  • Access 2007 forms with parameterized RecordSource
  • Excel VBA : How to copy href from HTML by referencing the class name
  • Is there a way to use Firebase Legacy console from new account
  • Excel not inserting leading zero
  • Install 3rd Party Libraries with Transitive Dependencies / Dependency Tree?
  • Creating UDF with VSTO in Excel
  • VBA Dir function not working on Excel 2010
  • MVC - @Html.CheckBoxFor
  • Outlook to Excel hyperlink issue
  • C# Excel interop - how to test if interop object is still working and performing a task?
  • C++ pointer value changes with static_cast
  • Marklogic : Query response time is very high
  • Ionic 2 storage is not cleaning up on uninstall - Only for signed APK
  • Is there any way to access browser form field suggestions from JavaScript?
  • Get object from AWS S3 as a stream
  • Cross-Platform Protobuf Serialization
  • Validaiting emails with Net.Mail MailAddress
  • Do I've to free mysql result after storing it?
  • python regex in pyparsing
  • Suggestions to manage Login/Logout transitions