Use this line to close your webpage or internet explorer that you opened through previous code
Type this...
ie.Quit
This for open
Sub VisitWebsite()
Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://excelmacrosnvba.blogspot.com"
ie.Visible = True
While ie.busy
DoEvents
Wend
End Sub
** Change the url..
Type this...
ie.Quit
This for open
Sub VisitWebsite()
Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://excelmacrosnvba.blogspot.com"
ie.Visible = True
While ie.busy
DoEvents
Wend
End Sub
** Change the url..
Hi,
ReplyDeleteI am using vba macros for converting few docs to pdf, while doing this process, my present internet explorer page is getting close. I want to retain the existing web page without changing(need to keep the existing content in explorer)
Please suggest any updation on this