|
Title: How Excel work with DDE? Post by: JoySun on May 09, 2009, 05:39:45 AM The Measurement data could be sent to EXCEL by DDE.
We can see the data show out in DDE server. The data also show out in Cell(21,4), refers the example download from: http://www.aggsoft.com/asdl-excel-read-via-dde.htm Why the data will not show out in Cell(1,1), Cell(2,1),..., etc., When data send out one by one? Why the VB does not execute "Private Sub Worksheet_Calculate()" or "Private Sub Worksheet_Change(ByVal Target As Range)" when DDE transfer data to correct location. When manual typing data instead DDE doing to Cell(21,4), the excel does execute VB and send data to Cell(1,1), Cell(2,1),...,etc.. The system OS is WinXP Pro. SP3, Excel is 2003 SP3. Title: Re: How Excel work with DDE? Post by: Arthur Grasin on May 09, 2009, 08:39:08 AM Did you allow macros in Excel? When you open the example file, the Excel should ask you about it.
|