CODEWITHSUNDEEP
excelinternet-explorervba
elyoe011
elyoe011

Reputation: 85

How to CLICK on IE download dialog box i.e.(Open, Save, Save As...)

I want to be able to click on Open, Save, Save As... In Internet Explorer via VBA.

I attached a pic of the download dialog box...

download dialog box

Upvotes: 2

Views: 15037

Answers (2)

Tony L.
Tony L.

Reputation: 19486

I used the shortcut keys for these. Here they are for IE11.

Note: the code will not run as you expect if IE is not the active window on your machine so it won't work while in debug mode. All this is doing is the equivalent to pressing keys on the keyboard.

Open

  • Shortcut key:Alt+O
  • VBA: Application.SendKeys "%{O}"

Save

  • Shortcut key:Alt+S
  • VBA: Application.SendKeys "%{S}"

Upvotes: 1

elyoe011
elyoe011

Reputation: 85

I found an easy way by using the TAB key... I modified the code a little:

Application.SendKeys "{TAB 1}", True 'This will select the (OPEN) Tab
Application.SendKeys ("~")

Source: https://www.autoitscript.com/forum/topic/154472-ie-download-saveopen-dialog-how-to-access/

Upvotes: 0

Related Questions