Open selected path when clicking a button

[#1]

Hi,

have a table with 3 columns x, y and z. In column z is the path of a file.

I want to create a button which copy the path from a selected value in column x to the clipboard an opens the path in the explorer.

Could anyone help?

[sbaldwin]

Hi, you couly use the only function and the lauch external application action on a button to open the folder andthen add an action that runs  a macro something like this:

ActiveDocument.GetSheetObject("BU01").CopyTextToClipboard

where BU01 has the text =only(your_field_containing_path)

i've attached an eg.

Thanks

Steve

Sub mycopy
ActiveDocument.GetSheetObject("BU01").CopyTextToClipboard

end Sub

[brenner_martina · Accepted solution]

Hi, Charlie,

there is an integrated action in Qlikview, to open files, see attached example.

Greetings from Munich

Martina

EVACO GmbH

[#4]

Thanks a lot!

Both ways are working 🙂