Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Read data into Excel from COM!?
There appears to be a way to connect to a COMM port to import data directly
into Excel, using a Microsoft Communications Control object inserted from the Control Toolbox, but I can't find any help on using it. I set the comm port and communication properties, but nothing happens. I want to capture a data string coming in every 60 seconds on COM1 from an instrument I have. |
#2
|
|||
|
|||
"Russell Seguin" wrote in message ... There appears to be a way to connect to a COMM port to import data directly into Excel, using a Microsoft Communications Control object inserted from the Control Toolbox, but I can't find any help on using it. I set the comm port and communication properties, but nothing happens. I want to capture a data string coming in every 60 seconds on COM1 from an instrument I have. All I have found is an add-in that does this. I think you would need to code this in VB6, C#, or C++ if you want to do this yourself http://www.geocities.com/lyesoft/ /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving blocks of data in excel | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
Charting Data from Excel | Charts and Charting in Excel | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) |