Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement