VBA: How to show hidden sheets in a QV document

[#1]

I am trying to access QV sheet and its objects from Excel Macro. There are few sheets which are hidden and I want to show/access their properties. Let me know if anyone has successfully done it.

[#2]

Friends, has anyone tried this or has a solution to this. I have been trying multiple things but no luck as of yet. Below is sample of few trial and error statements.

Dim QVApp As New QlikView.Application

Dim QVDoc As QlikView.Document

Dim QVSheet As SheetObject

Dim SP As Object

Dim strFilename As String

Dim i As Integer

strFilename = "D:\QVReport.qvw"

Set QVDoc = QVApp.OpenDocEx(strFilename, 1, False, "001")

Debug.Print QVDoc.Sheets(0).GetProperties.Show.Always

Set QVSheet = QVDoc.GetSheetObjectByInternalCtlNo(5)

Debug.Print QVSheet.GetSheet.GetProperties.Name

Debug.Print QVSheet.GetStatus

QVSheet.GetSheet.GetProperties.Show.Always = True

'QVSheet.GetSheet.GetProperties.Name

For i = 0 To QVDoc.NoOfSheets

    Debug.Print QVDoc.Sheets(i).GetProperties.Name

Next i

Regards,

Rajesh

[#3]

why you use the Macro ?

Are you using QV Excel ?

[#4]

Yes. VBA in Excel.

Regards,

Rajesh

[#5]

I am not familiar with QV Excel.

Create the New Tab Called "QV Excel" and Copy all the requires QV Charts into this sheet and Select Always on Layout tab. Use these objects into your QV Excel,