How to call a IDEA macro from Excel VBA

5 posts / 0 new
Last post
Degrebe
Offline
Joined: 03/11/2022 - 08:41
How to call a IDEA macro from Excel VBA

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 

Degrebe
Offline
Joined: 03/11/2022 - 08:41

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
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Debrebe,

Are you just trying to run the script or do you expect to get information back from the script to your macro?

Degrebe
Offline
Joined: 03/11/2022 - 08:41

Hi Brian,
I was just looking for a way to run the script, nothing else. It is easier for my collegues to push a button in an excel file than fire up IDEA go into the scripting engine and run the script :D 
Kind regards and have a great weekend
Dennis 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Thanks for letting me know you figured it out.  Yes, you need to get the proper libraries.