Right now i've got a C++ DLL i've written to do various functions in another piece of software I'm using (Tradestation). Ideally, i'd like to be able to add a function call to the DLL that will open Excel -> open a work book in a fixed location -> (and preferably) automatically run a macro.
I know it's easy enough to order it to start Excel and open the workbook, but is it possible somehow to also get my DLL to order Excel to automatically run a macro?