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

[Anonymous]

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

[Almorais]

Hello.

Try to do this:

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

Have a good job.