iLogic run macro in excel

[Anonymous]

Hello friends,

Is there a command within iLogic to run an excel macro?

I have an embedded excel workbook which gets passed parameter values via an iLogic rule. I'd like it to then run a macro and read the value of a few cells after the macro has finished.

See below my rule and the point at which I'd like the macro to run.

GoExcel.CellValue("3rd Party:Embedding 1", "Data Input", "B2") = param1
GoExcel.CellValue("B3") = param2
GoExcel.CellValue("B4") = param3

'''''***** RUN MACRO called Front *****'''''

posA = GoExcel.CellValue("B20")
posB = GoExcel.CellValue("B21")
posC = GoExcel.CellValue("B22")

[frederic.vandenplas]

This code executes the vba code in excel (under module1, create a sub called "Test")

Sub XLTest()

     Dim XL As Object
     Set XL = GetObject(, "Excel.Application")
     XL.Run "Module1.Test"

End Sub

[Anonymous]

@frederic.vandenplas

I get the following error with your code:

Cannot create ActiveX component.

Using Inv Pro 2015

[Anonymous]

sorry wrong account