Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a very basic Visual Basic application that loads a QlikView document using the OCX control. I am able to resize the OCX control itself but cannot get the "FitZoomToWindow()" issued so that the document itself resizes like I do through QlikView macros. I am using the following code:
ocxCriticalDashboard.ActiveDocument.ActiveSheet.FitZoomToWindow()
Any suggestions would be greatly appreciated.
The FitZoomToWindow method just does not work in the OCX control. There are a few like this that can be called and don't do anything. It would be great if they were removed or added, or at least if it was written in the documentation, but it's not...
Hi daltonruer,
Interesting question. Have you tried ZoomFactor? E.G:
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = 0.9
mysheet.SetProperties sp
You will have to figure out what zoomfactor you want yourself, though.