Hi,
I am new to the world of Excel automation, and I need to
accomplish the following:

I have a text file containing a row of data on each line (each column
is delimited by a space). I need to automate the import of this data
into a corresponding excel spreadsheet, and the generation of a graph
from the spreadsheet. This task needs to be run once a day
automatically, getting data from the text file. Preferably as little
human interaction as possible should take place. Currently I already
have the excel spreadsheet template that contains the graph, I just
need a way to automated the input process, so I don't have to cut and
paste the data into the sheet everyday by hand.

The best case situation would be as follows:

1. The text file gets automatically updated once a day (I have already
done this part).

2. The excel automation (described above) would be kicked off after the
text file is updated.

3. Step 2 should produce as output the xls file corresponding the the
tables and the graph.

Any help would be greatly appreciated. THanks!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/