Discussion Board for collaboration related to Creating Analytics for QlikView.
guys , after our recent upgrade from 7.5 to 8.5 following this simple but very appreciated by my users , stopped working
sub Zommset mysheet=ActiveDocument.ActiveSheetset sp=mysheet.GetPropertiesset v= ActiveDocument.Variables("varZoom")var=v.GetContent.string/100sp.ZoomFactor=varmysheet.SetProperties spActiveDocument.ActiveSheet.ApplyZoomToAllSheetsend sub
any ideas will be appreciated
Go to Solution.
Add ActiveDocument.GetApplication.WaitForIdle just prior to ApplyZoomToAllSheets to let QV time to display new window size, and it will work fine in 8.5.
API set is changing all the time, so I'm guessing some of your function interfaces had changed. In fact, I see at least one change already - I think the string needs another "suffix" .v:
A sure way to find out is to run your macros with a debugger and see where it fails. You might have to install Microsoft Script debugger if you haven't done so before.
Yves ,it worked as expected, thanks for your advice, also to oleg for his contribution!!!!