August 31, 2015
ADO stands for ActiveX Data Objects, which is used to communicate with different sorts of databases.
Assume you have a Drop Down List on Cell A2 on worksheet named Sheet1. As soon as you change the Dro...
July 1, 2015
I recently had a need to communicate with a Webservice that required a parameter to be invoked.
June 24, 2015
Use the below code to Call an SQL Stored Procedure With 2 Parameters.
All you have to change is the...