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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadkhatimi
Partner - Specialist
Partner - Specialist

Full sheet screenshot to image and mail

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

6 Replies
mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

?????????????

linusblomberg
Creator II
Creator II

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

linusblomberg
Creator II
Creator II

On my mac I've used the program paparazzi and it works perfectly. but there seem to be a variety of programs.

link:

6 ways to capture full webpage screenshots

mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

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...

linusblomberg
Creator II
Creator II

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.

Siva_Sankar
Master II
Master II