Currently I am reading a list of id's in a text file, but I now need it to read a list of ids from a csv file. The csv file will look something like this:
I will need to read the entire file and just get the ID info. My currert code when the list just contained the ID looks like this:
Set objFSO = CreateObject("Scripting.FileSystemObject")
'open the user file and set the names into the arrLdapIds array.
Set objTextFile = objFSO.OpenTextFile("c:\temp\practicevb\vb2005\pilotids.txt", 1)
strText = (objTextFile.ReadAll)
arrLdapIds = Split(strText, vbCrLf)
For Each strUser in arrLdapIds