PDA

View Full Version : Download pdf doc from embed web browser



danielgp
04-28-2014, 06:53 PM
Hello Excel mania and experts,

Is there any way that I can download or save a pdf doc openned in an embed web browser?
I have managed to auto-click a button to open the pdf doc in the web browser but I don't know what to do next.



Sub DownloadPDF()
Dim objWeb As WebBrowser

Set objWeb = Sheet1.WebBrowser1
With objWeb
.Document.getElementById("btn-full-txt").Click

Do Until .ReadyState = 4
DoEvents
Loop

'What to do next to download/save the opened pdf doc???
'
'

End With

Set objWeb = Nothing
End Sub


Please help, I appreciate any help or info you can give.

Regards,
Daniel