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

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

ange1234 — Mon, 10 Jan 2022 11:56:39 GMT

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

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

marcus_sommer — Tue, 11 Jan 2022 14:30:56 GMT

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

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

ange1234 — Thu, 27 Jan 2022 09:17:33 GMT

Thank you for the hints.