open extern qv file with a certain sheet

[thanhphongle]

hello community,

is there a possability to open a qv file qith a certain sheets i would like to select

for excample

Company.qvw file has 4 sheets.

1. Sheet - Accounting and Finance

2. Sheet - Logistics

3. Sheet - Sales

4. Sheet - HR

what i like to do is, clicking on a button which opens the Company.qvw file and at the same time the sheet Sales. I know that i can create a button and select as action open external file or open sheet. but how can i combine both?

[thanhphongle]

i have a lot of qvw files. for each file i have a customer. thats y i cant combine everything in 1 tool

[awhitfield]

I presume that users will be using the Access Point to view the qvws, if so, the example works ok, , as when you navigate back from Analysis to Company, Analysis effectively closes...so the OnOpen trigger works!

Give it a try out!

[thanhphongle]

hehe, yes i ll give it a try. thank you for your help !