Skip to main content

How to Check Internet Connectivity using VBA

The following code snippet uses API functions to check Internet connectivity and also the type of connection
:
Public Declare Function InternetGetConnectedState _
Lib "wininet.dll" (lpdwFlags As Long, _
ByVal dwReserved As Long) As Boolean

Private Declare Function InternetGetConnectedStateEx Lib "wininet.dll" Alias "InternetGetConnectedStateExA" ( _
ByRef lpdwFlags As Long, _
ByVal lpszConnectionName As String, _
ByVal dwNameLen As Long, _
ByVal dwReserved As Long) As Long


'Local system uses a modem to connect to the Internet.
Private Const INTERNET_CONNECTION_MODEM As Long = &H1

'Local system uses a LAN to connect to the Internet.
Private Const INTERNET_CONNECTION_LAN As Long = &H2

'Local system uses a proxy server to connect to the Internet.
Private Const INTERNET_CONNECTION_PROXY As Long = &H4

The following API functions are used

Function IsConnected() As Boolean

Dim Stat As Long

IsConnected = (InternetGetConnectedState(Stat, 0&) <> 0)

If IsConnected And INTERNET_CONNECTION_LAN Then
MsgBox "Lan Connection"
ElseIf IsConnected And INTERNET_CONNECTION_MODEM Then
MsgBox "Modem Connection"
ElseIf IsConnected And INTERNET_CONNECTION_PROXY Then
MsgBox "Proxy"
End If
End Function

If you want to know just if it is connected or not you can use the following:

CBool(InternetGetConnectedStateEx(0, vbNullString, 512, 0&))

Facebook

Facebook Recommendations

Followers


Web Designing In Karachi



Haroof.com


Politics blogs

My Zimbio

Email Subscribe

Enter your email address:

Watch online Live TV

Popular posts from this blog

Awaz Public Ki {Elections in Pakistan}

Q: As all the major parties are taking part in the elections, what future scenario do you foresee? Explain: The general elections are going to be held on January 8, 2008. All major political parties except two or three are participating in the elections. Among the major parties, contesting the elections, are Pakistan Muslim League (Q), Pakistan Muslim League (N), Pakistan People’s Party, Jamiat Ulma-e-Islam (F), Muttehadda Qaumi Movement, Pakistan Muslim League (Functional). As all the major parties are taking part in the elections, what future scenario do you foresee? Awaz Public Ki the elections will lead to a confused scenario if the establishment tried to manipulate the polls as it did in the past elections.they must avoid to engineer the elections, which will prove disasterous for the country. tanveer hussaini [Karachi]Posted on 26, Dec 2007 --> As far as future of polls.. the political system has been set on flames unfortunately.. I would like to say that for any successful n...

Microsoft SQL Server is the best among Microsoft’s Products

Microsoft has come up with Microsoft SQL server to cater to the needs of the computer operators, who want to provide advanced facilities on the other computers among networking process. The Microsoft SQL Server 2005 Express Edition is a newly developed product that is easy-to-use, lightweight, and enables the person to work more efficiently than before. The new SQL Server Express Edition with advanced facilities is perfect for use as a backend to a small, multi-user application that requires more superior features like Web reporting or full-text search. This Microsoft sql server standard express edition includes influential features as in SQL Server Management Studio Express that is capable of managing a database very easily. Along with this, it also creates and deploys database code such as stored procedures, user-defined types, functions, and user-defined aggregates from directly within the Visual Studio development environment. All these features tend to help you in enjoying your ...

Matric General Group Result SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X - 2010 (www.apnieyesp.com )

PASSED THE SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X) ANNUAL EXAMINATION, 2010. ERRORS AND OMISSIONS EXCEPTED, CANDIDATES BEARING THE FOLLOWING ROLL NUMBERS ARE DECLARED TO HAVE PASSED THE SECONDARY SCHOOL CERTIFICATE (S. S. C.) PART - II CLASS - X) ANNUAL EXAMINATION, 2010. ------------------------------------------------- GENERAL GROUP (REG&PVT) --- GRADE..'A-ONE' ---- ----------------------- ( CANDIDATES SECURING TOTAL MARKS 680 AND ABOVE) MARKS SECURED BY THE CANDIDATES OUT OF TOTAL MARKS OF 850 ARE MENTIONED AGAINST EACH ROLL NUMBER IN BRACKET --------------------------------------------------- 601086 (689) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) 601327 (681) 363 (684) 364 (719) 407 (685) 664 (682) 788 (687) 601836 (692) 882 (683) XXX (XXX) XXX (XXX) XXX (XXX) XXX (XXX) 602315 (723) 316 (715) 320 (712) 321 (739) 325 (686) 326 (702) 602327 (683) 329 (70...

Labels

Show more