Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting values in more than one excel-cell at a time
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01301740
Message ID:
01302221
Views:
13
>>
>>What I don't understand is the meaning of the function ArrayPasser. I have already tried to pass a reference to the Array (@lcArrayName) to Excel. It does not work since the whole range is then filled with the first array member lcArray(1,1).
>>
>>What is the difference between this variant and passing of the return Value of the function ArrayPasser (@&lcArrayName). That is what I don't understand at a moment.
>>
>>Thanks
>>Alexander
>
>Alexander,
>
>You may consider it as a syntax for communication between VFP and Excel COM.
>Keep in mind that VFP array, and Excel Range.Value are arrays, but they are constructed differently. For instance, VFP array is always one-dimensional array internally, no matter whether you declare it with columns or not.

Helo Juri,

Thanks a lot, I've already implemented it and it works.

Alexander
Alexander Lerner
a_lerner@heinrich-schmid.de

The life is somewhat easier than it seems to be.
Previous
Reply
Map
View

Click here to load this message in the networking platform