How To Select "Save As" From IE Download Dialogue Box Using VBA
Results 1 to 5 of 5

Thread: How To Select "Save As" From IE Download Dialogue Box Using VBA

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How To Select "Save As" From IE Download Dialogue Box Using VBA

    I realize that there are more efficient ways to obtain files from websites using VBA but I really want to figure out how to control the Dialogue Box that pops up when a user is trying to download a file.

    To be more specific, I want to select "Save As" and set the file destination.





    The download URL is unavailable to me - I'm still working on learning other methods of obtaining the URL. I'm hoping that for the time being someone can assist me in figuring out how to accomplish this task.

    I only started learning excel and VBA about a year ago (excel a year ago, VBA six months). So I'm quite new. I apologize in advanced if I am being difficult as I may not understand all the information you're relaying to me. I've mostly been teaching myself through trial and error (looking at code works, erasing line by line to see what happens, making small changes, etc.) I've only recently started to read up on VBA by looking at tutorial videos and reading through forum posts.

  2. #2
    Board Regular
    Join Date
    Oct 2007
    Posts
    5,807
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How To Select "Save As" From IE Download Dialogue Box Using VBA

    Welcome to MrExcel forums.

    For your task, see Using UIAutomationClient to automate the Save As file download in IE11

  3. #3
    New Member
    Join Date
    Apr 2019
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How To Select "Save As" From IE Download Dialogue Box Using VBA

    Thank you!

    Just got back from the Easter holidays, going to look into using the code now. Was trying to replicate the scenario I was having at my office on my home computer and finally figured out a way to accomplish the task. I'll let you know how it goes.

  4. #4
    Board Regular
    Join Date
    Oct 2007
    Posts
    5,807
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How To Select "Save As" From IE Download Dialogue Box Using VBA

    I tried to reply to your PM, but it bounced. You need to do something with your account to allow it to receive Inbox messages.

  5. #5
    New Member
    Join Date
    Apr 2019
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How To Select "Save As" From IE Download Dialogue Box Using VBA

    Thanks John,

    I noticed. I’ve been trying to figure out why my inbox is full when it is empty. Initially thought I might have forgotten to register but this was not the case.

    EDIT:

    I should be able to receive PMs now. I was restricted to sending / receiving one message at a time. According to another user new users are limited to the number of messages they can send/receive. So sorry for the inconvenience! I wasn’t aware of the restrictions.
    Last edited by JoshuaKC29; Apr 24th, 2019 at 12:15 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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