Results 1 to 1 of 1

Automatic insertion of an image from its filename

Threaded View

  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

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