Hi,
I would really appreciate if anyone coul help me.
I am trying automate a process using MS Office 2007 macros. The process involves opening a *.tnd file which automatically opens in an engineering software called TRANED and then running the analysis.
There are no hot keys to run the software. usually running it involves clicking the "Run TRANSYT" button when the file opens, which completes the run and then "produce report" button to create the report.

How can i automate this process using excel? I have managed to open the file using Shellexecute, but it just opens the file. how can i run it and produce report automatically? is it possible to get macros to somehow press these buttons to run the program and save the report. I am really desperate. I need to finish this work asap. Please help!!!

Edit by admin: no contact info permitted on the forum, thank you