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