topic Macro, Excel FitToPagesTall = 1 in QlikView

Macro, Excel FitToPagesTall = 1

Mon, 22 Oct 2012 13:54:46 GMT

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 — Mon, 22 Oct 2012 14:09:34 GMT

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

Mon, 22 Oct 2012 14:56:00 GMT

Thank you.

I actually needed 3 components to make it work.

.Zoom = False

.FitToPagesWide = 1

.FitToPagesTall = 1