ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel to inport data (https://www.excelbanter.com/excel-worksheet-functions/228955-excel-inport-data.html)

Danny

Excel to inport data
 
Excel to inport data via the Com port 1

joel

Excel to inport data
 
I think you'll need a macro. Not sure need more details. Where is the data
coming from. If possible it would be easier to read a file. The prblem with
the serial port you usally need to send commands to the device on the serial
port before the data is downloaded. You can inport data into a file by going
to DOS and create a file in DOS.

From the Start menu select RUN. Then type in Run box cmd.exe.

Now a Dos window will appear.

the type the following

copy com1: abc.txt

Download your file. When done kill the DOS window to stop the transfer.
Now you data will be in the text file.

"Danny" wrote:

Excel to inport data via the Com port 1



All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com