The World’s Largest Online Community for Developers

'; VBA Excel macro to set value from pivot table - LavOzs.Com

I have pivot table on excel, where data source come from SSAS SQL,

i want to set automatic the date as date using macro VBA, so when i hit a button the asofdate will change D-1 and retrive the data

enter image description here

i cant find the solution to use macro to set this date pivot

Calculated Field in Pivot Table using Conditional Formula VBA
How to avoid using Select in Excel VBA
vba excel create pivot table by cache or new
Refreshing a pivot table created in Excel Vba (ADODB Connection)
Refreshing a Pivot table with VBA
Excel VBA Macro from Pivot table
Run a macro when a pivot table changes
VBScript Calling VBA Macro to build Pivot Table