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?

[avinashelite]

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

[tinkerz1]

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"