Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to code this excel macro into VFP
Message
De
26/03/2003 15:18:18
 
 
À
26/03/2003 14:05:18
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00770384
Message ID:
00770422
Vues:
12
>
>    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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform