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
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