how to get invisible sheet object with VBScript?

[woshua5550]

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

[prat1507 · Accepted solution]

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

[Anil_Babu_Samineni]

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

[woshua5550]

Hi Anil

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

[woshua5550]

Wise idea..