Sometime happen that we want to filter in automatic way a pivot table without using filter o slicer. In this situation we can use VBA to do this kind of operation.
Excel VBA
VBA: connect you Excel to Sql Server
Sometimes happen that Customer or ourself wants to do something with sql without using sql. it’s a strange idea but happens!
For Example if we want to launch a Reporting service Manual Scheduled, or a stored procedure but we don’t want to access on virtual machine, open sql server and launch it.
We can do it with excel and vba!