VBA to take screenshots of session and paste to Excel
VBA to take screenshots of session and paste to Excel
(OP)
Hello,
I have a VBA macro in an Excel file that screen scrapes data from Attachmate Extra Session in a loop for a provided list of input values. In addition to the screen scrape of data, I would like to take screen prints of the Extra Session window for each item in the list and paste these screen prints into a separate worksheet. I've tried using Application.SendKeys "(%{1068})" to copy the screen print to the clipboard, but this copies the excel window instead of the Extra Session. I've also tried the API calls from this website: http://word.mvps.org/faqs/macrosvba/PrtSc.htm with the same result. Does anyone have any experience with this? Once I can get the image to the clipboard I can code the pasting process from there.
Thanks in advance!
I have a VBA macro in an Excel file that screen scrapes data from Attachmate Extra Session in a loop for a provided list of input values. In addition to the screen scrape of data, I would like to take screen prints of the Extra Session window for each item in the list and paste these screen prints into a separate worksheet. I've tried using Application.SendKeys "(%{1068})" to copy the screen print to the clipboard, but this copies the excel window instead of the Extra Session. I've also tried the API calls from this website: http://word.mvps.org/faqs/macrosvba/PrtSc.htm with the same result. Does anyone have any experience with this? Once I can get the image to the clipboard I can code the pasting process from there.
Thanks in advance!
Talk To Other Members