|Syntactic Confectionery Delight|
Troubles transposing a range in Excel with Win32::OLEby guha (Priest)
|on Jan 10, 2002 at 00:20 UTC||Need Help??|
guha has asked for the wisdom of the Perl Monks concerning the following question:
Hi fellow monks, today I have spent some time trying to transponate a range (2D-grid) in Excel.
I have followed the usual(?) procedure to record a macro in excel doing the operation and then converting the VBA-code to perl
The line that does the actual transpose look like this
This results in the following errormessage from Win32::OLE
OLE exception from "Microsoft Excel": Could not find PasteSpecial property for the Range class Win32::OLE(0.15) error 0x80020009: "Exception occured" in METHOD/PROPERTYGET "PasteSpecial" at cp2.pl line 31
I get the same errormessage when I invoke the function with the more standard call approach
HOWEVER when I skip the fourth argument, "Transpose", thing work OK except that no transposition is done as the argument defaults to false
Any ideas someone??