http://qs321.pair.com?node_id=128120


in reply to excel pasting

Two things. First, use Win32::OLE::Const to import the excel constants. Second, PasteSpecial is a method, not a property. The code below should work (yes it has been tested).
use Win32::OLE; use Win32::OLE::Const 'Microsoft Excel'; $excel = Win32::OLE->new ("Excel.Application") || die "CreateObject : +$!\n"; $excel -> {Visible}=1; $excelfile2 = $excel -> Workbooks -> Open("c:\\sheetA.xls"); $excelfile = $excel -> Workbooks -> Open("c:\\sheetB.xls"); $xls4 = $excelfile -> Worksheets(1); $xls5 = $excelfile2 -> Worksheets(1); $xls5 -> Range ("H58:H105") -> Copy; $xls4 -> Cells (9, 15) -> PasteSpecial (xlPasteValues); $xls4 -> Cells (9, 14) -> Select;
If you have any additional questions, feel free to ask.

Replies are listed 'Best First'.
Re: Re: excel pasting
by toni_t_banire@gsk.com (Initiate) on Nov 29, 2001 at 18:06 UTC
    This is to say a really big THANK YOU you to c-era for resolving my excel paste problem.
    Really appreciate the quick response

    Toni