how to crop and export sheet to clipboard?

[jonnyb]

Hi guys,

I want to export a QlikView sheet to ClipBoard with a Macro, but I'm having problems to put a cropped image on the ClipBoard, e.g. I want to cut 100px from the left, 200px from the bottom and 50px from the top.

Thank you in advance

--Macro code

Sub ExportCroppedImgToClipBoard

'Needs to crop the image before I put it in ClipBoard

ActiveDocument.Activesheet.CopyBitmapToClipboard

end sub

regards,

Jonny

[Anonymous]

That sounds quite ambitous. You can perform a zoom on the sheet size:

rem ** fit active sheet to window **

ActiveDocument.ActiveSheet.FitZoomToWindow

rem ** apply same zoom to all sheets **

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

Apparantly there is also a clipboard zoom, though I'm not sure what that does:

set up = ActiveDocument.GetApplication.GetUserPreferences

up.ClipboardZoom = 200

ActiveDocument.GetApplication.SetUserPreferences up

Jonathan