+ Reply to Thread
Results 1 to 7 of 7

Pasting an Excel Range into MS Paint

  1. #1
    Registered User
    Join Date
    06-21-2024
    Location
    Delaware, USA
    MS-Off Ver
    365
    Posts
    10

    Pasting an Excel Range into MS Paint

    I have this code that selects a range from excel. I want to open
    mspaint and paste into it (so Control C, and then Control V)

    I need help finishing the code. I have got as far as Control C, opening
    MS Paint but I get the code to paste :-

    Thank you in advance.
    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 10-08-2024 at 10:38 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,199

    Re: Pasting an Excel Range into MS Paint

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however we recommend that you include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

    I did it for you since you are sorta new.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,199

    Re: Pasting an Excel Range into MS Paint

    Put this code into the sheet module for sheet Screen Data. This uses Wait because The WshShell commands are asynchronous so you have to allow time for Windows to open Paint, activate it, and send the keys.

    Please Login or Register  to view this content.
    If you still have problems, attach your file (see yellow banner at the top of the page).

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: Pasting an Excel Range into MS Paint

    You can save the range as a jpg image, then open that in Paint manually.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,545

    Re: Pasting an Excel Range into MS Paint

    Like Logit, I will suggest exporting the range to a file and opening it in MSPaint. The macro only supports EMF files.
    Please Login or Register  to view this content.
    Artik

  6. #6
    Registered User
    Join Date
    06-21-2024
    Location
    Delaware, USA
    MS-Off Ver
    365
    Posts
    10

    Re: Pasting an Excel Range into MS Paint

    This code worked a treat.....love the brevity of it.. Thanks Guitar guy....

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,199

    Re: Pasting an Excel Range into MS Paint

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking $A addreputationiconsmall.jpg below their profile in any of their posts.

+ 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. [SOLVED] MS Paint on Excel
    By otherbobby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2014, 03:41 AM
  2. how to format paint a range?
    By sumesh56 in forum Excel General
    Replies: 4
    Last Post: 04-14-2013, 10:15 PM
  3. [SOLVED] Copy image range excel to paint
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2012, 12:31 AM
  4. Paint inside if there is no formatting in the range
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2012, 06:26 AM
  5. pasting a picture to paint
    By Chinchin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2011, 09:02 AM
  6. if blank cells, paint yellow. if cell to left is less than a number, don't paint
    By curbster in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-09-2009, 02:40 AM
  7. Paste from excel to paint
    By parker21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2005, 10:45 AM

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