Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pagebreak in Excel with OLE Automation
Message
De
05/06/1999 23:45:19
Tim Muller
Innovative Solutions, Inc.
West New York, New Jersey, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Pagebreak in Excel with OLE Automation
Divers
Thread ID:
00226890
Message ID:
00226890
Vues:
96
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
Fil
Voir

Click here to load this message in the networking platform