topic Re: Open Excel App with parameter in QlikView

Open Excel App with parameter

Thu, 08 Sep 2011 09:39:01 GMT

Hello,

I want to open the application Excel with a parameter, so I used the following formular in my diagram:

='excel<url>"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e'

I set the presentation type of the formular to "hyperlink".

If I click on the hyperlink in the diagram, QV ask if I really want to open it, but then says it can't open the application. If I only try the following formular, Excel opens:

='excel<url>"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"'

I also tried the following but it doesn't work, too:

='excel<url>"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE /e"'

Do you have any idea?

Thanks a lot.

Peggy

Open Excel App with parameter

Miguel_Angel_Baeyens — Thu, 08 Sep 2011 10:09:43 GMT

Hi Peggy,

I'd create a shortcut to the EXE file with the parameter, and call in the expression to the .LNK file. I've just tested it and that works.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Open Excel App with parameter

Thu, 08 Sep 2011 10:39:09 GMT

Hi Miguel,

that would be the solution if I would always use the same path, but here I only described a simple example of my real world.

In reality I want to call another application (archiv) and I have to put parameters for the document ID within the path. So I need to call it from QV.

Thanks.

Peggy

Open Excel App with parameter

Miguel_Angel_Baeyens — Thu, 08 Sep 2011 11:17:28 GMT

Hi,

Then I'm afraid you should create buttons that depending on each value selected in the table, builds the path to the application. In the Actions tab of the button and text object you do have a section where you can add parameters. The link representation is not for running software rather than actual URLs. If you set the path with parameters in the Open URL action, that will not work either.

Hope that makes sense

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica