Thanks for the Welcome!

the data is seperated into columns and seperated by spaces.

Does this mean i can use the 'split' function to distinguish between seperate pieces of data? and do i have to specify a 'space' as the character that 'splits' the data?

Also the data is in several columns and i only need 2 of them to be moved to Excel and i need to be able to call up sections of data, e.g of data im manipulating:

TIME COMP TYPE COMP ID VOLT(kV) CURNT(kA) PWR(MW) MVAR MVA
08:00:00 Elec Sect -ES60 0.7789 0.0000 0.000000 0.000000 0.000000
08:00:01 Elec Sect +ES61 0.7810 0.0000 0.000000 0.000000 0.000000
08:00:02 Elec Sect -ES13 0.7768 0.0000 0.000000 0.000000 0.000000
08:00:02 Elec Sect -ES52 0.7760 0.0000 0.000000 0.000000 0.000000
08:00:02 Elec Sect -ES56 0.7785 0.0694 0.054019 0.000000 0.054019

so ideally i want to move all the data from the Time and Volt columns to Excel at the time 08:00:02.

Also to actually get the data from the .txt file to i have to make a new connection eg:

Add(Connection:="TEXT;C:\My Documents\19980331.txt", _
Destination:=shFirstQtr.Cells(1, 1))

sorry, there's alot there, any help is much appreciated!