Making a Reuters function work in VBA

[gearoi]

Hi guys/guyesses,

I have this Reuters formula in Excel in a worksheet:

=DeHistory(A2,B4,A5:E5,A6,,A3,"LAY:HOR SORTESC SOURCEB
RECALL:AUTO HEADER:NO")

Now - the problem with this is that it pulls in the actual dat
'whenever it feels like it'. - ie asynchronously. I want to run a macr
that saves and closes the workbook once the data has been received.

I had a very similar problem with Bloomberg which I fixed by accessin
DDE through VBA which was code like this:

_______________________

' This will connect your app to DDE Server and return a channe
number. "Blp" is the
' application and "S" is the topic
stands for Static data

nChan = DDEInitiate("Blp", "S")

' Build the string for which you wan
to request data.

ISIN = Sheets("Bloomber
I").Range("CornerBBG1").Offset(down, 0).Value
sSecurity = ISIN & "," & BBGField

' Returns requested data

vtResult = DDERequest(nChan, sSecurity)

' Terminates DDE Connection

DDETerminate (nChan)

' Paste result into worksheet

If (grpofcolscount + 1) * 15 < colscoun
Then resize_to_col = 15 Else resize_to_col = colscount Mod 15

Sheets("Bloomber
I").Range("CornerBBG1").Offset(down, 1 + (grpofcolscount
15)).Resize(1, resize_to_col).Value = vtResult

_____________________________________

My question is - how do I find the syntax/code for this similar proces
using Reuters.

I have spoken to the Reuters helpdesk but they are clueless - have an
of you people done this?

Cheers,
Gearo

 

[gearoi]

bump,

Reuters joined to Excel in VBA - some of you guys must have seen this,
no?

cheers,
Graham

 

[jsp]

Hi,

I'm facing exactly the same pb as you did with the refreshing of
Reuters table

I would like to "force" that refreshing using VBA code

Did you finally find a solution for that (ie using DDE)??

Many thanks in advance
Cheers,

J