The VB Editor's object browser, when I look for Merge tells me that there are 3 members of the Range object that might work:
Property MergeCells As Variant
Property MergeArea As Range read-only Member of Excel.Range
Sub Merge([Across])
I tried about 20 different constructs. No use of Merge() or Merge(5) produced an effect. Every way of using MergeArea produced an error. What's going on?
The ONLY one that worked was
$range->{MergeCells} = 1;
where $range is all the cells that you want to merge together.
The object browser is a horrible tease.
It doesn't tell what the setting of a property does or what acceptable values are.
It gives a one-word descriptiong of method parameters, but again, there's no information on what the method does.
And a range can be a row, column, area or cell-- the obj browser docs doesn't say for which it works.
Q1: Where are these documented?
Q2: How can I tell which are accessible from Perl?
Is there some way of querying a Perl object for its methods and fields?
I tried just looping through the keys of objects and printing the associated values, but reading some of the values produced effects. Still, that gave me clues. But I don't know how to find the methods...
Q3: Does anyone out there generate Excel docs from Perl? Is this a useful skill?
Thanks, -Randy
_______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
