How to call a Excel form to inventor.

[jeeva.scientist]

Hello everyone,

1. I have a part model.
2. Dimensions in the part model are driven my excel link.
3. I have a form in excel, to change the values.
4. I also have a form in the Part model.
5. The excel file is located in the same folder as the part model.

Question:

1. Is it possible to call the excel form from the part model form?

[bradeneuropeArthur]

With VBA;Vb.net; Ilogic or by referencing the table in the part directly?

[HideoYamada · Accepted solution]

Hello,

You can call excel VBA macro from Inventor VBA macro.

Inventor VBA Code :

Sub test()
    Dim xlApp As Excel.Application
    
    Set xlApp = GetObject(, "Excel.Application")

    ' Here "ExcelSub" is the name of the Macro.
    xlApp.Run "ExcelSub"
End Sub

You must add Reference to Excel Object Library in Inventor before use this code.

Excel VBA Code :

Public Sub ExcelSub()
    ' Get application focus
    AppActivate Application.Caption
    ' Show dialog
    UserForm1.Show
End Sub

The workbook must have been opened.

Let's try !!

=====

Freeradical

 Hideo Yamada

[jeeva.scientist]

Thanks for your Support 👍 

Working Proof 👇