GetSheetObject Gives Object Required Error in Excel Macro

oZZee2021 — Sat, 16 Nov 2024 17:18:56 GMT

Hello,

First of all I am very new to qlikview so my question might be very wrong but I will try to explain as much as I can. In my company we are getting some reports via qlikview app which is shared via accesspoint with us. I realized that I can't write script directly inside this app as it is protected. (It took me a week to figure out why I can't .. )

Now I found out I can control and this qlikview app via VBA macro which I am writing in excel. Everything goes fine until I am trying to copy one simple chart and all over the internet below code is suggested;

ActiveDocument.GetSheetObject("id").CopyValuesToClipboard True

one I run this code I am having object required error like this object doesnt exist but as you can see below screenshot it is in my doucment (newly created by me). Can anyone think of a reason why it happens?

Note that I tried id with both as CH714 and CH714-158

ActiveDocument.GetSheetObject("CH714").CopyValuesToClipboard True

Thank you very much in advance.

Re: GetSheetObject Gives Object Required Error in Excel Macro

oZZee2021 — Tue, 06 Apr 2021 10:33:26 GMT

Hi All again,

I tried to printout all the object ids and it turned out that they have Server\ at the beginning of each id that is why it was not finding.

topic Re: GetSheetObject Gives Object Required Error in Excel Macro in Integration, Extension & APIs

GetSheetObject Gives Object Required Error in Excel Macro

Re: GetSheetObject Gives Object Required Error in Excel Macro