Hello.
Did you resolve the issue? I would be grateful to receive a soultion on how
to fire a macro on DDE data update.

"dwt" wrote:

Tom,

thanks, that gives me a place to get started..

d

"Tom Ogilvy" wrote:

See the SetLinkOnData method of the workbook if you want to fire a macro to
do the saving. In xl2000 and later you can use the newer Change event.

What you do with the data is your own choice.

Some information on working with Access:


http://www.erlandsendata.no/english/...php?t=envbadac

--
Regards,
Tom Ogilvy

"dwt" wrote in message
...
I have an Excel spreadsheet which gets tick data for trading currencies on
the forex markets. The DDE conversation works just fine, but i need a way
to
save this data. Does anyone have any experience working in this
enviornment
and do you have any suggestions. I think it might be best to save the data
to
an SQL or Access database.

Any thoughts or help with this would be appreciated.

david