wilmott.com

I am looking for information on the following topics in Excel VBA. How to connect to LDAP and database servers (ADO and ADSI libraries)How to connect to WebServices (SOAP Libraries)How to connect to Servlets ? (XML over HTTP)MSXML ParsingAny web resources, examples etc, would be very helpful.

ADO database access is well covered in the VBA help. The best online resource for all of these topics, in relation to VB is the MSDN Library. You can also download the MSXML and MDAC SDKs here. These provide compiled help files and samples in VB.

Great!! thanks.Any help on servlets?

The VB in Excel is now quite old.If you're going donw this path, you'd be better off using VB.NET.Also the support for XML etc in "raw" Excel is not brilliant, but if you've installed Visual Sutdio .NET, you can usesome of its libaries.

But i think it will turnout to be costly to buy Visual Studio for home purpose. I actually don't want to implement but am looking for some examples.For example, Microsoft provides one example of using webservices for stock prices. Likewise there are many other webservices available. any link to such webservices would be helpful.

> But i think it will turnout to be costly to buy Visual Studio for home purpose. I actually don't want to implement but am looking for some examples.You still need to write the code that comsumes the webservice and VS can be a big help. Check out the expess versions of VS.The betas are free and the shipping versions are going to inexpensive.

for XML parsing and requests over HTTP enable the reference to MS XML,v 2/3/4/5 which includes the VB DOM, details at http://msdn.microsoft.com/library/defau ... hdi_vb.asp