Excel VBA - Advance Topics

Manishs · August 26th, 2004, 4:51 am

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.

afoster · August 26th, 2004, 6:26 am

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.

Manishs · August 26th, 2004, 7:13 am

Great!! thanks.Any help on servlets?

DominicConnor · August 26th, 2004, 8:16 am

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.

Manishs · August 26th, 2004, 8:47 am

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.

MarcusCuda · August 26th, 2004, 10:56 am

> 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.

patch22 · August 26th, 2004, 12:55 pm

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