DDE link in Access 2003

W

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
 
G

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)
 
G

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
 
A

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
Click to expand...

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