Does anyone have any suggestions on how to code macro to disconnect internet
connect for macro?
I would like to add a code at the end of macro to disconnect internet
connection, does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric

I manually connect the internet connection for Excel's macro to run a list of
files, in order to retrieve data from external links. Once all files are
completed updated, I would like to add coding at the end of process to
disconnect the internet connection.
Does anyone have any suggestions on how to do it?

Furthermore, I post this question under following link, but when I do
searching on google, and find my question is replied from other forum, where
I don't see any reply from following links. So I don't know someone reply to
my questions outside this forum, does anyone have why my question is listed
on third party forum outside microsoft?

http://www.microsoft.com/office/comm...&lang=en&cr=US

Thanks in advance for any suggestions
Eric



"Eric" wrote:

> Does anyone have any suggestions on how to code macro to disconnect internet
> connect for macro?
> I would like to add a code at the end of macro to disconnect internet
> connection, does anyone have any suggestions on how to do it in Excel?
> Thanks in advance for any suggestions
> Eric

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
>
> .
>

Do you have any suggestions on how to disconnect the internet connection
after all external link are updated? I am using boardband modem for
connection.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric

"joel" wrote:

>
> You can't break the links. Either you have to turn the Recalculation
> mode off, or repalce the links with values using PasteSpecial and using
> as the paste properies values Only which will remove the links forever.
>
>
> --
> 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
>
> .
>

When I am online, there is a monitor's icon to show online status, when I
disconnect the internet connection, I just right click this icon and select
disconnect, and this is what I want to do to disconnect the boardband
connection.
Do you know any trick to do it? which is not involve any IP or modem
hardware setting at all?
Do you have any suggestions?
Thanks in advance for any suggestions
Eric

"joel" wrote:

>
> Are you trying to shutdown the entire modem or just the IP address
> where the files are located? I think you would have to shutdown the
> modem. You would need to find the name of the process in the Task
> Manager and kill the process. It is possible to go through the task
> list of active processes and kill the particular process associated with
> the modem. You would need to do this by using the
> windows\system32\win32.dll
>
>
> The website below has a similar request using a phone dialer. the code
> accesses the Win32.dll using VBA library functions.
>
> 'How to terminate process with VBA? - Microsoft Access / VBA answers'
> (http://tinyurl.com/y96yzfp)
>
>
> --
> 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
>
> .
>

There are several screen position based macros out there that can be
called from VBA. This might be one of the times to look into those.
Essentially vba can bring focus to taht program and sendkeys,
launching the screen position based recorder macro. J