Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I want to take a screenshot of the whole sheet (having scroll) and mail as an Attachment.
I have tried the following macro but I am unable to get whole sheet:
sub ExDashboard
ImgPath="D:\9A Application\Mohammad\images\"
SheetName="Image.JPEG"
SheetPath=ImgPath&SheetName
ActiveDocument.ActiveSheet.ExportBitmapToFile SheetPath
end sub
Regards,
Mohammad
?????????????
If you can open it as a web page (accesspoint, full browser version) there are web page capture programs for these things. Never used it for qlik but it should work. I'll google and find one for you
On my mac I've used the program paparazzi and it works perfectly. but there seem to be a variety of programs.
link:
Hi Linus..
The solution u suggest me..will only capture the screenshot...right??
I want to mail that screenshot at the same time and automatically...
Aha I understand. Yes it will only take a screenshot. I think you have to have another approach then. Did you look into the report editor or NPrinting? I think NPrinting cost extra but it sounds like what you need. Or you can use the report editor. When you edit your report you place the objects you have created on to a sheet which you can then print or send out with publisher. Same thing is done with Nprinting but they've made it a lot nicer and easier to work with. Hope you manage to work it out.
Refer this thread https://community.qlik.com/thread/31509