Serial Logger Data to Excel directly

[Rob]

Has anyone written a simple VB/macro application that will enable serial
data to be read directly into Excel that they are willing to share?

I've hunted the net and found lots of leads but no suitable applications.

I want to play around with a simple PIC data logger and read the serial data
directly into Excel, rather than to a CSV file which is imported into Excel.
I'm not too fussy about the format / framing etc. I'm not able to write the
required VB from scratch but may be able to modify any sample code to do
something useful.

Any help or pointers to useful information greatly appreciated..

regards
rob

 

[James Meyer]

Has anyone written a simple VB/macro application that will enable serial
data to be read directly into Excel that they are willing to share?

I've hunted the net and found lots of leads but no suitable applications.

I want to play around with a simple PIC data logger and read the serial data
directly into Excel, rather than to a CSV file which is imported into Excel.
I'm not too fussy about the format / framing etc. I'm not able to write the
required VB from scratch but may be able to modify any sample code to do
something useful.

Any help or pointers to useful information greatly appreciated..

regards
rob

Use Google and the search term <serial data wedge> (without the
brackets) to see a list of possibilities. Some free stuff too.

Jim

 

[Adrian Jansen]

Since you mention VBA, a quick and dirty method is just:

Open "Com1:9600,n,8,1" for input as #1

lineinput#1,strMyInput

Close #1


Change Com1 to whatever port you actually use, and the comspec string to
suit baud rate, data and stop bits.
You may also need to set the handshaking to 'off'
All the settings are explained in the help file for the com port commands.
Specify a row/column location in the sheet, and put the string strMyInput
there.
Parse as necessary

You will need to put some command buttons on the sheet to enable, disable
the serial comms.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Rob]

Thanks for your help Jim & Adrian.
regards
rob