Im Zusammenspiel mit einem PDM-System kann es hilfreich sein, das der Export z.B. bei Freigabe eines Dokumentes automatisch durchgeführt wird.

Dazu stellt das Reitec.Testplan für Inventor AddIn eine einfach Schnittstelle zur Verfügung.

AddIn Guid = „92C66D5F-1731-4B47-8FAA-A651DF4498CD“

Function Export(FileName As String, TestplanTypeName As String, CreatePDFOutput As Boolean, CreatePDFSource As Boolean, ExportAuthorData As Boolean, CalculateCommonTolerances As Boolean, CommonToleranceClass As String, ByRef HasBubbles As Boolean)

Funktionsparameter:

Function ExportExcel(FileName As String, TestplanTypeName As String, CreatePDFOutput As Boolean, CreatePDFSource As Boolean, ExportAuthorData As Boolean, CalculateCommonTolerances As Boolean, CommonToleranceClass As String, ExcelTemplateFileName As String, HideWorksheet As Boolean, ByRef HasBubbles As Boolean)

Funktionsparameter:

Aktualisiert die Merkmalsdaten eines Prüfplans.

 Public Function RefreshData(TestplanTypeName As String) As Boolean

Funktionsparameter:

Sub TestplanExportTest()
    Dim xlsxOutputFile As String
    Dim dfdOutputFile As String
    Dim hasBubbles As Boolean
    Dim testplanType As String
    Dim createPDF As Boolean
    Dim exportAuthorData As Boolean
    Dim calculateCommonTolerances As Boolean
    Dim commonToleranceClass As String
    Dim hideExcelWorksheet As Boolean
    Dim excelTemplateFilename As String
 
 
    'adjust file paths accordingly
    xlsxOutputFile = "C:\temp\Test.xlsx"
    dfdOutputFile = "C:\temp\Test.dfd"
    testplanType = "Full-Dimension_1"
    createPDF = False
    exportAuthorData = False
    calculateCommonTolerances = True
    commonToleranceClass = "ISO 2768f"
    hideExcelWorksheet = True
    excelTemplateFilename = "C:\temp\Testplan_Template.xlsx"
 
    'get AddIn
    Dim addins As Object
    Dim addin As Object
    Dim addinObject As Object
    Dim result As String
 
    Set addins = ThisApplication.ApplicationAddIns
    Set addin = addins.ItemById("{92C66D5F-1731-4B47-8FAA-A651DF4498CD}")
 
    Set addinObject = addin.Automation
    'XLSX export
    result = addinObject.ExportExcel(xlsxOutputFile, testplanType, createPDF, createPDF, exportAuthorData, calculateCommonTolerances, commonToleranceClass, excelTemplateFilename, hideExcelWorksheet, hasBubbles)
 
    If result = True And hasBubbles = True Then
        'DFD export
        result = addinObject.Export(dfdOutputFile, testplanType, createPDF, createPDF, exportAuthorData, calculateCommonTolerances, commonToleranceClass, hasBubbles)
    End If
End Sub