Reply to thread

Message: [QUOTE="Milothicus, post: 6020318"] well, the macro is initiated in Solidworks, and it's all written in VBA. I do some work in Solidworks, save info to an array, and then use excel's API to open a spreadsheet and place the info into excel. I'm not a complete newbie, but i'm not sure what COM/OLE automation is. I'm just using VBA to move between the two of them. maybe that's what i need, but i can't make sense of what you've suggested... i don't know which section of my code would replace 'Call the COM server here...' The code for the macro is in an .swp file (solidworks program), and the event i mentioned above is attached to the workbook. there must be a way to use the event in the workbook code to set a variable to 'true' in the solidworks code. could i send keystrokes with one to be received by the other? [/QUOTE]