screenshot and paste to email VBA

Put the code below in a standard code module.

Replace...
Application.SendKeys "(%{1068})"

With...
AltPrintScreen

Please Login or Register  to view this content.

did you find this on google to try ?
https://www.mrexcel.com/forum/excel-...ot-thanks.html
you need to determine primary/secondary screen and then know the screen size to set

Re:

Is it to hard to attach it as an attachment rather then a copy and paste.

if you want as attachment i would suggest a seperate method to create the attachment(i assume you want jpg or pdf?)

then the email code would be much easier, whereby it simple email + attachment code

also...if you only want to take a range from your spreadsheet...
wouldn't it be better to just take the range of your spreadsheet to create image rather than taking screenshot instead?
that way you dont have the excel ribbon and other things you dont really want/need in the image?

http://www.excelforum.com/excel-prog...via-email.html
Post #10

Originally Posted by russkris

Still takes the SS of both monitors and not the active workbook or primary screen.

You implemented it correctly.

If you run a macro that only does AltPrintScreen, it captures only the application screen area.

For some reason, it captures the whole screen when called within your macro. I don't know why. If i can figure it out, I'll let you know.

Alphafrog - that's so strange

i can get it to work perfectly to take screenshot of VBE environment
however if you try to screenshot just the workbook...it takes to the whole dual screen

only way i can seem to get around it by doing what tlowry suggests which is to crop the image after being pasted