Re: Using Win32::OLE and Excel - Tips and Tricks

[ArmandoG]

in reply to Using Win32::OLE and Excel - Tips and Tricks

this tutorial has being my foundation on the project at work thank you, since that said, I am a newbie in Win32::OLE I got this problem I need to copy a cell and cant do it this is the code I am using:

$Sheet->Range('A17')->Select();
$Sheet->Selection->Copy('A17');
$Sheet->Range('B15')->Select();
$Sheet->ActiveSheet->Paste();

but that did not work what is wrong? I take this from the VBA in the macro.
Oh. yes I am using only WIN32::OLE

[Anonymous Monk]

Try if it works:

$range1=$sheet->range('A17');

$Sheet->copy($range1);

$range2=$sheet->range('B15');

$range2=$sheet->paste();

[HelenCr]

This piece of code doesn't work because "Selection" is a method of the parent Excel application, not the sheet.

So if you had, in the beginning of your code:

my $XcelApp = Win32::OLE->new( 'Excel.Application' );

Then the second line in your post should go:

$XcelApp->Selection->Copy('A17');

Helen