Planning Analytics

 View Only

  • 1.  VBA error

    Posted Tue September 27, 2022 10:13 AM
    Reply
    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


  • 2.  RE: VBA error

    Posted Wed September 28, 2022 11:27 AM
    Reply

    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


Related Content