Hi all ,
I am writing this blog to focus on different version and availability of network and socket api .i will also going to focus on the differnt version of visual studio to support these api.
Visual Studio versions
V-6 Relese date(1998)
V-7 Release Date(2002) This version include support of .net
V-8 Release year(2005)
V-9 Release Year(2008)
V-10 Release Year(2008)
------------------------------------------------------------------------------------------------
Network Api
Wininet (V8)- This is Mainly used for client programming .Written in C /C++.It is older Then WinHttp.
The header Files are wininet.h,Winineti.h
WinHttp(5.1)-This is used for Server/client Programming in c/c++/COM. The header file is winhttp.h
Winsock2- This is used for advanced internet and network application .It is used with c/c++ .In .net framework it is replaced by system.net.socket. The header file include winsock.h, winsock2.h.
winsock control/component-It is used with vs 6(1998). It is not present in visual studio 2010
----------------------------------------------------------------------------------
To retrive the content of the web page(i.e. HTML ) in VBA
----------------------------------------------------------------------------------
The use of MSXML 3.0 version is very much preferred because of its simplicity.
its is used as a com object .which resides in MSXML3.dll.
To connect with the internet we create an object objHttp. The object value will be set to the" MSXML server 3.0 ".By doing this objHttp will inherit all the propery of this class
Dim objHttp As Object
Set objHttp = CreateObject("MSXML2.ServerXMLHTTP.6.0")
Call objHttp.Open("GET", URL, False)
Call objHttp.Send
getResponseText = objHttp.ResponseText
I am writing this blog to focus on different version and availability of network and socket api .i will also going to focus on the differnt version of visual studio to support these api.
Visual Studio versions
V-6 Relese date(1998)
V-7 Release Date(2002) This version include support of .net
V-8 Release year(2005)
V-9 Release Year(2008)
V-10 Release Year(2008)
------------------------------------------------------------------------------------------------
Network Api
Wininet (V8)- This is Mainly used for client programming .Written in C /C++.It is older Then WinHttp.
The header Files are wininet.h,Winineti.h
WinHttp(5.1)-This is used for Server/client Programming in c/c++/COM. The header file is winhttp.h
Winsock2- This is used for advanced internet and network application .It is used with c/c++ .In .net framework it is replaced by system.net.socket. The header file include winsock.h, winsock2.h.
winsock control/component-It is used with vs 6(1998). It is not present in visual studio 2010
----------------------------------------------------------------------------------
To retrive the content of the web page(i.e. HTML ) in VBA
----------------------------------------------------------------------------------
The use of MSXML 3.0 version is very much preferred because of its simplicity.
its is used as a com object .which resides in MSXML3.dll.
To connect with the internet we create an object objHttp. The object value will be set to the" MSXML server 3.0 ".By doing this objHttp will inherit all the propery of this class
Dim objHttp As Object
Set objHttp = CreateObject("MSXML2.ServerXMLHTTP.6.0")
Call objHttp.Open("GET", URL, False)
Call objHttp.Send
getResponseText = objHttp.ResponseText