topic Re: Launch excel from a variable from actions in QlikView

Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 09:40:50 GMT

I have made a button able to launch excel and a spreasheet from a button and the following 2 setups in Actions>Launch work correctly.

This is works:

Application:

Excel.exe

Filename:

"File name.xls"

Working Directory:

And also this:

Application:

Excel.exe

Filename:

"File name.xls"

Working Directory:

=$('History File Location')

But when I try:

Application:

Excel.exe

Filename:

=$('Historical filename')

Working Directory:

=$('History File Location')

=$('Historical filename') is entered as File name.xls

and

=$('History File Location') is entered as

Can anyone tell me please why the variable on the filename won't work with launch?

Re: Launch excel from a variable from actions

settu_periasamy — Mon, 10 Aug 2015 10:14:48 GMT

Hi,

Instead of

=$('Historical filename') Try = "Historical filename"

Same as

=$('History File Location') Try ="History File Location"

Re: Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 10:27:02 GMT

Thanks, Qlikveiw does not like the space inbetween " "

Re: Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 10:32:28 GMT

The answer is:

But when I try:

Application:

Excel.exe

Filename:

=[Historical filename]

Working Directory:

=$('History File Location')

Square brackets around the filename and " " around the spread sheet name

"File name.xls"

Thanks

Re: Launch excel from a variable from actions

settu_periasamy — Mon, 10 Aug 2015 10:36:14 GMT

It is worked for me.

try to remove the square bracket from Y:\ABC\DEF

See the below screen shot..

Re: Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 11:46:12 GMT

When I follow your suggestion I can only get it to work when I wrap file name.xls in ""
"file name.xls"

Also I am trying to join in the load script

FROM

$(History File Location)+$(Historical filename)

Re: Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 11:48:26 GMT

The reason for me splitting is that when launching from a button Qlikview needs 2 variables.

Re: Launch excel from a variable from actions

avinashelite — Mon, 10 Aug 2015 11:56:27 GMT

as a standard format you can use _ between the words of variable rite like History_File_Location !! is their any specific reason for the variable name??

Re: Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 12:29:26 GMT

The problem is the space in the file name and directories.

I want the user to be able to open up an excel file from a button in qlikview and to make it easier I want the directory and filename to be stored in seperate variables; the directory will change each month but the filename will not.

Then I would like the same 2 variables that make up the location to be used in the load script.

Thats my objective, both file names and directories will have space in at some point.

Thanks.

Re: Launch excel from a variable from actions

settu_periasamy — Mon, 10 Aug 2015 13:01:19 GMT

May be, you can try this

for File Name : =chr(34)&[Historical File Name]&chr(34)

Working Directory : =chr(34)&[History File Location]&chr(34)

Re: Launch excel from a variable from actions

avinashelite — Mon, 10 Aug 2015 13:02:46 GMT

sorry try like this :

='"'&Filename&'"'

in the path

Filename:

='"'&Historical filename&'"'

Working Directory:

='"'&History File Location&'"'

i.e comma double quotes & your variable & comma double quotes

this should work

Re: Launch excel from a variable from actions

tinkerz1 — Mon, 10 Aug 2015 13:17:14 GMT

Now this worked in the Load scrpt

$(History File Location)$(Historical filename)

And to launch Excel.

Application:

Excel.exe

Filename:

=chr(34)&[Historical filename]&chr(34)

Working Directory

="History File Location"