DSE in FROM statement

[#1]

I have the following FROM statement in a LOAD:

http://finance.yahoo.com/q/hp?s=%5EDJI&a=04&b=6&c=2014&d=04&e=6&f=2014&g=d&z=66&y=0]

I want to use DSE to replace the variables (iow, I have a user selected number that I want to use).  Such as this:

Currently c = 2014.  I want c to equal: $(Begin_Year_Select).  I tried simply defining it as c=$(Begin_Year_Select), but it does not recognize it.  I am fairly certain the logic is right (as I have seen this before), I just think the syntax is wrong.  I also tried ($(Begin_Year_Select)) but that gave me an error when I tried to reload the data.

[marcus_sommer]

Use a textbox to build a complete path and if it worked transfer the logic to your load.

- Marcus

[MarcoWedel]

SET vBegin_Year_Select = 2014;

LOAD *
From [http://finance.yahoo.com/q/hp?s=%5EDJI&a=04&b=6&c=$(vBegin_Year_Select)&d=04&e=6&f=2014&g=d&z=66&y=0]
(html, codepage is 1252, embedded labels, table is @7);

works for me.

But only when using squared brackets around the URL.

Maybe these are missing in your script?

[#4]

Marcus,

I actually got it to work. I was confused as when I enterer the DSE it did

not change colors (as it usually does) to let me know that I was entering a

DSE. However, once I entered it I got the results I expected. Thanks!

[#5]

I actually got it to work. Now I have other issues...a little to

convoluted for e-mail. I am just going to take break and try again in a

little while.

[MarcoWedel]

Actually I wrote my answer alreay some hours ago, before you mentioned that you found the solution. My post was stuck in Moderation mode ...

... again ...