can I pull data from FTP server?

[demodren]

Hi all, would anyone be able to perhaps point me in the right direction.
I run current macros which pull specific data from a shared drive. I want to see if I can now pull the same data from ftp server(I have address,user id,pw) Is it possible to incorporate this in the code I currently have? Any other options?

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

 

[demodren]

thanks Xenou.. I am little lost within those threads..

So just to understand it.. the way to have VBA download the file is a 2 step process:

1) write test.BAT file..for example, I need to download 3 files so I wrote:

ftp
Open ftp.myfiles.net
User ID PW
cd files
get file 1
get file 2
get file 3
bye

2) and then call it with RetVal = Shell("H:\test.BAT", 1)

however, it just runs the command but nothing happens.. Am I missing something here?