Batch importing data sets into EXCEL and then plotting

[hill007]

Hi,

I have a series of TXT files. All of these TXT files are in same
format.
I want to import all the TXT files in a batch into EXCEL. After
bringing in the TXT file in each worksheet, I then want to make a
scatter plot of each TXT file. The plot would be Date format in x-axis
and in y -axis Data values.

Once these plots are made I then want to put total of six plots in
each page.

I am including a TXT file as an example.
I would appreciate if anyone can help as how to automate the process.

Thanks.

Attachment filename: ex1.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=551237

 

[AlfD]

Hi!

Before trying to automate the process, best do a manual run.
If that works to your satisfaction, look to recording a macro, plu
some manual improvement of the macro, to do the batch job.

Have you reached the point of being able to plot a graph of the data i
your .txt file?

Al