Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-06-05 04:24 AM

URGENT MACRO HELP!

Hi All,

I have a macro that takes a screen shot of a sheet and then sends it to excel. However, if the model is not active on the sheet, it cant take a screenshot. It come through blank. I have tried ActiveDocument.GetSheet("").Activate before the screenshot to activate the sheet but it doesnt work.

Any Ideas?

399 Views
0 Likes
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2013-06-05 05:06 AM

To activate a sheet use something like:

ActiveDocument.Sheets("Main").Activate

This should create a 'screenshot' of the sheet with the name Main:

ActiveDocument.Sheets("Main").CopyBitmapToClipboard


talk is cheap, supply exceeds demand
245 Views
0 Likes
Not applicable
‎2013-06-05 05:09 AM
Author

In response to Gysbert_Wassenaar

Hi Gysbert,

I have managed to sort of the Activate part, although I need a timeout period to allow the sheet to activate. I have tried:

" ActiveDocument.GetApplication.WaitForIdle 1000 " but Qlikview seems to hang on waitforidle. Seems to be a bug.

Any way around that?

245 Views
0 Likes