Firstly Ken is there anyway you can mark this thread active rather than solved because it seems that i have perpetuated the lines of questioning?
I have never explored ADO or CDO or any other "DO"! and i thought SQL was SQL Server which was something different. Right now i (or should i say we!) check for the existence of the folder, the existence of the file, the authr.txt and with the collection code collect all the machine names and usernames.........Question, is it possible that when collecting 'names' we check for entry already made if it exists then dont collect the info?, it's probably me being highly lazy and not wanting to filter all the captures manually.
For my checking of a list i would probably have done
For Each Mycell in rng
If Mycell.value = CN AND Mycell.OffSet(0,1)= UN Then
Exit Sub
Else
Call CollectNames
End If
Next
, I have also moved authr.txt to my own folder which is password protected (on the same drive) so i have trouble opening it from Excel because of this, it would have been nice to have it in a location they cant enter but i have moved it again to our Bin folder (for old files that we store but dont use!).
What i thought would be a small coding problem and insignificant is turning in to a monster but im enjoying learnin!, its strange the more i learn the more code i try to write!
Regards,
Simon
P.S Congrats on your new status.....one of the elite!