Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ange1234
Contributor II
Contributor II

How to specify which sheet in the excel file should be opened as first using button in QlikView?

Hello there!

I have created a button that opens an excel file (Actions -> Open URL).

It works but... The things is that there is several sheets in my file and I want to set only one that will always be opened as first. How can I specify a default sheet?

All the best,

Angelika

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

I think it's not possible - at least not with this approach. If you call a vbs-macro with your button which opens the Excel it could afterwards switch to your defined sheet.

Another method may be to implement an OnOpen macro within the Excel which queries the accessing user and switched then to your wanted sheet.

- Marcus 

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

I think it's not possible - at least not with this approach. If you call a vbs-macro with your button which opens the Excel it could afterwards switch to your defined sheet.

Another method may be to implement an OnOpen macro within the Excel which queries the accessing user and switched then to your wanted sheet.

- Marcus 

ange1234
Contributor II
Contributor II
Author

Thank you for the hints.