|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
08-01-2008, 06:52 AM
|
|||
|
|||
Excel 2007 macro does not compatibel with Excell 2003 file
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
08-01-2008, 06:58 AM
|
||||
|
||||
|
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 | |
|
|
Linear Mode
