Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing arrays to Excel variant properties
Message
From
18/03/2004 09:36:37
Norbert Kustra
SunSoft plus spol. s r.o.
Dolny Kubin, Slovakia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Passing arrays to Excel variant properties
Miscellaneous
Thread ID:
00887487
Message ID:
00887487
Views:
94
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
Map
View

Click here to load this message in the networking platform