I would like to find out if there is any way to run macro from Excel. I want to open excel run selected module from excel macro once this is done take data from standard excel sheet into Revit and then close excel. I have connected so calcs to external software and I can run it from VBA Macro in excel.
Yes, you can run Excel VBA Macros using the COM Interop so effectively you could do that from Dynamo or any other software (Grasshopper). As a matter of fact, If I am not mistaken a Bumblebee plug-in for Grasshopper allows you to do just that already, although I am not 100% sure that functionality still works because it has been a while since I have used it. Point is that it’s possible. Look into Excel COM Interoperability. You can take clues on how to set up your Excel connection from Dynamo by peeking under the hood of Bumblebee for Dynamo plug-in that i have written.
I would like to run an Excel macro from Dynamo, which operates in my Excel file. I wasn’t able to do that so I wonder if you’ve found any solution to make that link between Dynamo and Excel macros, did you?