Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to open a specific Excel Sheet with a button

Hi,

When using the object 'Button' and launching Excel (Properties-->Actions-->Launch).

Is it possible to open a specific sheet (like when executing script load) and not only a specified File.xlsx?

If so, what is the sintaxis?

Thanks

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

With actions or as link is it not possible because it opens the file with the last saved state. Per macro with vbscript (works not with AJAX) you could open this file and afterwards changed to any sheet you want.

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

With actions or as link is it not possible because it opens the file with the last saved state. Per macro with vbscript (works not with AJAX) you could open this file and afterwards changed to any sheet you want.

- Marcus

View solution in original post