General information
Title:
Pagebreak in Excel with OLE Automation
I need to insert a page break in an Excel spreadsheet using OLE Automation. When I create an Excel macro to insert a page break and examine the macro in the VBA editor I see
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
The 1st part looks OK, but I can't find "ActiveCell" in the Type Library and the := in VBA probably means something different than the = that I am used to seeing in the VBA code. In short, what is the VFP code to insert a page break in the Excel spreadsheet?
Tim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only