View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hotbird[_3_] Hotbird[_3_] is offline
external usenet poster
 
Posts: 10
Default Visual Basic and Excel

I am using a Visual Basic application (which receives and presents serial
(text) data on a full-frame form in real time) and would like to add a line
of code in the MSComm1 module so that the same serial data can be sent to a
cell in an excel spreradsheet for simultaneous analysis. Is this possible?
And what command structure is needed to write from one application (VB in a
minimised window) to Excel (maximised)? Am able to post a portion of the
MSComm1 code handling received data if the idea is sound.