Click Save button in the pop up dialog box in IE using vba.

[prabhu_venkat]

Hi,

I have tried various codes by using send keys to click save (SendKeys "%s") or save as or open button in the dialog box but it's not working in IE. I am facing this issue when I am trying to pull some report in IE from the website and it shows up the dialog box below but send key nor any other codes seems to be working. I just want to save downloaded file in the desktop using vba.

I am using IE9.

Kindly advice.

 

[Kyle123]

You can't reliably do this. You're going to have to figure out another way of doing this, usually something like getting the target of the link and opening it directly in the application that opens it.