#1   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default 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   Report Post  
Posted to microsoft.public.excel.programming
MaC MaC is offline
external usenet poster
 
Posts: 13
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM
copy formula down a column and have cell references change within formula brad New Users to Excel 5 May 13th 07 04:38 PM
Build excel formula using field values as text in the formula val kilbane Excel Worksheet Functions 2 April 18th 07 01:52 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM
Commenting custom formula fields/formula on formula editor Muxer Excel Programming 2 July 24th 03 01:02 AM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"