hi folks,

I have a mechanism whereby I have a plain text file that consists of rows of comma seperated entries.

At the moment I open the plain test file (using word-pad or note-pad), select all of the contents and copy them, then i go back into an excel sheet and paste the contents (Row, 2 column A), from this the remaining columns, strip out specific values and display them.

From this, a graph is generated.

I want to make the import less clumsy (with cut-&-paste) and instead be able to import the raw file either with a button click or some mechanism.

If someone can please point me to the right liturature I can them possible write a macro or something to do this.

Cheers