erosergun
06-09-2011, 01:40 AM
Good day,
I read live data from a stock server using Excel DDE link with the following format: APP|TOPIC!FIELD.Detail.
Based on this information is it possible to access directly the streaming data fields from within VBA function, by-passing DDE links so that VBA code will get the data faster and run quickly.
One note: The program which gets the live streaming data from a stock server works on my computer. I have noticed I can pull all data fields in my VBA code from the said 3rd party program without explicitly embedding the data fields into Excel cells using DDE link. I thought I can completely by-pass DDE links then. For example, by declaring a streaming data object in VBA knowing the format above etc. Am I right? and how to do?
Thanks in advance.
I read live data from a stock server using Excel DDE link with the following format: APP|TOPIC!FIELD.Detail.
Based on this information is it possible to access directly the streaming data fields from within VBA function, by-passing DDE links so that VBA code will get the data faster and run quickly.
One note: The program which gets the live streaming data from a stock server works on my computer. I have noticed I can pull all data fields in my VBA code from the said 3rd party program without explicitly embedding the data fields into Excel cells using DDE link. I thought I can completely by-pass DDE links then. For example, by declaring a streaming data object in VBA knowing the format above etc. Am I right? and how to do?
Thanks in advance.