Comments by iris.frigole (Top 12 by date)

To read content of a cell:
Dim xlWorkSheet As Excel.Worksheet
Dim xlRange As Excel.Range
Dim sCellText as String
....
xlRange = xlWorkSheet.Range("D1,D1")
sCellText = xlRange.Text.ToString
...
if you want to loop D to g, use a function that returns letter from index:

Public Function getExcelColumnLetter(ByVal iColNumber As Integer) As String
Dim sResult As String

'End If
If iColNumber > 26 Then

' 1st character: Subtract 1 to map the characters to 0-25,
' but you don't have to remap back to 1-26
' after the 'Int' operation since columns
' 1-26 have no prefix letter

' 2nd character: Subtract 1 to map the characters to 0-25,
' but then must remap back to 1-26 after
' the 'Mod' operation by adding 1 back in
' (included in the '65')


sResult = Chr(CInt(Math.Round(((iColNumber - 1) / 26), 0) + 64)).ToString & _
Chr(((iColNumber - 1) Mod 26) + 65).ToString

Else
' Columns A-Z
sResult = Chr(iColNumber + 64).ToString
End If
getExcelColumnLetter = sResult
End Function

Ok, i have never done this, but probably the class you want is System.Net.FtpWebRequest.
Check method WebRequestMethods.Ftp.ListDirectory. HTH