in reply to excel pasting

I think you need to write this as a method call, with the data as a hash, for example: (Please note I've not tested this - see next section also)
$xls4->Cells(9, 15)-> PasteSpecial( { Paste => xlValues, Operation => xlNone, SkipBlanks=> False, Transpose => False", });
This won't work, because the constants xlValues, xlNone and False aren't imported using Win32::OLE. I think there's a way to find these... need to perldoc Win32::OLE a bit more, but a way of checking is to go to the VBA screen's 'Immediate' window and type print xlValues (which is -4163 apparently...)

Sorry if this is vague - I'll test more later if I have time!

Cheerio!
Osfameron