Filename User
Field3
winamp3_0-full.exe Z:\Data\Users\ashcrofn\data\
3510536
moons.mp3 Z:\Data\Users\ashcrofn\My music\ 3571965
In Africa.mp3 Z:\Data\Users\ashcrofn\My music\ 3919289
Aerosmith Z:\Data\Users\ashcrofn\My music\ 4757504

Hi Dave,

I like the method that you utilise for extracting the name out of the
user column as it should work.

Included in the sample source that you gave me, bearing in mind the
sample data above, how do I:-

loop for all rows in the dataset ?
Take the value from the array and write it into another column on the
same row, for all rows ie as I loop ?

Many thanks.


--
Silvertip
------------------------------------------------------------------------
Silvertip's Profile: http://www.excelforum.com/member.php...o&userid=28456
View this thread: http://www.excelforum.com/showthread...hreadid=480586