IDesignerImportService
Defines the public contract for the DesignerImportService class, exposing methods to import setup components (dictionary, choices, analysis, exports, formatter, translations) from a setup workbook into the designer, and to export components (dictionary, choices, analysis, exports, geo, passwords) to a linelist workbook. After export, the service provides accessor properties for new domain manager instances targeting the exported workbook.
Lifecycle
Configure #
Bind the service to a designer workbook
Signature:
Public Sub Configure(ByVal hostBook As Workbook)
Sets the internal host workbook reference. Must be called before any other operation. Raises an error when the workbook is Nothing.
Parameters:
hostBook: Workbook. The designer workbook.
Core Operations
ImportFromSetup #
Import setup components into the host workbook
Signature:
Public Sub ImportFromSetup(ByVal setupPath As String)
Opens the setup workbook at the supplied path, then imports dictionary, choices, exports, analysis, and formatter worksheets by exporting from setup domain managers into the host workbook. Translations are imported via LLTranslation.ImportDictionary using the setup Translations ListObject. The setup workbook is closed after import completes (or on error).
Parameters:
setupPath: String. Full path to the setup workbook (.xlsb or .xlsx).
ExportToLinelist #
Export designer components to a linelist workbook
Signature:
Public Sub ExportToLinelist(ByVal targetBook As Workbook)
Exports dictionary, choices, analysis, exports, geo, and passwords worksheets from the host workbook into the provided target workbook. The target workbook is NOT closed after export. New domain manager instances targeting the exported workbook are stored and accessible via the Exported* properties.
Parameters:
targetBook: Workbook. The linelist workbook to receive exported data.
Exported Instances
ExportedDictionary #
Dictionary manager targeting the exported workbook
Signature:
Public Property Get ExportedDictionary() As ILLdictionary
Returns an ILLdictionary instance bound to the Dictionary sheet in the target workbook after ExportToLinelist completes. Returns Nothing before export or when the sheet was not exported.
Returns: ILLdictionary. The exported dictionary manager, or Nothing.
ExportedChoices #
Choices manager targeting the exported workbook
Signature:
Public Property Get ExportedChoices() As ILLChoices
Returns: ILLChoices. The exported choices manager, or Nothing.
ExportedAnalysis #
Analysis manager targeting the exported workbook
Signature:
Public Property Get ExportedAnalysis() As IAnalysis
Returns: IAnalysis. The exported analysis manager, or Nothing.
ExportedExport #
Export manager targeting the exported workbook
Signature:
Public Property Get ExportedExport() As ILLExport
Returns: ILLExport. The exported export manager, or Nothing.
ExportedGeo #
Geo manager targeting the exported workbook
Signature:
Public Property Get ExportedGeo() As ILLGeo
Returns: ILLGeo. The exported geo manager, or Nothing.
ExportedPasswords #
Passwords manager targeting the exported workbook
Signature:
Public Property Get ExportedPasswords() As IPasswords
Returns: IPasswords. The exported passwords manager, or Nothing.
ExportedTranslations #
Translations manager targeting the exported workbook
Signature:
Public Property Get ExportedTranslations() As ILLTranslation
Returns: ILLTranslation. The exported translations manager, or Nothing.
State
HostWorkbook #
The configured host workbook
Signature:
Public Property Get HostWorkbook() As Workbook
Returns: Workbook. The host workbook.