data logging / data capture

[peroberts]

I am capturing the data output from a CO2 incubator, using TeraTerm, into a log file. An example of the data is below. I would like to be able to use VBA to copy the fourth value after each asterisk and nothing else, and paste it into an excel worksheet. Can anyone steer me in the right direction? Thanks for any help here!

-Penny

*
0503
0012
0503
0507
0000
0000
Current CO2: ,503
Predicted CO2: ,503
Displayed CO2: ,507
Predictor Gain: ,0
CO2 injection (0/1): ,0
CO2 report errors: ,0
M400 read errors: ,0
Bad or prohibited cmd: ,0
Busy retries: ,0
Loop count: ,2494
----------------------------

*
0504
0012
0503
0507
0000
0000
Current CO2: ,504
Predicted CO2: ,503
Displayed CO2: ,507
Predictor Gain: ,0
CO2 injection (0/1): ,0
CO2 report errors: ,0
M400 read errors: ,0
Bad or prohibited cmd: ,0
Busy retries: ,0
Loop count: ,2495

[MarvinP]

Hi Penny and welcome to the forum,
(I have a sister named Penny who now goes by PJ and lives in So SF)

Find the attached where I've written a macro to do what you want.

Open the attached and import your log file. It should go into Column A. Then run the macro which looks for "*" in column A and copies the 4th number after the "*" to column E.

Hope this helps.

[peroberts]

This is terrific! Works a treat. Thanks so much for your help.

-Penny