How to call a IDEA macro from Excel VBA
Degrebe
Forums
Hi Brian, hi guys,
I am using this website since 2017 and it helped me a lot. Thanks a million! Since I have not found an answer yet I would like to post my question here. I am struggeling calling an IDEA macro from a VBA macro in Excel. I am pretty sure it is not that complicated and I will slap myselfe for not coming up with the solution . Can someone give me the correpsonding code snippet as example?
Many thanks in advance and happy friday everyone!
Dennis
Hi Brain, hi guys,
Hi Brain, hi guys,
got it:
********************************************
Sub Test()
Dim IdeaClient As Object
Dim oIDEA As Idea.IdeaClient
Set oIDEA = New Idea.IdeaClient
oIDEA.RunIDEAScript "Path and name of the script.iss"
End Sub
********************************************
Needed libraries should be activated. ^^
Kind regards
Dennis