>I am needing to format my Page Setup options in Excel from within my VFP code. Does anybody know the proper syntax for:
> 1. Orientation(page tab)=landscape and portrait
> 2. all Margin tabs(margin tab)=top, header, left, right, bottom, and footer
> 3. creating a Custom footer(header/footer tab) for the left, center, and right sections
> 4. Rows to repeat at top(sheet tab)
> 5. and any other page setup options
You basically need to do two things here:
1) Run the commands with the macro on in Excel to get the command names (like .orientation = xlLandscape)
2) Get the Excel constants (xlLandscape) by using an INCLUDE .h file, available here in the Files section under Classes
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.