VBA Options

VBA Options

The IAddInOptions interface defines SaveToDB add-in options.

You can use these properties with 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