Launch excel from a variable from actions

[tinkerz1]

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?

[settu_periasamy]

Hi,

Instead of

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

Same as

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

[tinkerz1]

Thanks, Qlikveiw does not like the space inbetween " "

[tinkerz1]

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

[settu_periasamy]

It is worked for me.

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

See the below screen shot..

[tinkerz1]

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)

[tinkerz1]

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

[avinashelite]

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??

[tinkerz1]

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.

[settu_periasamy]

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)