Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ScreenUpdating

I'm looking for the equivalent of the below for VBScript.  Anyone come across this?


Application.ScreenUpdating = False

1 Solution

Accepted Solutions
Not applicable
Author

I was able to resolve my current problem in an un-elegant way.  I still wish there was a way to suppress the screen updating.

I just moved all the objects the VB needed to work with to the same tab as the button the user presses.  However, the objects are off screen and hidden except for when the VB code is executing and since the objects are off screen, the user will not be the wiser about it.

Thanks for trying to assist.

View solution in original post

6 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Are you trying to stop/wait your macro until the UI computation is completed?

ActiveDocument.GetApplication.WaitForIdle

Not applicable
Author

Nope.  I just don't want them to see a few things that the code does as it moves between tabs.  I also suspect it will speed up the code processing time if the screen isn't rendering the whole time.

tresesco
MVP
MVP

Not really equivalent, still this could help you :

ActiveDocument.GetApplication.Refresh

And, have you tried the document settings? Settings->Document Properties-> Server -> Refresh options

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

It is almost like you want to run your Macro which involves in fetching the data in different sheets, but it should not show it to the user that it is switching sheets when macro runs.

seems not possible... if i am not wrong when you try to get the data or to do something on a sheet that sheet/object has to be active..

can you send me a sample app...may be i can think of some thing else.

rustyfishbones
Master II
Master II

I have a similar Issue for a Extraction file, that also create a folder Structure.

Before I extract the Data I create a Folder Structure, like below using EXECUTE

2014-01-24_1637.png

this works, but the screen seems to flicker rapidly for a couple of seconds and then it's complete, I would like to remove this flickering, this is not VBScript, it's the Qlikview Script Editor.

Is there anything that can stop this?

Regards

Alan

Not applicable
Author

I was able to resolve my current problem in an un-elegant way.  I still wish there was a way to suppress the screen updating.

I just moved all the objects the VB needed to work with to the same tab as the button the user presses.  However, the objects are off screen and hidden except for when the VB code is executing and since the objects are off screen, the user will not be the wiser about it.

Thanks for trying to assist.