+ Reply to Thread
Results 1 to 1 of 1

Automatic insertion of an image from its filename

  1. #1
    Registered User
    Join Date
    11-22-2015
    Location
    Montreal, Canada
    MS-Off Ver
    2007
    Posts
    1

    Automatic insertion of an image from its filename

    Hello everyone,

    I have a file (Exemple.xlsm) containing 6 spaces reserved for images. By clicking once on one of the rectangles, the directory containing the images opens. I can then select the desired image and it is glued to the designated location, dimensioned according to the criteria defined in the VBA code, automatically selected ('Macro & instructions to paste a picture and the name of it (B11 ) ....) and the filename appears on the top left of the image. The images are JPG and prefix begins with 001, 002, 003, .... 999, 1000.

    My problem is this: I would also be able to copy images automatically maintaining the predefined dimensions by typing the name of the image. For example: @ B11 E17 frame, I type in "B10", number: 032 followed by "Enter" and automatically 032.jpg photo will be pasted in the B11 @ E17 frame and the selection of the image will be made automatically without I manually select. The same thing for the other 5 areas for images. To avoid opening the directory containing the images after you press the "Enter" key, it will change the VBA code ('Macro & instructions to paste a picture and the name of it (B11) .. ..) to activate a rectangle with a double-click instead of a single click (present case).

    If you have any questions, please contact me.

    Thanking you in advance for your help.

    Greetings,

    Renaud22
    Attached Files Attached Files

+ 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. excel image insertion with name
    By sarvesh_24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 10:43 PM
  2. Automatic insertion of new sheet
    By ubad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 09:52 AM
  3. Automatic insertion of new sheet
    By ubad in forum Excel General
    Replies: 2
    Last Post: 07-07-2013, 01:32 AM
  4. Automatic data insertion
    By pewe in forum Excel General
    Replies: 8
    Last Post: 12-01-2011, 06:14 PM
  5. Automatic Row insertion
    By collinsc in forum Excel General
    Replies: 3
    Last Post: 05-30-2009, 07:27 PM
  6. Automatic Date Insertion?
    By tristatefab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2006, 04:40 PM
  7. [SOLVED] filename insertion in cells
    By rfcomm2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2005, 12:05 PM

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