DDE link in Access 2003

[write2avir]

Hi! I am a newbee.
I have a online trading software which allows DDE links. I usually
make DDE links in my Excel and analyze the data.
I am wondering if I can make DDE links in Access 2003 and can analyze
multiple trades?
If yes, where i can find more information about it?

Many Thanks!
Avir

 

[Guest]

Yes you can make DDE links in VBA. Look at the help while
in the VBA window for more information.

AFAIK, you can't link a cell directly to a DDE source.

(david)

 

[gllincoln]

Hi Avir,

Yes, you can do this. Look at the help files - the process is somewhat more
complicated but the end results provides a more robust history capability.

Generally speaking, the link to your trading software will be virtually
identical to how you are bring the information into Excel, but instead of
putting the data into a range of an Excel sheet, you will be import rows to
a table or perhaps updating them.

Hope this helps,
Gordon

 

[Avir]

Hi Avir,

Yes, you can do this.  Look at the help files - the process is somewhat more
complicated but the end results provides a more robust history capability.

Generally speaking, the link to your trading software will be virtually
identical to how you are bring the information into Excel, but instead of
putting the data into a range of an Excel sheet, you will be import rows to
a table or perhaps updating them.

Hope this helps,
Gordon

Thanks for your help. I will follow this lead to make it work.