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 14:05:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
How to code this excel macro into VFP
Miscellaneous
Thread ID:
00770384
Message ID:
00770384
Views:
54
    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
Next
Reply
Map
View

Click here to load this message in the networking platform