Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Automatically changing link. How? | Excel Discussion (Misc queries) | |||
how do i insert a code bar or link to a adobe designer file | Excel Worksheet Functions | |||
How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
Changing bulk Link references to different workbook. | Excel Discussion (Misc queries) |