Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check online network availability
Hi Friends
I want to establish, if the user is on-line with the network fileserver. Scroll drives or using FileExist method (File Scripting object) wont do the trick, because the path will often, but not always, be available offline. I've got to know if they are connected - any idea's? Thanks/Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check online network availability
Try:
Private Declare Function IsNetworkAlive Lib "SENSAPI.DLL" (ByRef lpdwFlags As Long) As Long Sub xx() Select Case IsNetworkAlive(0) Case 0 MsgBox "not connected" Case 1 MsgBox "connected to LAN" Case 2 MsgBox "connected to WAN" Case Else MsgBox "connected to ?other network?" endselect End Sub You probably want to verify whether IsNetWorkAlive returns 0 or nonzero only. " wrote: Hi Friends I want to establish, if the user is on-line with the network fileserver. Scroll drives or using FileExist method (File Scripting object) wont do the trick, because the path will often, but not always, be available offline. I've got to know if they are connected - any idea's? Thanks/Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check online network availability
Very Cool. Thanks. I have no need for it right now, but it should come in
handy at some point in my life... "AA2e72E" wrote: Try: Private Declare Function IsNetworkAlive Lib "SENSAPI.DLL" (ByRef lpdwFlags As Long) As Long Sub xx() Select Case IsNetworkAlive(0) Case 0 MsgBox "not connected" Case 1 MsgBox "connected to LAN" Case 2 MsgBox "connected to WAN" Case Else MsgBox "connected to ?other network?" endselect End Sub You probably want to verify whether IsNetWorkAlive returns 0 or nonzero only. " wrote: Hi Friends I want to establish, if the user is on-line with the network fileserver. Scroll drives or using FileExist method (File Scripting object) wont do the trick, because the path will often, but not always, be available offline. I've got to know if they are connected - any idea's? Thanks/Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 slow to open - Network/ Online Related | Excel Discussion (Misc queries) | |||
Can the check register be linked to account online? | Excel Discussion (Misc queries) | |||
Check image availability on userform | Excel Programming | |||
Network detects if Windows Username is online | Excel Programming | |||
How to check for availability activeX control | Excel Programming |