View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to code macro to disconnect internet connection?

I am using Excel to import external links into worksheets, not using IE.
Do you have any suggestions on how to disconnect internet connection using
macro?
Thanks in advance for any suggestions
Eric

"joel" wrote:


It sound like all you are doing is to open a webbrowser. So you just
need to close the webbrowser and set the object to nothing

IE.Quit
set IE = nothing



But this may not log you off the application. if you are using another
protocol than a webbrowser then you may need to do something else


To answer you question about your posting appearing in other location.
the websites uses VBN protocol. What the websites does is to register a
port number at an IP address. What registering does is to send send
data from one IP address to another IP address automatically. Doing
this will allow multiple websites to send and receive the postings and
share the postings.

There is also a google formum that gets the same messages and two
microsoft formums. There are slight differences between the various
websites. Google does post all messages from the other sites.
Microsoft has one site which gives email notifications and a 2nd one
that sometimes gives email notifications (this features breaks often at
microsoft). TheCodeCage and very good support people and the site
rarely has problems but either you pay money or don't pay and get
advertisements.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=189248

http://www.thecodecage.com/forumz/chat.php

.