+ Reply to Thread
Results 1 to 6 of 6

Looking for Excel vba code for starting the "screen clipping" tool in excel

  1. #1
    Registered User
    Join Date
    06-21-2016
    Location
    Jenbach, Austria
    MS-Off Ver
    2010
    Posts
    4

    Looking for Excel vba code for starting the "screen clipping" tool in excel

    Hi guys,

    I joint recently this community with the hope to get a support on my excel vba issue.
    I wrote a small program in excel vba which is just simulating key strokes to open the "screen clipping tool" which is a part of excel 2010.
    (in excel 2010: goto --> insert --> screenshot --> "screen clipping")

    Now I got the information that some other computers are using German or English excel version and also office 2010 or 2016 is in use. With my actual program the key strokes are not working on all computers.

    Now I would like to ask you is their any possibility to run a vba command which is starting the "screen clipping" tool directly without any key stroke in excel?

    my vba code:
    Please Login or Register  to view this content.

    Thanks in advance for your support
    BR Cetin
    Last edited by davesexcel; 12-06-2019 at 07:25 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,332

    Re: Looking for Excel vba code for starting the "screen clipping" tool in excel

    Try:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-21-2016
    Location
    Jenbach, Austria
    MS-Off Ver
    2010
    Posts
    4

    Re: Looking for Excel vba code for starting the "screen clipping" tool in excel

    Dear rorya,

    Thank you so much... it worked.

    Br Cetin

  4. #4
    Registered User
    Join Date
    06-21-2016
    Location
    Jenbach, Austria
    MS-Off Ver
    2010
    Posts
    4

    Re: Looking for Excel vba code for starting the "screen clipping" tool in excel

    Hey, one more question:
    Is it possible to get a list of this kind of ExecuteMso commands?
    I do have also an add-in program which is required to record a signature with a signature pad. But I do not have any idea how to call this add-in program. Is there any possibility to get our the application name of this additional add-in window?

    Thanks
    BR Cetin

  5. #5
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,332

    Re: Looking for Excel vba code for starting the "screen clipping" tool in excel

    This method only works with built-in controls. For an add-in, your best bet is to contact the developer and find out the name of the routine to run.

  6. #6
    Registered User
    Join Date
    06-21-2016
    Location
    Jenbach, Austria
    MS-Off Ver
    2010
    Posts
    4

    Re: Looking for Excel vba code for starting the "screen clipping" tool in excel

    thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How does the Excel Chart tool "call" the data?
    By ne6c in forum Excel General
    Replies: 2
    Last Post: 03-20-2014, 06:50 AM
  2. How to call the Excel "range-selection tool"?
    By geophysicist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2013, 01:23 PM
  3. Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells
    By mebanet in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 06:14 AM
  4. Replies: 0
    Last Post: 06-25-2013, 10:44 AM
  5. Replies: 0
    Last Post: 11-20-2012, 10:22 AM
  6. cant find tool "Data analysis" in excel 2007
    By Anzar in forum Excel General
    Replies: 2
    Last Post: 06-14-2009, 11:14 AM
  7. [SOLVED] "File Format Not Valid" When Starting Excel. Error Code 0D3F6000
    By EMT_Hawk in forum Excel General
    Replies: 4
    Last Post: 03-31-2006, 04:25 PM
  8. Binocular search tool, Excel, loses column designation at "Find"
    By Little Rock Ette in forum Excel General
    Replies: 1
    Last Post: 11-16-2005, 01:52 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