Help transferring data to templates

  • Thread starter Thread starter ajohns
  • Start date Start date
A

ajohns

Hi

I would like to use some macros to transfer some raw data from a txt
file into an excel template and then save it as an excel file with a new
name.

The txt files appear from a 33P counter and take about 7 minutes to read
and save.

Would a macro be the best way?

Many thanks

Yours

Andrew J
Fife
 
Seems like a reasonable approach to me.

If the text file is small, you could read it in (just File|open), then find your
data and move it to where you want it. (just record a macro when you do it once
manually to see your "get-started" code.)

If your text file data is not so small, you could even read through it looking
for your key values and pick the good stuff out of the clutter.

Chip Pearson has a very nice shell of a program at:
http://www.cpearson.com/excel/imptext.htm
 
Back
Top