Comprehensive Guide to SaveToDB VBA Options

The IAddInOptions interface defines the options for the SaveToDB add-in.

You can use these properties in your VBA macros and VSTO add-ins.

<ComVisible(True), Guid("CF0170F1-310E-421F-87DF-C177753EEDD9")>
Public Interface IAddInOptions

    ' Common Options
    Property DisplayLanguage As String
    Property DefaultDataLanguage As String
    Property WorkbookDataLanguage(Optional Workbook As Workbook = Nothing) As String
    Property EncryptPasswordsByDefault As Boolean
    Property EncryptWorkbookPasswords(Optional Workbook As Workbook = Nothing) As Boolean?
    Property ConnectionTimeout As Int32
    Property CommandTimeout As Int32
    Property MaxMemoryLines As Int32
    Property MaxLoadedRows As Int32
    Property UpdateChangedCellsOnly As Boolean

    ' Excel Options
    Property ShowUrlMenu As Boolean
    Property ShowContextMenu As Boolean
    Property ShowDoubleClickCalendar As Boolean
    Property ShowDoubleClickPivot As Boolean
    Property AutoFilterRow As Boolean
    Property AutoOpenLastFile As Boolean
    Property KeepFormulas As Boolean
    Property AutoFormatNotNullColumns As Boolean

    ' Excel Options Removed in SaveToDB 9
    Property AutoActivateTableRelatedWindows As Boolean
    Property AutoArrangeWindows As Boolean
    Property AutoHideTaskbarMdiWindows As Boolean
    Property AutoCleanBadNamedCells As Boolean

    ' Ribbon Options
    Property HideAdvancedMenuItems As Boolean
    Property ParameterHistoryLimit As Int32

    ' Options Menu
    Property ShowRowEditor As Boolean
    Property ShowCellEditor As Boolean
    Property ShowListEditor As Boolean

    ' Special Options
    Property TemplatePath As String
    Property FrameworkPath As String
    Property ApplicationPath As String
    Property ShowToolsMenu As Boolean?

    ' TaskPanes
    Property TaskPaneDockPosition As Int32

    ' Row Editor
    Property RowEditorDockPosition As Int32
    Property RowEditorTop As Int32
    Property RowEditorLeft As Int32
    Property RowEditorHeight As Int32
    Property RowEditorWidth As Int32
    Property RowEditorDockHeight As Int32
    Property RowEditorDockWidth As Int32
    Property RowEditorFontSize As Single
    Property RowEditorFontName As String

    ' Cell Editor
    Property CellEditorDockPosition As Int32
    Property CellEditorTop As Int32
    Property CellEditorLeft As Int32
    Property CellEditorHeight As Int32
    Property CellEditorWidth As Int32
    Property CellEditorDockHeight As Int32
    Property CellEditorDockWidth As Int32
    Property CellEditorFontSize As Single
    Property CellEditorFontName As String

    ' List Editor
    Property ListEditorDockPosition As Int32
    Property ListEditorTop As Int32
    Property ListEditorLeft As Int32
    Property ListEditorHeight As Int32
    Property ListEditorWidth As Int32
    Property ListEditorDockHeight As Int32
    Property ListEditorDockWidth As Int32
    Property ListEditorFontSize As Single
    Property ListEditorFontName As String

    ' Logs
    Property LogPath As String
    Property TraceSQL As Boolean
    Property TraceLoader As Boolean

End Interface