Automated formatting and saving multiple files

[kerrydel]

I regularly receive files (3D point coordinates) that I must copy and save as text files for input to another program (Pro/Engineer).

Currently, I copy and paste rows/columns into WordPad and then save them as text files

The files that I get are all of the same format. The file has multiple blocks of numbers that each need to be put into a separate text file.

The original file is formatted as follows

9 rows x 3 columns
35 rows x 3 columns
35 rows x 3 columns

9 rows x 3 columns
35 rows x 3 columns
35 rows x 3 columns
.
.
.
.

...for a total of 9 'blocks'. There will be text and numbers between each group of blocks, but I can cut these out manually if it helps any, and the cells that I want don't start at A1 either.

So what this means is that I copy, paste and save 27 times to get what I want.

Is there any way of 'automating' (for lack of a better term) at least some of this work? Is it possible to do this without even using WordPad?

I am NO macro expert whatsoever, so that's why I'm looking for help.

Thanks in advance for any assistance.

Kerry DelVecchio
Peoria, IL