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