I have an Advanced Script I have created for some interaction with Excel. I am having trouble declaring variables of a type that exist in the Excel namespace. Sample code fragment follows:
' These define without any problem
Dim excelApp As Object
Dim FileSystemObj as Object
Dim convFilePath As String
Dim convFileName As String
'These get a compile error as the types are unknown
Dim paramExportFormat As XlFixedFormatType
Dim paramExportQuality As XlFixedFormatQuality
Dim wbData As Workbook
The types XlFixedFormatType, XlFixedFormatQuality and Workbook are not available.
In SolidWorks I can make these types available in the VBA Editor by adjusting the References.
How does one adjust the VBA References for ePDM Advanced Scripts?
Retrieving data ...