Populating a VBA array in Excel from a DDE array

[Gum]

I have the x by y array in Excel 2003 that originates from a DDE server. I
need to populate a VBA array (in excel) to manipulate elements in the array.
An example of the DDE array with 7 fields and each record is identified by
its time and symbol:
Time symbol BidSize BidPrice AskPrice AskSize LastPrice
12:01:33 DJ
12:01:39 DJ

If at all possible, I would not want to add the records to the excel
workbooks, only the results of computations (due to space/memory issues).

I need to access say LastPrice to find out what is the highest LastPrice
during a time interval and identify the event when the LastPrice moves above
or below a given level.

 

[Jim Gordon MVP]

I have the x by y array in Excel 2003 that originates from a DDE server. I
need to populate a VBA array (in excel) to manipulate elements in the array.
An example of the DDE array with 7 fields and each record is identified by
its time and symbol:
Time symbol BidSize BidPrice AskPrice AskSize LastPrice
12:01:33 DJ
12:01:39 DJ

If at all possible, I would not want to add the records to the excel
workbooks, only the results of computations (due to space/memory issues).

I need to access say LastPrice to find out what is the highest LastPrice
during a time interval and identify the event when the LastPrice moves above
or below a given level.

Hi

Check Excel's VBA documentation for the QueryTable topic.

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9

 

[Gum]

I searched the QueryTable topic including 'Methods for transferring data to
Excel from Visual Basic'. I have already done a QueryTable connected to a
database, but am unable to identify any datasource (from the list provided)
that can connect to the DDE links. The methods described all relate to
other data sources, and not to DDE links.

Kindly elaborate on the use of the QueryTable method to populate a VBA array
say xPrices from a DDE link: DDEserver|xPrice!DJ in Excel.