Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Margins in Excel
Message
 
To
24/03/2006 11:17:54
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01107412
Message ID:
01107420
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform