View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
donbowyer donbowyer is offline
external usenet poster
 
Posts: 107
Default 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.