none
VBA IE download prompt RRS feed

  • Question

  • Hi,  i am working on a VBA script that will download, from a specific website, a .xlsx file, then using excel to automatically import the data to a new sheet and ran a report.

    all good so far until i click on the download button and the  white and orange download prompt appear.

    "Do you want to open or save...... from.....?   Open   Save  Cancel."

    i cant seem to figure this one out.

    can this be disabled or there is a VBA workaround that i could use?

    or code to interact with this window?

    i am running on 64 bit platform. Office 2016 32 bit and using IE11 as browser for the script.

    Thanks


    Tuesday, January 28, 2020 3:47 PM

All replies

  • To:  Harcor
    re: suppress message

    You don't say, but the message could be from the website, from Windows or from Excel.
    If it is from Excel, you can suppress messages with...
      Application.DisplayAlerts = False
    It is best to set it to True, before exiting the code.
    '--



    The new (free) Excel workbook "Professional_Compare" is now available at MediaFire.
    (compares every cell or every row in two worksheets - choice of type of comparison)
    Download from (no ads):
    http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

    Saturday, February 1, 2020 4:31 AM
  • I use either Wget or cURL.  They are command line programs (free).  You can call them from VBA.  You'll need to know the link.
    Saturday, February 1, 2020 4:36 PM