+ Reply to Thread
Results 1 to 6 of 6

load pictures from folder, crop, adjust in cell

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    381

    load pictures from folder, crop, adjust in cell

    quick question. is there any way for excel to open/import bmp or jpg images and then always cut them at the exact some spot?

    Eg. I have several screenshots which have a small passport picture always at the same position. now i am looking to find a fast and easy way to have these pictures cut and then inserted into my sheet.

    Any ideas IF excel is even capable of doing this?

    Regards,
    A2k
    Last edited by Armitage2k; 08-07-2009 at 11:46 AM.

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

    Re: cut pictures at the same spot

    If you use the macro recorder whilst cropping the picture you can then apply that to other pictures with the same layout/size.

    You want the last occurance of each of the crop statements.

    I used this on the example image, Flowers006.JPG, to isolate the ant climbing the plant.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    381

    Re: cut pictures at the same spot

    wonderful, this is exactly what I need.

    Just one tiny little favor to ask. Is there a way to let excel automatically import all bmp files from a folder, and then let this macro run it for every shape in a loop? at the moment the macro can only handle one shape, how can i let it jump to the next one?

    Thanks a lot!!
    A2k

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

    Re: cut pictures at the same spot

    there are many examples on the forum of loading images from folder.

    Have a search and if you need more help post back.

  5. #5
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    381

    Re: cut pictures at the same spot

    forum search spits out 3 results, google presents only import and resize, and that most of the time for specified files only... so basically this is a dead end.

    I do not need any macro which is only applicable to certain files, I would need it to import a whole folde of bmp's (all 1024x768), each into a cell of column A preferably, and then let the macro crop every picture to the required size. the problem is cannot get around this since I must have the each passport picture only in a cell of column A to make another macro work which imports me that picture into a userform....

    I already made all necessary changes and wrote some bits of code, but the import from a folder and especially the insertion into a cell, is giving me quite a headache since there is nothing i could refer to on the net...

    Thanks a lot!
    A2k

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

    Re: load pictures from folder, crop, adjust in cell

    This just places each cropped picture over the next cell in column A.
    If the cell is not big enough the pictures will overlap.

    Please Login or Register  to view this content.

+ 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