Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Margins in Excel
Message
 
À
24/03/2006 11:17:54
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01107412
Message ID:
01107420
Vues:
23
This message has been marked as the solution to the initial question of the thread.
Th code below may need adjustments from one Excel version to other.
Common recommendation is: record the macro in Excel, and translate VBA code to VFP.
    With oExcel.ActiveSheet.PageSetup
        .LeftMargin = oExcel.Application.InchesToPoints(1)
        .RightMargin = oExcel.Application.InchesToPoints(0.5)

.....
        
    EndWith
>Hi
>I´m generating a excel sheet from VFP, everything is Ok, but need to set left and right margins before printing the sheet. How can I do that?
>
>Thanks in advance..
>Carlos Burgos
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform