| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting a network connection
I need to be able to detect whether or not a computer is
connected to a network when the excel application I am working on is opened. The application is going to run on a tablet PC that will not always be connected to a network. I want to automatically refresh imported information when the application opens but only if a network connection is available. Has anyone ever done this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting a network connection
Eric
Will you know the path to the network? If so, you can attempt to use the ChDir command to change to that path and trap the error if the path doesn't exist. On Error Resume Next ChDir "S:\" If Err.Number = 76 Then 'Not connected Else 'Connected End If -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Eric" wrote in message ... I need to be able to detect whether or not a computer is connected to a network when the excel application I am working on is opened. The application is going to run on a tablet PC that will not always be connected to a network. I want to automatically refresh imported information when the application opens but only if a network connection is available. Has anyone ever done this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Network connection for query | Excel Discussion (Misc queries) | |||
| always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
| missing network connection | Excel Discussion (Misc queries) | |||
| Checking if you have a network connection | Excel Discussion (Misc queries) | |||
| Connection error to network drive | Excel Discussion (Misc queries) | |||
Hybrid Mode
