AnsweredAssumed Answered

Can Excel and Solidworks communicate by calling in each others Macros?

Question asked by Kyle Thomson on Jul 13, 2020
Latest reply on Jul 13, 2020 by Peter Kennedy

If I call in an Excel workbook into my Solidworks API and that workbook has an Excel Macro attached to it. Can I run the Excel Macro through using Solidworks VBA API?


To be more specific, I currently have a loop that exports values to excel for 8,700 iterations from a solidworks simulation that I am running through VBA. In order to go from iteration 1 to iteration 2, the data from i1 is exported to excel cells that are run through a formula. The output of that formula is then loaded in to i2 as data. The macro I have in Excel is reading the exported values from my VBA model's generated text file after each i and then entering them into the deemed cells in Excel.