View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hugo Rask-Jensen
 
Posts: n/a
Default 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