Re: Help inserting page break in Microsoft Excel using OLE

jobs_ron

I have no idea what I am talking about, Visual Basic is not permitted here in my shop, even Excel is only barely tolerated!

ActiveState Perl Dev Kit 6.0 has a little thing call 'VB Script convertor' which is said to turn VB into Perl. Well, I input your line of VB code and here is what it came back with:

$ActiveWindow->SelectedSheets->HPageBreaks->Add({Before => $ActiveCell
+});
[download]

Sincerely jdtoronto or "The Piano Player"

Comment on Re: Help inserting page break in Microsoft Excel using OLE Download Code

Replies are listed 'Best First'.
Re^2: Help inserting page break in Microsoft Excel using OLE by jobs_ron (Acolyte) on Mar 01, 2005 at 19:23 UTC
What would $ActiveWindow be defined as?	[reply]
Re^3: Help inserting page break in Microsoft Excel using OLE by Joost (Canon) on Mar 01, 2005 at 19:29 UTC
You could possibly replace $ActiveWindow->SelectedSheets with $sheet . Not that I know anything about OLE. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re^4: Help inserting page break in Microsoft Excel using OLE by jobs_ron (Acolyte) on Mar 01, 2005 at 19:34 UTC
Thank you. I did try this, although I changed the code from this: `$sheet -> HPageBreaks -> Add({Before => $ActiveCell});` [download] to this: `$sheet -> HPageBreaks -> Add({Before => $sheet -> ActiveCell});` [download] Still, nothing happens.	[reply] [d/l] [select]
Re^5: Help inserting page break in Microsoft Excel using OLE by jobs_ron (Acolyte) on Mar 01, 2005 at 23:55 UTC