Receive Data From COM Port Or USB Live Into Excel?

Aug 12, 2010

I have blocks of data that arrives from a remote terminal via RS232/COM1 port.

Each block has carriage return at end of the data.

I like to receive the data direcly into EXCEL so it will feel like the remote computer is typing into my EXCEL.

Do I need an interface program outside EXCEL or a MACRO can do the same and how do I do it?

Is there anyway to have the serial data go to keyboard buffer that EXCEL operates from it?

View 7 Replies


ADVERTISEMENT

Timer Tick Event And Serial Port / Read And Display Live Data?

Jun 21, 2009

[code]...

I have a quick question regarding the serial port and timer tick event. Basically i have a micro processor connected to the PC via the serial port. With a baurd rate of 38400 set.When the PC sends the micro ":K + VBCRLF" the micro response with a string of information (ASCII encoded) and delimited with a "," and at the end of the transmission a cartridge return line feed is added.Example of sent string:

"12,1134,123,545,76,6868,34,232,1,2,3,6,7,8" These numbers are then split using the VB mystring.split(",") function into an array of strings, then the numbers are converted using ctype. After which my UI is then updated.I have Witten the code in a tick timer event using a timer count of 300ms. Although the program runs and the UI is updated i end it with lots of exception errors. I think allot of this is down to the serial port either timing out or not reading complete string.Or possibly the timer has not executed all the code before another tick event happens Even after adding a few try catch statements i am still having problems. Can anybody suggest a better way of doing it?I was thinking of using a do while loop and at the end a sleep function instead of the timer tick event.I need the speed as i am trying to read and display live data.

[code]...

View 1 Replies

Receive HEX Data Through Serial Port?

Jan 5, 2009

I am trying to recieve HEX data from a seriall device. Code is as below . but the required output is not correct. Some chracter code are not correct even in decimal . like for 80 i recieved 3F and for c0 also.for example i recived a string .

10 02 3F 00 10 03 3F 61
but in actual data should be
10 02 80 00 10 03 c0 61

[code].....

View 2 Replies

Send And Receive Data Through USB Port?

Jan 24, 2008

I am trying to send and receive data through a USB port on my computer to an external microcontroller.

I built most of the code using the "serial class" but then i read that this would not work with a USB port.

How would I go about communicating with this USB port on my computer?

View 5 Replies

VB Receive Data From Serial Port?

Apr 20, 2011

I use ReceiveSerialData() function to get a string (20 byte of 8 bit data) from serial portBut I faild and got the error "operation has timeout". I am new in VB 2010

View 10 Replies

Communications :: Receive Hex Data On Serial Port?

Jan 5, 2009

I am trying to recieve HEX data from a seriall device. Code is as below . but the required output is not correct. Some chracter code are not correct even in decimal. like for 80 i recieved 3F and for c0 also. for example i recived a string .

10 02 3F 00 10 03 3F 61

but in actual data should be

10 02 80 00 10 03 c0 61

Public Sub DataSeriallReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort.DataReceived
Dim buff As String

[Code].....

View 2 Replies

Receive Data From Serial Port To Page?

Feb 28, 2011

I am working on my project "PREPAID RESTAURANT CARD USING RFID TECHNOLOGY" in which i sent 12 digit number (rfid tag id) to serial port through my hardware and receive at my vb.net 2008 page.but i don't know how to receive data in vb page in the textbox using which cammand.

View 1 Replies

Receive Data From The Serial Port After Message Is Being Sent?

Aug 4, 2009

I am doing a project on sending and receiving sms from a serial port. But I have a problem on receiving sms. About the receiving sms, how can i show the received sms in the textbox using the serial port. Do I have to use the DataReceived Events. Here is the code i am using:

Public Class Form1
Private WithEvents serialPort As New SerialPort
Private ReadThread As Thread[code]....

View 1 Replies

Receive Incoming Data From Serial Port?

Mar 23, 2011

I am having problem receiving data from serial port. Btw, I am new to Visual studio 2010 too.

I do a test program on my PIC so that when button1 press, it will send character "Y" to visual studio; when button2 press, it will send character "N" to visual studio. I know for VS 2010, sending data out is by the command

[Code]...

View 1 Replies

Send And Receive Data From A Serial Port?

Jul 8, 2011

I have created a program to send and receive data from a serial port, some of the data needs to be stored in certain strings for a export to excel. However the data takes while to to send be sent back. So in order to get the right information in the right strings I have to put pauses in my code. I have added a timer to my form:

On my timer's tick event I have the following code:

Public Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
iTick = iTick + 1
End Sub

View 3 Replies

Unable To Receive Data From The Serial Port (VB)

May 4, 2011

I am writing a VB based program which will receive data from a Micrcontroller (programmed in C) via UART. The data that is transmitted from the Microntroller can be displayed on Hyperterminal when I set it up with the correct settings (Baud, Parity etc), so I know that Microcontroller end is working fine. The VB-based program however (written in Visual Studio 2010 Express), does not however receive any data and I always get the TimeOut exception (despite the fact that Microcontroller is sending data via UART, I have an onboard LED to indicate this). Here is the VB code, it is an adapted version from the MSDN library:

[Code]....

View 11 Replies

Receive Continuous Incoming Data From A Serial Port (MCU) In Vb?

Mar 7, 2012

I am working on a project to receive and send data to a micro controller using a Visual Basic application. I am using Visual Studio 2008. I have done coding to send data on button click event.

But I am stuck at how to receive incoming data to serial port continually from MCU and store it to an integer or string type data in VB.

View 1 Replies

VS 2010how To Transfer Or Receive Data Via Parallel Port

Dec 19, 2011

I want to control the D0-D7 pins of the parallel port(LPT) with VB2010. I do not need to transfer or receive data via this port, all I want is to set high or low (5V or 0V).Is it even possible?

View 4 Replies

Serial Port - Receive Incoming Data From Radio Equipment?

Apr 8, 2009

I have an application that receives incoming data from a Radio Equipment through a hardware modem. How can I replace the hardware modem? Could I use the PC Sound Card in place of the modem?

View 9 Replies

Serial Port Communications - AT Commands - Send And Receive Data

Apr 12, 2009

I have a USB modem that can detect caller ID and can detect dialled digits when special AT commands activated, How to send and receive data. The sent data will be the AT command such as AT+VCID-1 to activate the caller ID, the received data will be caller ID information and the digits dialed. I'm new to prgramming and using Visual Basic 2008 Express.

View 8 Replies

Receive Data From Serial Port Link To Itegno Modem W3800

Sep 17, 2009

I am wondering is there any code to get the text reply from the modem? I am using the itegno W3800 modem. I have used the below method so far but apparently VB.NET windows form doesnt see the incoming data. The message box comes out empty. But when i try the same method with the TMAS Siemens GSM modem, VB.NET can see the incoming data and display out the data string.

here is the code that i have written:

serialPort.Write("AT" & vbCrLf) 'set command message format to text mode(1)
receiveddata = serialPort.ReadExisting()
it works for the TMAS gsm modem.

The baud rate for the TMAS GSM modem is 9600 and the baud rate for the itegno modem is 115200.

For the itegno modem, the data is sort of like stuck at the serial port as after every time i pressed on the button for example "AT"

this "AT" command gets "stuck" at the serialport and run only when i have connected through the serial port in hyper terminal.

I am thinking is it the baud rate for 115200 is too fast for VB to handle? And also is there any way to solve this problem?

i have to revert back to the itegno modem for use for my project at the end of the day.

View 2 Replies

Post A Windows Application That Uses Excel For Live Data Calculations?

Jul 14, 2009

Can I Post a Windows Application that uses Excel for live data calculations? Basically from the Windows app, a user makes a menu selection and which in turn opens an excel file in memory using it for calculations. These files are put together by different groups and formatted for the Windows app to build interfaces based on each file.I also accompany an .mdf file as well. Is all this possible for customers to access and run this with Windows Azure.

View 2 Replies

Padding Receive "Hex" Data From Serial Port?

Dec 12, 2009

How do you add the "0" to the Hex value? What I get: 881 Should Be: 8801

Dim ByteCounter As Integer = 0
Dim DataPacketLenght As Byte
Dim Databyte(DataPacketLenght - &H1) As Byte

[code]....

View 2 Replies

VS 2008 - Excel And Data Grid - Importing An Excel Into A Data Grid - Receive The Value "null"

Mar 10, 2010

I have a problem with importing an excel into a data grid.

Here is my code:

Try
Dim _Obj As New ExcelConnection.ExcelConnection
_Obj.ImportAttendence("c:Info_pc.xls", DataGrid1)
Catch ex As Exception

End Try

In the excel i have numers and text and "Service Pack", "Processor Speed" and "Numar procesoare(Number of processors)" and the values for these are numers. in the data grid when i import the excel those values doesn't appear, i receive the value "null".

View 7 Replies

C# - Send And Receive A Tcp Message To A Specific IP/Port In .NET?

May 18, 2011

I'm trying to send a message to a specific IP/Port and receive a reply in an ASP.net website, i tried the method describd at the following link but it didn't work for me as you can see SocketException An attempt was made to access a socket in a way forbidden by its access permissions

View 1 Replies

Communications :: Receive Text From Serial Port

Apr 23, 2008

I'm trying to receive data from the serial port and display onto a text box in my gui in vb. I'm using xp pro sp2 and vb 2008 exp.What i've done so far:

- I'm able to send data successfully (tested) to the serial port
- I can dispaly what data is being sent (tested)

Steps taken:

- I have looked around on this forum for something similar to what I have but no similar posts are here
- Will look into MSDN help shortly
- Will also try some vb books I have lying around. But the problem is most of the vb books deal with sql server and database stuff and not really interfacing to hardware.

View 1 Replies

Receive Datas From EPBX Through Serial Port?

Jul 22, 2009

How can receive datas from EPBX through Serial port in vb net

View 1 Replies

Receive Wrong Caracters From Serial Port?

Dec 15, 2011

I need to communicate with a PLC in serial port. PLC sends 4 possible data: 0, 1, 2 or 3 (which are status).My vb.net program uses IO.Ports.SerialPort class. When I read the data, the "1" and "2" are good, but the "0" and "3" are received as "?". I tried all the Read method (ReadByte, ReadExisting, Read, etc), it always give the same result. In HyperTerminal, it's fine.I made a test program in another computer (Win 7). Test was perfect, I received all 4 status correctly. I ran the same test program on the original computer (Win XP) and once again, I got the "1" et the "2" but the "0" and the "3" was "?" (ascii 63).

View 1 Replies

VS 2010 - How To Get Users To Receive Messages Without Port Forwarding

Aug 8, 2011

I am testing out packet sending with some friends and I've made a chat program which seems good and all...(not really, its really bad actually), But anyway... The users cant receive incoming messages unless they portforward port 1337 to their computer... How can I get users to receive messages without portforwarding?

View 7 Replies

Read The Data From Barcode Weight Scales By Serial Port And TcpIp Port?

Nov 27, 2010

I'm mohammed from Oman ,I'm visual studio.net programmer How I can Read the Data From Barcode Weight scales By Serial port and TcpIp port

View 7 Replies

Check If String, Which Receive Via A Serial Port Matches To A String In A Database (access)?

Jun 22, 2010

I got an app, which receives data via a R232 port, convert it to a string and on the other side I got a database, where the strings are saved. How can I find a way to compare the string with all strings in one database column and get back the another stringform the same row in this database. I never programmed a database

View 1 Replies

Live Currency Exchange Rates Data

Nov 26, 2009

I have only just started on .Net (C#, VB) programming. Does anyone know how to retrieve live currency exchange rates data for example SGX stock market exchange rates. I am supposed to do a program which retrieves live currency exchange rates and then make use of the data on a currency converter.

View 3 Replies

VS 2005 - Retrieving Live Currency Exchange Rates Data

Nov 26, 2009

I have only just started on .Net (C#, VB) programming. Does anyone know how to retrieve live currency exchange rates data for example SGX stock market exchange rates. I am supposed to do a program which retrieves live currency exchange rates and then make use of the data on a currency converter.

View 1 Replies

Receive XML Data Via URL

Aug 29, 2011

Am told to receive XML data via URL. Can someone suggest the best way to achieve this without any authentication required at the level of server. Best Regards, Harikrishnan R

View 3 Replies

Can't Receive Data Using Winsock

Jul 20, 2009

I'm working on a server/client chat program in vb 2008 using winsock. I have a connection and can send data, but for some reason I can't receive data. [Code]

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved