Internet Explorer and VBA : Open, Save and Cancel Dialog Box

**codeslizer** · 10-23-2013, 10:26 AM

Hi there Guys,

Am stuck up with a situation where am having a small dialog box with no title and asking, "Do you want to open or save <filename> (<size>) from <url>". Attached is the screenshot of it. I found a link which initially sounded like it'll make it work.. but ended up returning 0.

My objective : Am trying to automate a process of downloading files from CITRIX environment. As of now, am able to get to the application and have been able to launch it through XL VBA but when launching, am being prompted with this dialog box where I just need to hit on Open button in the dialog box through VBA again to proceed further..

My version of IE is 10. Any ways to hit Open button through VBA on that dialog box? Any helps will be appreciated.

**LJMetzger** · 10-25-2013, 04:53 PM

I had a similar problems, that I worked around using 'SendKeys'. I imagine there's a better way, and maybe someone else has a better solution. The problem with 'SendKeys' is that there is no feedback to indicate a task has been completed, so that you have to allocate more 'Wait time' than the task WILL EVER take.

First determine what keystrokes you need to navigate through the web site. Then implement something like the following code excerpt:

Please Login or Register  to view this content.

**TASRE** · 11-08-2013, 04:33 PM

Having the same problem and looking for a non-sendkeys solution. It's disappointing that Microsoft does not make this readily available via VBA

**alansidman** · 11-08-2013, 04:49 PM

@TASRE

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

New threads not only open you up to all possible participants again, they typically get faster response, too.