ActiveDocument.ActiveSheet.CopyBitmapToClipboard is not copying the whole sheet image

Anonymous — Fri, 09 Feb 2018 05:50:20 GMT

Hi,

I am trying to copy and paste the image of my sheet using this macro:

ActiveDocument.ActiveSheet.CopyBitmapToClipboard TRUE

However, this is not copying the full sheet.

I even tried Fit Zoom to window. But it is not working

Any solution wherein I can get image of my full sheet.

Thanks

Krati

Re: ActiveDocument.ActiveSheet.CopyBitmapToClipboard is not copying the whole sheet image

Almorais — Wed, 23 Jan 2019 13:38:13 GMT

Hello.

Try to do this:

ActiveDocument.ActivateSheet("NAMESHEET")
ActiveDocument.ActivateSheet("NAMESHEET").ExportBitmapToFile "YOUR_ADDRESS\FILENAME.png"

Have a good job.