+ Reply to Thread
Results 1 to 2 of 2

Use VBA to crop a picture and save the picture in a folder

  1. #1
    Registered User
    Join Date
    09-22-2009
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2010 (Work) O365Home (Home)
    Posts
    94

    Use VBA to crop a picture and save the picture in a folder

    Hi,

    I want to be able to Insert a picture into a worksheet from a specified filepath and then crop it in the worksheet. Once the picture has been cropped I want to be able to set this newly cropped picture as the background of a chart.

    As far as I can see, in order to set a picture as a background of a chart the pic needs to have its own filepath. Is it posibble to write some code in VBA to save a newly cropped picture (created in a worksheet) to a folder, say, "My Pictures", and then set this new picture file as the background of a chart

    Alex

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

    Re: Use VBA to crop a picture and save the picture in a folder

    Check out Stephen's PastePicture example
    http://www.oaltd.co.uk/Excel/Default.htm
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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