+ Reply to Thread
Results 1 to 3 of 3

VBA copy excel as a picture to word - zoom picture

  1. 11-29-2016, 02:19 PM #1
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    VBA copy excel as a picture to word - zoom picture

    Hi

    I am trying to resize the picture when copying excel to word but I am struggling with the code to resize, would appreciate a steer in the right direction if possible.

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    many thanks
    Reply With QuoteRegister To Reply
  2. 11-29-2016, 03:45 PM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: VBA copy excel as a picture to word - zoom picture

    Hello michelle 1,

    Please visit this site: https://www.thespreadsheetguru.com/b...-word-with-vba

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 12-01-2016, 06:47 AM #3
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    Re: VBA copy excel as a picture to word - zoom picture

    Thanks Winon this is really useful I searched for ages without success.

    Only issue I have is the formatting is all out which is why I thought copy and pasting as a picture would be the better solution?
    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. EXCEL, PICTURE SHAPE, VBA: Fit Picture Proportionately Inside a Fixed Sized Picture Shape
    By lhasha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2016, 10:02 PM
  2. Inserting Picture into Picture Content Control in Word crashes Word
    By atycks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2015, 09:59 AM
  3. Copy an Image from a User form Picture Box to Worksheet Picture Box
    By sledgehammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 11:39 AM
  4. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  5. [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
  6. Move/Copy the picture from excel workbook to MS word
    By kate.middleton1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2012, 10:15 AM
  7. Zoom in on selected picture
    By ufo_pilot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2006, 04:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1