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?
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
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 . |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro to disconnect internet connection?
it is diffficult wihtout have your PC configuration to be able to figure out how to shutdown the software. sometimes there are shortcut keys to perform these tasks and then you would use the Sendkey method output the shortcut keys. check the Modem documentation to see if there is a way to use shortcut keys. -- 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 |
#11
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 |