How to code macro to disconnect internet connection?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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/com...rosoft.public.excel.programming&lang=en&cr=US

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
 
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
 
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
 
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
 
Back
Top