View Single Post
 
Old August 23rd, 2009, 06:58 PM
vickyso88 vickyso88 is offline
Registered User
 
Join Date: Aug 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple txt file input to excel in 1 row per file

Hi Excel Gurus!

I am new to Excel Macro and I am just wondering if you can help me with my problem. I have multiple txt files with the same format and tab delimited. I would like to run an excel macro that can convert my txt files to excel row by row for each txt file.

The excel columns should look like:
date time lot number operator serial nominal_values cx cy xh yx measured_values cx cy xh yx and so on...

The Input txt file looks like:

Date: 2009-07-10
Time: 14:19
Lot Number: 2
Operator ID: 48013275
Serial Number: H09F040104

Name nominal Values measured Values St.Dev. lower Limit upper Limit limit St.Dev.
cx 1240.0000 1232.9380 4.1540 1170.0000 1293.0000 50.0000
cy 1240.0000 1232.6350 4.0350 1170.0000 1293.0000 50.0000
xh 512.0000 497.3666 1.1670 470.0000 532.0000 5.0000
yh 256.0000 268.4369 0.6813 236.0000 286.0000 5.0000

Dist. 3.5000 3.4642 0.0000 3.3500 3.6500 0.0750
Res. Pixel/[°] 22.5000 22.3614 0.0000 22.1000 22.9000 0.0500

Pitch 0.0000 0.3140 0.0330 -1.0000 1.0000 0.1000
Yaw 0.0000 -0.4760 0.0560 -1.0000 1.0000 0.1000
Roll 0.0000 0.0860 0.0030 -1.0000 1.0000 0.1000

End of data