Skip to main content

Qlik

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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?

329 Views
0 Likes
2 Replies
Gysbert_Wassenaar
MVP
MVP
‎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
175 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?

175 Views
0 Likes