I tried to change the zoom factor, to auto-fit on a page. The macro recorder gives me the following commands:
With ActiveSheet.PageSetup
...
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
I omitted lots of options, but the Excel macro still works without them.
I changed this, in VFP, to:
with This.oSheet.PageSetup
.Zoom = xlFalse
.FitToPagesWide = 1
.FitToPagesTall = 1
Endwith
However, I get an error message on the line that starts with ".Zoom...", stating that it is impossible to assign property Zoom of the class PageSetup.
Setting a fixed percentage works fine. While it now turns out that this is what the users actually want, I would still like to know how to solve this situation.
TIA,
Hilmar
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)