Re: can't create a collection of names - Classi (General questions)
Hi Havey,
I believe that if you do split expression using vbcrlf as a delimiter it should work perfectly.
Please try something like this:
------------------------------------------
sftp.ListNames ( Path_to_your_remote_dir )
x = sftp.ListItem
mayrray = Split(x, vbCrLf)
For i = 0 To UBound(myarray)
Debug.Print myarray(i)
Next
------------------------------------------
Hope I helped.
Regards,
Damba