+ Reply to Thread
Results 1 to 2 of 2

Images from clipboard directly into a cell. Feasible?

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    germany
    MS-Off Ver
    Excel 2007
    Posts
    1

    Lightbulb Images from clipboard directly into a cell. Feasible?

    Hi.
    My problem is that I need to insert image from clipboard directly into cell. Cell have pre-determinated size (width and height). Image have bigger dimentions than cell.
    So basically I want paste image into cell so that image fit cell dimentions (without adjusting image size manualy).
    Can stright excel options make that happen? Or do I need go into VBA? Is it feasible?

    I take screan shoot by pressing alt + S (it is print screen of defined region, its JPG, 700x470px more or less) now I want to paste this from clipboard to temporary spreadsheet into predefined cell (450x250) by just clicking on the cell and presing ctrl + V .

    I would like to have in this temporary spreadsheet 4 predefined cells for 4 different screanshoots.

    Problem here is that if i make scshoot, click on cell and paste image it is not in the cell but rather overlay spreadsheet (so I need to manualy adjust image size to cell size I desire).

    2nd thing is transfering those 4 images from template.xls to destination.xls
    In template.xls 4 images have same size and orientation.
    In destination.xls those images are in:
    -different size cells
    -one of them have different orientation and smaller size
    -one of them is in 2 places one smaller size and one bigger size
    -three of them are beside each other (smaller size)

    What I want to do is:
    1. After CTRL + V image should be in cell (size of image adjusted automaticly)
    2. Automatic transfer of images from template.xls to destination.xls
    PS: Images are pasted to template.xls always in same order


    - destination.xls is template for final raport, after pasting images and adding some more content it is saved each time (30 times per day) to a folder

    - template.xls is way of transfering those 4 images from station A to station B on witch final raport is created

    I'm open for ideas. Even advice how folder/files structure could look like. I was even considering template.xls and destination.xls to be on station A and for final touch in station B goes destination.xls with images in proper places and sizes.

    I'm struggling with that past 2 weeks so any input is higly appreciated.

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Images from clipboard directly into a cell. Feasible?

    It might be possible with VBA but I don't think you can do it by simple formatting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1