GetSheetObject Gives Object Required Error in Excel Macro
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;
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