Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
How are you making the internet connection? do yo mean to close a web browser, shutdown a dialup connection, kill an ethernet connection. Yo need to be a little bit more specific. I program in C# and open and close connections all the time. I need to know a little bit about the connection type to help with some code. I think you want to close an Port to a particular IP address. Yo either want to look at the ARP table or use the Loopback address 127.0.0.1 to find all the active connections and then close the connection wiht a particular IP address and Port Number. This task may be easier if you download Visual studio 2008 which is available from microsoft for free and use either VB Net, C++, or C# which arethe 3 languages available in Studio. visual studio 2008 use Net 3.4 library and there is plenty of documents in the microsoft website under Net 3.5 showing examples of how to achieve this request. I have code in C# which can be modified to to this. I got all my code from searching the microsoft databases. There isn't a lot of material on doing this from VBA although it can be done. If yo have an excel application I recommend open the excel application from Visual Studio. The C# tutorial in visual Studio had an example of how to open a workbook which I did in about 15 minutes. -- 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browse 4 a file & disconnect a connection to external source | Excel Programming | |||
Connect & disconnect dial-up connection inside Excel Vba | Excel Programming | |||
How to disconnect the line for Internet? | Excel Discussion (Misc queries) | |||
How to disconnect the line for Internet? | Excel Programming | |||
internet connection via excel macro | Excel Programming |