Refresh Pivottable last 4 weeks data from today
 

Hi,

Any xperts there can help me with a VBA code:

I have a OLAP sales cube there I want to run a Macro there it will refresh
OLAP cube with last 4 weeks sales.

I don`t understand how to set date range so i will refresh last 4 weeks..

Thanks in advance...

Best regards
Hugo