Screen Shot Paste
Hi
Need screen shot to take screen shot at bottom of Ctrl Down arrow
Does on a separate button ready for manual paste but doesn't when included to main stitched together macro.
All set up with buttons
Whole macro Deletes 10 Tabs then Replaces with 10 new Tabs, then Ctrl Down arrow, then takes screen shot and paste into appropriate Tab.
Cheers in advance of course : )
Mike
Last edited by keen2xl; 10-11-2013 at 06:18 AM.
Not sure if VBA can take a screenshot without sendkeys. Didn't really look very hard.
Please Login or Register to view this content.
Thanks for reply
But sorted it out now, code was just in the wrong order already using Screen Shot code
Application.SendKeys "(%{1068})"
DoEvents
Which works. but again interaction sparks a thought i might not of had, maybe
Ok Cheers
Learning all the time : )
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks