VBA - Saving an embedded PDF from IE

[Regular7]

Hi all,

I am trying to create a macro to open a site, then save the embedded pdf that is generated by the page. I understand how to open web pages etc. from an Excel Macro, but am stuck on finding a method to save an embedded pdf.

The embedded pdf has a button to 'save' and a button to 'open in new window'. The URL to the PDF is different each time.

Methods which won't work (I've alread tried):

• Finding the element id of the 'open in a new window' button and doing .click (getting Run-time error 91).
• CTRL+SHIFT+S won't work on IE to save it - can't use sendkeys to try and save this way.
• Can't use sendkeys to 'tab' to the 'open in new window' button as opening stuff with Javascript 'locks' the screen. Can only click the button manually, or click into the page manually which then allows me to tab between buttons.

The only method I can think of is to somehow open the DOM explorer, search the text for the PDF url, then open that in a new IE tab - but I'm not sure this is even possible to do and it seems like a ridiculous solution.

Unfortunately I can't share the site I am looking at as it is a work intranet site.

Is there any way to do this/a workaround, or am I wasting my time on this project?

Thanks!