+ Reply to Thread
Results 1 to 7 of 7

Download Image to specific directory

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,854

    Download Image to specific directory

    Hi.

    I'd like to put the image on a site in the directory.
    how do I do that?
    I tried to adapt the code below but I could not.
    Please Login or Register  to view this content.
    Thanks
    Last edited by marreco; 03-30-2013 at 05:22 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Download Image to specific directory

    Hi Marreco,

    I just changed your code a little - and it works, but maybe the picture itself is the problem, because it's got a huge white border around it

    Please Login or Register  to view this content.
    I added a routine to crop this picture:

    Please Login or Register  to view this content.
    Last edited by xladept; 03-30-2013 at 06:02 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,854

    Re: Download Image to specific directory

    Hi.

    I want to save this image at this location "C:\Users\marreco\Downloads\"

  4. #4
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: Download Image to specific directory

    Try this.
    It first gets the photo, then puts it in to a chart, then exports the chart as a jpg.
    It was the only way I could find to actually export pictures from the worksheet to my directory.
    I used sometime like this one time because I had to resize a whole bunch of photos for work.
    I wish I knew about Microsoft Picture Manager at the time haha.


    Please Login or Register  to view this content.
    Last edited by jason_lee_91; 03-30-2013 at 10:33 PM.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Download Image to specific directory

    Hi Marreco,

    Maybe:

    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,854

    Re: Download Image to specific directory

    Hi. XLAdept..Very good!!!

    was more than perfect!!

    Thank you very much!!!!!!

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Download Image to specific directory

    You're welcome!

+ 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