it's hard to comment on your question without a sample, but I suggest making sure the handle to the object your trying to change (worksheet?) is grabbed fresh after the refresh, and would break up any compound lines to a multi-line equivalent (would be sure to hold intermediate objects in variable references).
------------------------------
Ted Phillips
IBM
------------------------------
Original Message:
Sent: Tue September 27, 2022 12:40 AM
From: Yukiya Ishimaru
Subject: VBA error
Hi,
I developed one uploading tool using Excel (Excel 365), PAfE (2.0.80) and VBA, and I get VBA error ("Run-time Error -2147319767 (80028029)") at next step (changing sheet) after executing "Application.COMAddIns("CognosOffice12.Connect").Object.AutomationServer.Application("COR", "1.1").RefreshSheet".
If someone could advise to me how fix this error, I would appreciate.
Regards,
Yukiya Ishimaru
------------------------------
Yukiya Ishimaru
------------------------------
#PlanningAnalyticswithWatson