Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |