Close Internet connection
webBk.Close savechanges = False
Set webBk = Nothing
Your Workbooks.Open doesn't open the web/IE as such just.
If otherwise you want to close IE you can use IE.Quit, IE.Close,
Set IE = Nothing
which assumes you had earlier Set IE = Application("Internet Explorer")
donbowyer wrote:
I have MS XL Home & MS Office circa 2003
In Excel I am using the following to open a specific web page via IE6 and it
works fine.
Dim webBk As Workbook
Set webBk = Workbooks.Open("http://www.somewebpage.com")
But what code can I then use to close the connection and IE6.
|