ILLExport

Data #

Datasheet abstraction of the export table.

Signature:

Public Property Get Data() As IDataSheet

---

Worksheet #

Worksheet hosting the export table.

Signature:

Public Property Get Worksheet() As Worksheet

---

NumberOfExports #

Count of configured export rows.

Signature:

Public Property Get NumberOfExports() As Long

---

HasCheckings #

Whether informational checkings are available.

Signature:

Public Property Get HasCheckings() As Boolean

---

CheckingValues #

Collected informational diagnostics about export generation.

Signature:

Public Property Get CheckingValues() As IChecking

---

AddRows #

Append export definition rows.

Signature:

Public Sub AddRows(Optional ByVal dict As ILLdictionary)

Parameters:

• dict: Optional dictionary to keep export columns aligned.

---

InsertRows #

Insert export rows based on a target selection.

Signature:

Public Sub InsertRows(ByVal targetCell As Range, _
                      Optional ByVal dict As ILLdictionary, _
                      Optional ByVal insertShift As Boolean = False)

Parameters:

• targetCell: Range representing the rows to mirror.
• dict: Optional dictionary to keep export columns aligned.
• insertShift: Optional Boolean to insert worksheet rows when needed.

---

RemoveRows #

Remove trailing export rows.

Signature:

Public Sub RemoveRows(Optional ByVal dict As ILLdictionary, Optional ByVal rowCount As Long = 2)

Parameters:

• rowCount: Optional Long. Rows with non-empty cell counts at or below this value are removed.

---

SyncDictionaryExports #

Synchronise dictionary export columns with current export definitions.

Signature:

Public Sub SyncDictionaryExports(Optional ByVal dict As ILLdictionary)

Parameters:

• dict: Optional dictionary reference to align. When omitted, the last cached dictionary is reused.

---

ImportSpecs #

Import export specifications from another worksheet.

Signature:

Public Sub ImportSpecs(ByVal fromWksh As Worksheet, _
                       ByVal fromStartRow As Long, _
                       ByVal fromStartColumn As Long)

---

ExportSpecs #

Export specifications into another workbook.

Signature:

Public Sub ExportSpecs(ByVal toWkb As Workbook, _
                       Optional ByVal Hide As Long = xlSheetHidden)

---

InvalidateCaches #

Reset cached column lookups and diagnostics.

Signature:

Public Sub InvalidateCaches()

---

ExportFileName #

Build a filename for one export definition.

Signature:

Public Function ExportFileName(ByVal exportNumber As Long, _
                               ByVal dict As ILLdictionary, _
                               ByVal pass As IPasswords, _
                               Optional ByVal exportAll As Boolean = False) As String

Parameters:

• exportNumber: Export definition identifier.
• dict: Dictionary supplying metadata for chunk substitution.
• pass: Password provider for version metadata.
• exportAll: Optional flag to force the export-all naming scheme.

---

IsActive #

Determine if an export definition is marked active.

Signature:

Public Function IsActive(ByVal exportNumber As Long) As Boolean

---

ColumnValue #

Retrieve a column value for a given export row.

Signature:

Public Function ColumnValue(ByVal exportNumber As Long, ByVal columnName As String) As String

---

ActiveExportNumbers #

Enumerate export numbers that are currently active.

Signature:

Public Function ActiveExportNumbers() As BetterArray

---