Hi,

I am using the COM API with Sage 50 US 2021.

Is there a way to interact with the report window after it is open? Specifically, I am wondering about setting options, choosing columns, and then saving to Excel.

I tried the following code, which opens the "Item List" report. But after that I can't figure if there is a way to interact with the report window.

_app.OpenReport(PeachReportObjects.proItemList);
_app.ExecuteCommand("Options"); // Doesn't do anything
_app.ExecuteCommand("File|Close"); // Doesn't do anything

Thank you,

Chris