Modify macro statement

[bandrews]

I wish to be able to modify a macro statement by using a loop - need to change a single word in a statement.

[Leith Ross]

Hello Brandrews,

You need to give an example or show us some code.

Sincerely,
Leith Ross

[Norie]

Are you sure you actually need to modify the code itself?

[bandrews]

Yes. I don't know what stock symbols a user will want so I have to allow for the macro to automaticllay select them from a table. The Vlookup function can't work in the statement.

[royUK]

Can you explain what you want to do?

[bandrews]

In the following statement I need to be able to replace the QT1 with a stock symbol. Since someone may wish to obtain several sets of data, for several symbols, the replacement will have to be done through a loop.

Workbooks.Open Filename:= _
"http://ichart.finance.yahoo.com/table.csv?s=QT1&a=07&b=25&c=2006&d=08&e=24&f=2007&g=d&ignore=.csv"