VBA to click the "Open" or "Save" button in Internet Explorer Dialogue Box

Hi Everyone,

Please help me on this problem I had. This issue made me stuck in proceeding and I'm afraid that it will lead me to nothing. I've already created a script that will automatically navigate the page and extracting the file. But the dialogue box in IE made me stuck. Please help me to have code that can click the "Open" or "Save" button in the dialogue box. This dialogue box is not part of the webpage anymore. Below is my current code. Please help. I need your brilliant mind.


Thank you

Please Login or Register  to view this content.

That dialog box is not part of the web page. So you will have to resort to SENDKEYS. It's ugly, but it will probably work.