Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello.
Try to do this:
ActiveDocument.ActivateSheet("NAMESHEET")
ActiveDocument.ActivateSheet("NAMESHEET").ExportBitmapToFile "YOUR_ADDRESS\FILENAME.png"
Have a good job.