|
|||||||||||||||||||||
|
|||||||
| Notices |
![]() |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi..All
Thanks foy ur Support. I have a problem in Excel 2007 Macro. This Macro is running well with Excel2007(.xlsm files). The Problem is that when i run it with a Excel 2003 file it gives a error: "Run Time Error 1004. The Pivot Table Field name is not valid........." I have used this code for Creating Pivot Table ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "DataRange", Version:=xlPivotTableVersion10).CreatePivotTable _ TableDestination:="PivotTable!R3C1", TableName:="PivotTable4", DefaultVersion _ :=xlPivotTableVersion10 I am unable to understand why this error is coming...Pls Help me |
|
#2
|
||||
|
||||
|
moved to correct forum!
__________________
Regards, Simon Please read this before cross posting! Please always give feedback...good or bad! Please take the time to read the Forum Rules before posting! |
![]() |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|