Closed Thread
Results 1 to 8 of 8

VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

  1. #1
    Registered User
    Join Date
    10-01-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    Hi,

    I'm new to this forum. I'm working on mainframe (PCOMM/HOD) , sometimes I need to take screen shots from mainframe screen and paste into excel sheet.

    Can I have a VBA code or MACRO which will take screenshot and will paste it at the desired location/or cell in the excel sheet.

    Thanks,
    Chits

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,127

    Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    this article explains how to do the screen grab from excel.

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=1075
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-01-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Smile Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    Quote Originally Posted by Andy Pope View Post
    this article explains how to do the screen grab from excel.

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=1075

    Thank you Andy for your quick reply . But still I have one doubt, with this VBA code when I'm executing this code, it is opening new excel sheet evertytime and paste it there. I want to paste the screens shot in the same excel sheet which I have opened and at the desired cell.

    Do you have any idea about this?

    Thanks,
    Chits

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,127

    Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    change the code so it does not create a new workbook.sheet.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-01-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    Thanks Andy..

    Andy, Can I change the code in such a way that it will take the snap shot from the application which I want?


    Thanks,
    Chits

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,127

    Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    there is probably APIs that will allow that.

    You can try searching the forum but I think Google would be your best bet.

  7. #7
    Registered User
    Join Date
    10-29-2014
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    1

    Post Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    First of all, sorry for bringing an old thread back to live.
    Chits asked the same question I'm having right now.

    I'm working with IBM Mainframe applications and would like to create a macro (VBA) in Excel which takes a screenshot of the application window and paste it where the Excelbutton will be in place. Sort of 'replace button with screenshot'.

    To be honest, I have no idea how I can start programming this. Also, the link Andy Pope posted a few post before does not work anymore :-(

    Is there anyone who can help me achiving this?

    Thanks in advance!

  8. #8
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

    Welcome to the forum. Pls start your own thread as per forum rules.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to take screenshot in excel to use pictue in vb
    By sugee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 03:54 AM
  2. activate application & take screen shot
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 06:40 AM
  3. Screen Shot Question
    By potatomice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2012, 09:53 AM
  4. Screen Shot
    By CarlainChicago in forum Excel General
    Replies: 1
    Last Post: 09-23-2010, 05:47 PM
  5. Print a screen shot in Excel?
    By Teacher1 in forum Excel General
    Replies: 6
    Last Post: 01-13-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1