steff.sullivan
New Member
- Joined
- Aug 18, 2008
- Messages
- 20
I have a raw dataset that updates each day to include the latest day. I have a number of different pivot tables and one is to show a view for the previous day. It is a 2003 workbook although I did create it in 2007.
Based on advice found on google and the Creating Reports for Each Region or Model in MrExcels VBA and Macros for excel 2007 I used this:
Unfortunately this does not apepar to be actually filtering but renaming the value already selected in the format 7/18/2011 where the date format for dates is 18/07/2011.
I verified the date format in the regional settings both on my computer and the server which runs the macro daily and both use the UK short date format.
Can anyone help identify why this does not apepar to be working correctly?
Based on advice found on google and the Creating Reports for Each Region or Model in MrExcels VBA and Macros for excel 2007 I used this:
PHP:
Sheets("Yday Performance- Agent").PivotTables("PivotTable1").PivotFields("Date").CurrentPage = DateAdd("d", -1, Date)I verified the date format in the regional settings both on my computer and the server which runs the macro daily and both use the UK short date format.
Can anyone help identify why this does not apepar to be working correctly?
