General information
Category:
COM/DCOM and OLE Automation
Title:
Passing arrays to Excel variant properties
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only