Continue to Site

Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

logging data to excel file in visual basic program

Status
Not open for further replies.

abbas1707

Full Member level 4
Full Member level 4
Joined
May 3, 2007
Messages
216
Helped
20
Reputation
40
Reaction score
8
Trophy points
1,298
Activity points
2,371
hi
can anybody plz tell me how to logg data to excel file in visual basic program.?
thanx in advnce
 

Log the data on VB and then with that data create a file with the fields separated by commas, like this:
**broken link removed**
name it *.csv and that's it you have a file that is openable with excel!
 

    abbas1707

    Points: 2
    Helpful Answer Positive Rating
VBA is built into Excel. It should be able to respond to MSComm receive events. You could then take the data from the RS232 port and put it where you want. You should also be able to poll for events. Look it up in the documentation for VBA.
 

Status
Not open for further replies.

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Back
Top