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