ADO stands for ActiveX Data Objects, which is used to communicate with different sorts of databases. Here in the below examples, we are running a basic SQL Select statement and returning the data back to a Worksheet We will use the Early Binding Technique in the first example. If you are keen on knowing the difference between Early Binding & Late Binding Technique, click HERE! In order for the Early Binding Technique to work, you will first have to set a reference to the Micr

Assume you have a Drop Down List on Cell A2 on worksheet named Sheet1. As soon as you change the Drop Down Value, you want all the Pivot Tables on the Workbook, using that value in the Report Filter to update automatically. Put this code on a regular Code Module - ---------------------------------------------------------------------------- Sub UpdatePivot() Dim I, WS As Worksheet, PT As PivotTable For Each WS In ThisWorkbook.Worksheets For Each PT In WS.

I recently had a need to communicate with a Webservice that required a parameter to be invoked. After reading some information online, I came to know that the Microsoft SOAP Toolkit was not available in Post 2007 Version. Mine was 2013 when I wrote this post. So I started seeking help online, and a gentleman named Kyle helped me out with this code. I noticed a lot of people were struggling with the same problem, and hence I decided to put up this blog post. Before we look at

Use the below code to Call an SQL Stored Procedure With 2 Parameters. All you have to change is the Parameter names & values, the ConnectionString, the StoredProcName & you should be good to go. Also set the reference to the latest available Microsoft ActiveX Data Objects Library by going to Tools > References --------------------------------------------------- Sub CallStoredProcedure() Dim Conn As ADODB.Connection, RecordSet As ADODB.RecordSet Dim Command As ADODB.Comm

If you have a workbook with many hidden worksheets, you cannot unhide all of them at once, UNLESS, you use the below VBA Code.. ------------------------------------------------------------------ Option Explicit Sub UnHideAllSheets() 'Unhides All Worksheets Dim Sheet As Worksheet Application.ScreenUpdating = False For Each Sheet In ActiveWorkbook.Worksheets Sheet.Visible = xlSheetVisible Next Sheet Application.ScreenUpdating = True En

Slicers were a great introduction in the Excel 2010 Version. They work really really well with Pivot Tables to help you slice and dice your data very quickly. However, if you deal with quite a few slicers on a report, you surely must have observed that currently there is no way you can reset all slicers at once. If you have 10 slicers on a report, you have to clear all 10 of those one after the other, which is very annoying. Hence, I had to ask VBA for some help! Put the belo

The following code will generate a Transparent Rectangle with Red Border on the Active Cell, when executed. Put the below code on the Personal Macro Workbook to have it available on all Excel Workbooks on your computer. __________________________________________________________ Sub AddRectangle() 'Macro By Deep Dave on 21st Nov 2014 (www.NeedForExcel.com) 'Macro creates a Rectangle with a Red Border Application.ScreenUpdating = False 'Turns off screen updating D

To work with the Macro Recorder or VBA (Visual Basic For Applications) you need to enable the Developer Tab first. This is how you do it - For 2007 Version - Click on the Office button on the Left top corner Select Excel Options On the Popular Tab, check the box in front of “Show Developer tab in the ribbon” For 2010/2013 Version - Click on the File Tab Select Options Select Customize Ribbon Check the box in front of “Developer” Interested in learning how to use the Macro Rec