Copy data from a text file

[Traymond]

I have a macro that i use a shell command to run a batch file . the batch file produces a file
named table.txt Here is my question, can the macro open that text file after it has been created , copy all the data and then paste into say cell F5 of my Worksheet . below is sample table.txt file. i found a macro that would open a source file and then append to a new . txt file, but i need it to copy and paste the data into my excel sheet. Thanks for any help they may be offered.


table.txt

10.10.100.123 SHARED
10.10.100.124 NOT SHARED
10.10.100.125 SHARED
10.10.100.126 NOT SHARED
10.10.100.127 SHARED
10.10.100.128 NOT SHARED

[JBeaucaire]

Something like help?

Please Login or Register  to view this content.

[Traymond]

Bam !!!! that is perfect.... Thanks Jerry

[JBeaucaire]

Slight edit above to ensure the data always goes into a single column.