Replace application.RTD property by Application.RTDServers collect
 

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

Replace application.RTD property by Application.RTDServers collect
 

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