Hi,

Can any one elabrote how "SetLinkOnData" can be used ... I want to save the
tick by tick data i m getting in excel by DDE. Pls help me out as i am not a
programmer

JAldeep

"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