I currently have the below macro which opens up a pdf in explorer is there a way to now download the pdf to a file path? Thank you!
Sub Testa()
Dim x As String
x = Sheet1.Range("c2").Value
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate (x) 'navigate
IE.Visible = True ' make the site visible
Do While IE.ReadyState <> 4 'wait untill website is ready
Loop
End Sub
Sub Testa()
Dim x As String
x = Sheet1.Range("c2").Value
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate (x) 'navigate
IE.Visible = True ' make the site visible
Do While IE.ReadyState <> 4 'wait untill website is ready
Loop
End Sub