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

Hello!



Thank you for the responses.



To simplify the requirement, I made sample input txt files below and the sample output format in excel.



Input txt file #1



11 AAA

22 BBB

33 CCC



00 77 88 99

44 DDD GGG JJJ

55 EEE HHH KKK

66 FFF III LLL





Input txt file #2



11 MMM

22 NNN

33 OOO



00 77 88 99

44 PPP SSS VVV

55 QQQ TTT WWW

66 RRR UUU XXX



The output excel file format should look like this:



AAA BBB CCC DDD EEE FFF GGG HHH III JJJ KKK LLL

MMM NNN OOO PPP QQQ RRR SSS TTT UUU VVV WWW XXX



Assumptions:

- the input files are tab delimited

- same format for all input txt file

- 1 row per txt file in excel output



Please help.

There are many ways to read a text file

http://vbadud.blogspot.com/2007/06/v...h-leading.html

The above URL should help you

Once you read the information line by line then you can remove the numeric characters by using IsNumeric

Please start with the intial coding and we will be always glad to take you through

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

I recommend you to use GemBox Excel component for .NET. Here is a list of reasons why it's better to use it then regular Excel Automation/Interop.