I have the following array formula:

{=QLink|Bars!'QQQQ,15,100,DTOHLCV,HEADERS,FILL'}

and would like to be able to grab it as text so I can plug it into a macro
and manipulate/replace some of its elements. For example, as it is now, it
pulls in price data for the symbol, QQQQ, in 15 minutes per bar. In the
macro, I would like to be able to change the symbol to SPY or any other
symbol, and also change the time period too.

I have tried a few things but have yet to figure out how to get the text of
this array formula into a cell or into a macro so that I can manipulate it.

My thanks in advance for any ideas! Cheers! Brad

The Range object has several properties you should explo Formula,
FormulaR1C1, and FormulaArray

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have the following array formula:

{=QLink|Bars!'QQQQ,15,100,DTOHLCV,HEADERS,FILL'}

and would like to be able to grab it as text so I can plug it into a macro
and manipulate/replace some of its elements. For example, as it is now, it
pulls in price data for the symbol, QQQQ, in 15 minutes per bar. In the
macro, I would like to be able to change the symbol to SPY or any other
symbol, and also change the time period too.

I have tried a few things but have yet to figure out how to get the text of
this array formula into a cell or into a macro so that I can manipulate it.

My thanks in advance for any ideas! Cheers! Brad

How about:

Application.Evaluate("QLink|Bars!'" & "SPY," & "15,"
"100,DTOHLCV,HEADERS,FILL'"

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=40080

If I recollect correctly, evaluate doesn't work with external
references/links.

--
Regards,
Tom Ogilvy


"davidm" wrote in
message ...

How about:

Application.Evaluate("QLink|Bars!'" & "SPY," & "15," &
"100,DTOHLCV,HEADERS,FILL'")


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=400807