Close Internet connection
Many thanks for the reply. I appreciate my code doesn't actually open the
web/IE. It does however achieve what I want to do, but unfortunately whilst
the first part of your suggestion does close the Workbook OK the second part
(Set webBk = Nothing) doesn't seem to close the connection??
Perhaps I'm missing something here.
--
donwb
"dysgraphia" wrote:
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.
|