AGG Software Forums
September 20, 2024, 01:39:25 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
  Home Help Search Login Register  
  Show Posts
Pages: [1]
1  Online Help Center / Data loggers and plug-ins / How Excel work with DDE? 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.
Pages: [1]
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines