+ Reply to Thread
Results 1 to 6 of 6

insert picture the same size and location of existing picture

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-23-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2013
    Posts
    116

    Re: insert picture the same size and location of existing picture

    Thanks, mcmahobt!

    I am familiar with the website that you pasted, but that is not exactly what I am looking for. That does not help me resize and place apicture based on an existing image (or at least I don't think it does).

    Concerning your code -- I can't get this to work, so am not sure if it can accomplish the task. How do I call the new image? How does the code identify the existing pictures location and size? . Thanks for the input!

    In case it helps, let me be a little more clear about my intent: I have a "backend" excel document which houses the locations of pictures for different inspections (so imagine cell A1 = C:\user\mydocuments\pic1.jpg, and A2 = C:\user\mydocuments\pic2.jpg and so forth). When the user runs my macro, they will be creating hundred of reports based on a "report template" that they will create. That is why I need to define a picture to a certain location -- so the macro will know where exactly to paste pictures for subsequent reports (what I'm thinking is the macro will look for "picture1" or something and replace it with the picture from the backend).
    Last edited by mcdermott2; 03-13-2015 at 10:50 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. [SOLVED] macro: insert picture based on workbook location, not picture root path.
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2012, 07:47 AM
  3. How to insert picture and automatically size to cell?
    By ursa_nz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. How to insert picture and automatically size to cell?
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  5. How to insert picture and automatically size to cell?
    By ursa_nz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

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