Hi,
I am a brad new in Excel and this is my first project.
I need to click on butom transfer data from *.txt file *.xls play with that data and create diagrams.
I putted a button on ‘sheet1’ and on click transfer data I found : ‘Workbooks.OpenText’.
It is work ,but it looks like create a new project and I can’t play with data.
In my understanding the data need to be paste into shee2 and after that I can do something.
My question: can you give me an ides how can I paste date into sheet2?
For what use ‘ThisWorkbook’?
If I am wrong how can I do it?


Thanks’