AnsweredAssumed Answered

unable to use Excel resources from Tasks->Advanced Script

Question asked by R. Seegmiller on Jun 25, 2013

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?

 

Thanks

Outcomes