Hello John,
we already have such an infrastructure in place that we can extend to
support per-server pause/resume/restart functionality. See
http://www.stochastix.de/solutions/e...ual/s.rtd.html
for details.
Best regards,
Jens.
--
http://ManagedXLL.net/ |
http://www.stochastix.de/
Replace MSDN with my first name when replying to my email address!
"John.Greenan" wrote in message
...
As a firm one business area is design and build of spreadsheets for
investment banks and other financial services firms. Often we use third
party vendor implementations of RTD servers (for example - Bloomberg and
Reuters). Sometimes we find that a requirement exists to stop updating
the
data from RTD. This can be accomplished by setting the
Application.RTD.ThrottleInterval to a value of -1 (minus one). That's
fine,
but sometimes we want a more granular level of control - we want to be
able
to set the RTD.ThrottleInterval to -1 for one specific RTD, rather than
globally.
As an example, we have a spreadsheet that pulls in Bloomberg data (for
Bonds) and Reuters data (for equities). We want to be able to stop
updating
from Bloomberg, but continue updating from Reuters.
The suggestion is that there should be a change to the object model -
something like this
Application.RTDServers
RTDServers - a new collection
Application.RTDServers(varServerName) - would bring up one specific member
of the collection. The individual members would each have the properties
Application.RTDServers("myservername").RestartServ er
(note - RestartServer not RestartServers)
Application.RTDServers("myservername").ThrottleInt erval
Application.RTDServers("myservername").RefreshData
This would provide more granularity and allow for increased uptake of the
RTD functionality.
I'm more than happy to discuss this further.
--
www.alignment-systems.com
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...el.programming