Macro, Excel FitToPagesTall = 1

[#1]

Hi Guys,

I have a macro that copies data out to an excel s/sheet. I need to be able to set the page so that,

FitToPagesWide = 1

FitToPagesTall = 1

Please can someone advise how I can do this in the macro as nothing I seem to try is working.

Thanks

[Gysbert_Wassenaar]

This has very little to do with qlikview since you're trying to manipulate excel. Maybe this helps:

With ActiveSheet.PageSetup     

      .FitToPagesWide = 1

      .FitToPagesTall = 1

End With

If you need more information try googling for vba+excel+fittopages

[#3 · Accepted solution]

Thank you.

I actually needed 3 components to make it work.

.Zoom = False

.FitToPagesWide = 1

.FitToPagesTall = 1