Hi,
can anybody help me. I am not able to pass array to Excel variant property:
1. I can read Excel variant property and I get array sd
sd=oXL.ActiveSheet.PivotTables(1).SourceData
2. But I cannot set this property from VFP, even the property is read-write (I can set it from Excel VBA)
oXL.ActiveSheet.PivotTables(1).SourceData=sd

Thanks
Norbert Kustra