Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    79

    Unanswered: Download multiple files from different URLs / links

    Hi All,

    I have below macro which is used to download single file from internet. It works fine but I want to download multiple files from different links. I have created a userform with a list box which shows all URLs / links and has download button. I need the help to use the below macro in my attached file which will allow me to download files.

    Code:
    Sub downloadfiles()
    'Need to reference to Microsoft Internet Controls
        Dim URL As String
        'URL = Worksheets("References & Resources").Range("URLMSL")
        URL = "http://www.xyz.com/abc.zip" 'for TEST
        Dim IE As Object
        Set IE = CreateObject("internetexplorer.application")
        IE.Visible = True
        IE.Navigate URL
        Do While IE.ReadyState <> 4
            DoEvents
        Loop
        SendKeys "%S"
        IE.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DODEFAULT    'SaveAs
    End Sub
    There is one more issue with the above mentioned macro that it asks for a confirmation to user before downloading the file .i.e. do he want to open or save or cancel the download. Which I want to suppress.

    Thanks a lot for your help in advance.
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2010
    Location
    India
    Posts
    2

    Wink

    What's the intended use of this Excel file ?

    Would you please be more specific ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •