topic Re: how to get invisible sheet object with VBScript? in QlikView

how to get invisible sheet object with VBScript?

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts

I have a straight table wirh ID "CH01" , I can use "ActiveDocument.getsheetobject("CH01")" to get it with it is visible,

but it doesn't work if I set the table to be invisible

is there a way to get invisible sheet object so that I can export it to csv while I don't need to display the table

thanks

Re: how to get invisible sheet object with VBScript?

prat1507 — Tue, 20 Jun 2017 06:31:26 GMT

Hi Dave

It is not possible if you set the table as invisible, but what you can do is to keep a copy of the same object in another tab and keep it visible while you're on the current tab. You can use that object to export to .csv. And while you switch to the other tab, you can make it invisible again.

Regards
Pratyush

Re: how to get invisible sheet object with VBScript?

Anil_Babu_Samineni — Tue, 20 Jun 2017 06:48:47 GMT

I am not sure, What you are talking about. Does this related some objects are hidden and that you want to show those. If so, Ctrl + Alt + D --> Sheets --> Click where you are and go to Properties If not, sorry to trouble please explain little more

Re: how to get invisible sheet object with VBScript?

woshua5550 — Tue, 20 Jun 2017 08:10:51 GMT

Hi Anil

I don't mean to show it, I just want to export it while it is invisible:)

Re: how to get invisible sheet object with VBScript?

woshua5550 — Tue, 20 Jun 2017 08:12:02 GMT

Wise idea..