Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to code this excel macro into VFP
Message
From
26/03/2003 15:18:18
 
 
To
26/03/2003 14:05:18
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00770384
Message ID:
00770422
Views:
11
>
>    ActiveSheet.PivotTables("PivotTable").PivotFields("title").Subtotals = Array( _
>        False, False, False, False, False, False, False, False, False, False, False, False)
>
>	    With ActiveSheet.PivotTables("PivotTable").PivotFields("line_numbr")
>	        .LayoutBlankLine = False
>	        .LayoutForm = xlTabular
>            End With
>
>
>i tried
>oPivotTable.PivotFields("line_numbr").subtotals=.f. && OLE ERROR parameter incorrect
>
>oPivotTable.PivotFields("line_numbr").layoutform=xlTabular && it fires a error message xlTabular not found ,what is the value of xlTabular
>
>TIA

I looked up xlTabular in Excel's object browser and its value is 0.
You just have to define it that way, i.e. #define xlTabular 0
HTH,
Winn Pauley
Previous
Reply
Map
View

Click here to load this message in the networking platform