Changing the code on an external link.
 

I am using a program that gets data from a quote service.

=PROPHETX|QUOTE!'CN6[DTN:CBOT]?Settle'

This code will get the settlement price for CN6. What I want to do it
change this code to have the CN6 be cell location C8 on my page. I have
tried several things but the system thinks im looking for the settlement
price for C8 not what is located in location C8 on my spreadsheet.
Anyway you get the picture. Any ideas?


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=545484

Changing the code on an external link.
 

=PROPHETX|QUOTE!' & C8 &[DTN:CBOT]?Settle'

This is not work either.


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=545484