Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD formula
Hi
I have a function that returns the following string =REUTER|IDN!'VOD.L,LAST' I want Excel to enforce calcuation of this RTD formula and not treat it as a string. How can I do that ? Thanks B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD formula
That's a DDE formula, not an RTD formula. If you mean DDE rather than RTD
then the answer is to check the cell formatting - it should be general. Switch to general and then edit the cell and it should start the Reuters local DDE server. If that does not work then you should post back. -- www.alignment-systems.com "ben" wrote: Hi I have a function that returns the following string =REUTER|IDN!'VOD.L,LAST' I want Excel to enforce calcuation of this RTD formula and not treat it as a string. How can I do that ? Thanks B |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD formula
In Excel VBA you can use RUN command to run any macro, e.g.
Run "REUTER" Obviously, you can replace function name by any string, which is correct macro or function/sub name. Good luck! MarioC Uzytkownik "ben" napisal w wiadomosci oups.com... Hi I have a function that returns the following string =REUTER|IDN!'VOD.L,LAST' I want Excel to enforce calcuation of this RTD formula and not treat it as a string. How can I do that ? Thanks B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |