in reply to Win32::OLE and EXCEL

As I always say when it comes to such Office/OLE questions...

Use the makro recorder and convert the resulting code!


holli, /regexed monk/

Replies are listed 'Best First'.
Re^2: Win32::OLE and EXCEL
by dcutcher (Initiate) on Aug 09, 2005 at 10:11 UTC
    I finally got it. The correct code is
    $sheet->PageSetup->{PrintTitleRows} = ($sheet->Rows('$1:$2')->Address) +;
    Thanks for the help. Now on to adding page breaks.

    Janitored by Corion: Added closing code tag, as per Writeup Formatting Tips