Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

2 Replies
Gysbert_Wassenaar

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
Not applicable
Author

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?