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

[JoshuaKC29]

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.

 

[John_w]

Welcome to MrExcel forums.

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

 

[JoshuaKC29]

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.

 

[John_w]

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.

 

[JoshuaKC29]

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.