automatic graph creation

[Junne]

Hi,

I've included the file example.txt.
What I would like to do is to create a macro that opens a selection box so I can open any file like example.txt
The content of this file has to be copied to a new sheet in the active workbook and the name of this sheet should be the same as the filename (example.txt).
Then a graph should be created of the values in example.txt en it should be placed in an existing sheet (other than the just created sheet) that I could select, for example with an inputbox where I type the name of the destination sheet.
I've tried to do this by recording my actions but this gives a macro that is not fully automated. I need to repeat this several times with files with other names and the destination sheet can also change.

Since my knowledge of VB is limited any help, tips or bits of code I can use are very welcome

Thanx in advance,
Jurgen