Endless Googling has lead no where, and if somebody in this fantastic community can shed some light or point in the correct direction where I can learn how to do this.
Even if the addin is an Excel addin with VBA, it's probably protected so you can't open it to see what the procedure name is (although maybe you can break open the ribbon xml and see what the On Action is set to).
If you can't get over those hurdles, you're probably stuck with Send Keys.
There are a number of hurdles you will find trying to use this.
I don't know if it works on COM addins and QB probably is one.
export date in CSV format, which is readable by Excel…
More » When you need to import that information into Quick Books, you can do so using two main options.
(If you don’t know the path and name of the workbook, click the Browse button and then use the dialog box that Quick Books displays to locate the workbook file.) If you want to copy the report to an existing Excel spreadsheet, …
Quick Books and Microsoft Excel work together to provide multiple ways to access and …
Exporting Quick Books report to Excel makes it easier to manipulate the information.