+ Reply to Thread
Results 1 to 11 of 11

Copy range as picture

  1. 08-02-2013, 03:35 PM #1
    moraalg
    moraalg is offline
    Registered User
    Join Date
    08-02-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    5

    Copy range as picture

    Hey everyone,

    Currently I create a report by copying a selected table within excel, and pasting it into my Word document as PASTE SPECIAL - PDF. This seems to be the only way to accurately copy the date where it doesn't come out blurry or out of ratio. I have searched for different code to try to resize the cells or to keep the aspect ratio in check, with no solution. I have also searched for functions to attempt to convert the table to a picture or object format, still no luck. Any suggestions or other routes I can go?
    Reply With QuoteRegister To Reply
  2. 08-02-2013, 03:46 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy range as picture

    Hello moraalg,

    Welcome to the Forum!

    This macro will do it.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 08-02-2013, 03:59 PM #3
    moraalg
    moraalg is offline
    Registered User
    Join Date
    08-02-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    5

    Re: Copy range as picture

    Leith Ross,

    Thanks so much for the quick response. I feel I'm so much closer. However, everytime I run this code Excel shuts down due to an unexpected error. My code is below if there's something I'm missing:

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 08-02-2013 at 04:00 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  4. 08-02-2013, 04:05 PM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy range as picture

    Hello moraalg,

    This code needs to be a VBA Module.
    1. Copy the macro with Ctrl+C.
    2. Open the workbook and use Alt+F11 to open the VB Editor.
    3. Use ALT+I to display the Insert Menu.
    4. Press the M key to add a new Module.
    5. Paste the macro into the Module with Ctrl+V.
    6. Save the macro using Ctrl+S
    Reply With QuoteRegister To Reply
  5. 08-02-2013, 04:08 PM #5
    moraalg
    moraalg is offline
    Registered User
    Join Date
    08-02-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    5

    Re: Copy range as picture

    Leith,

    My code is within a macro and is within a separate module. I have around 75 other macros on this workbook, but I have separated this one to be sure this is the only problem. The other macros assigned to this worksheet work fine, so it is just the problem with this one I am having.

    Thanks,
    Garrett
    Reply With QuoteRegister To Reply
  6. 08-02-2013, 04:17 PM #6
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy range as picture

    Hello moraalg,

    I am not sure what the problem might be. The code was originally developed using Office 2003. It works on my current system which is running Window 7 and Office 2010.

    If you can post a copy of the workbook for review, it will help us find a solution faster.

    How To Post Your Workbook
    1. At the bottom right of the Reply window, Click the button Go Advanced
    2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
    3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
    4. Click the Select Files button at the bottom middle of the dialog.
    5. In the new window Find the file you want to upload, select it, and Click Open.
    6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
    7. Wait until the file has completely uploaded before you exit the File Manager dialog.

    File Manger Picture
    Reply With QuoteRegister To Reply
  7. 08-02-2013, 04:24 PM #7
    moraalg
    moraalg is offline
    Registered User
    Join Date
    08-02-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    5

    Re: Copy range as picture

    My apologies. I had not updated my Excel Version on the forum, and I guarantee the problem stems from using Excel 2011 for MAC. (I realize this is a very subpar version of excel with countless known issues.) Unfortunately the information on this document is very sensitive, I work for a large financial firm, but I can create a type of moc-up if you feel that would help.
    Reply With QuoteRegister To Reply
  8. 08-02-2013, 04:33 PM #8
    moraalg
    moraalg is offline
    Registered User
    Join Date
    08-02-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    5

    Re: Copy range as picture

    Moc-up of a very basic table attached.

    test.xlsm
    Last edited by Leith Ross; 08-02-2013 at 04:41 PM.
    Reply With QuoteRegister To Reply
  9. 08-02-2013, 04:42 PM #9
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy range as picture

    Hello moraalg,

    I will test your file. I am confident it will work on my system because it is a PC. As you mentioned, there many differences between the Mac and PC versions of Office.
    Reply With QuoteRegister To Reply
  10. 08-02-2013, 04:44 PM #10
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy range as picture

    Hello moraalg,,

    As expected, it creates a picture on my PC with no problems. Not being that familiar with the Mac Office version, I don't know of a workaround.
    Reply With QuoteRegister To Reply
  11. 08-02-2013, 04:46 PM #11
    moraalg
    moraalg is offline
    Registered User
    Join Date
    08-02-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2011 for MAC
    Posts
    5

    Re: Copy range as picture

    You help was much appreciated. Just wish Microsoft and Mac had a better relationship. I'm pretty certain Microsoft loves to provide Mac with subpar versions of the Windows version. I'm sure they're laughing everytime they send them a new version.
    Reply With QuoteRegister To Reply
  12. 08-02-2013, 04:48 PM #12
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy range as picture

    Hello moraalg,

    You're welcome. Sorry I don't have a solution for you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste Excel range as picture into Outlook email body using excel vba
    By ExcelDoc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2016, 09:29 PM
  2. VBA for Picture insert at particular worksheet range. Picture name derived from cell.
    By Douglas2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2013, 01:16 AM
  3. [SOLVED] Copy excel range and paste special picture (metafile) into existing word dot VBA
    By Markcuss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 08:21 PM
  4. Excel 2007 VBA Copy Range EXcluding Picture/Image
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2012, 12:20 AM
  5. Shift-Copy - Copy Picture - how to do this in Excel 2007?
    By bungaree in forum Excel General
    Replies: 3
    Last Post: 09-25-2007, 02:39 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1