Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA to take screenshots of session and paste to Excel

Status
Not open for further replies.

KB920

MIS
Mar 24, 2014
1
US
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: 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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top