Downloading Data from Web with User Name and PassWd

[risk99]

Hi, is it possible to tell VBA to download data from a Site which requires user name and password? Thanks!

 

[risk99]

Anyone? Thanks!!

 

[ETID]

'Maybe you can modify this....(it works with an FTP server)


Sub Return_ftp_folders_and_files()

With ActiveSheet.QueryTables.Add(Connection:="URL;ftp://UserIDassword@ftp_server_name/path", Destination:=Range("a1")) 'write web-page to sheet
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With

End Sub

 

[ETID]

...here's another site that might help

http://groups.google.com/groups?hl=...%24dfd40af0%2439ef2ecf%40TKMSFTNGXA08&rnum=11

 

[SharonMee]

Hi ETID:

How would I know it's an FTP server?

How do I get the FTP Server name?

I guess the path is just the url e.g.

http://www.hotmail.com

right?

Thanks a lot.

 

[ETID]

I could be wrong...but I don't believe that mail servers play by the same rules. :-(

 

[ETID]

Oh ...and an ftp server has "ftp://" in the beginning of the url instead of "http://

 

[ETID]

Here's another thread that talks about this stuff...

thread707-711188