Hi all, I was wondering if someone could point me in the right direction.

Currently I have a macro sep up where I pull specific data from a shared drive. I will be storing same data on ftp and I was wondering what are my options to pull the same data? For example, currently I use below code to pull the data.. Am I able to modify that to pull same data now stored on ftp server?

Any help would be greatly appreciated

Thanks so much


Dim strConn As String
    Dim objConn As Object
    Dim rst As Object
    Set objConn = CreateObject("ADODB.Connection")
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=C:\data.xls;" & _   
              "Extended Properties=""Excel 8.0;HDR=YES"""
    objConn.Open strConn
    Set rst = CreateObject("ADODB.Recordset")
    rst.Open "SELECT * FROM [data$] WHERE [level_id] = '2';", objConn
    
    Sheets("Main").Select
    Rows("2:2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.ClearContents