+ Reply to Thread
Results 1 to 2 of 2

Import Image Macro

  1. #1
    Registered User
    Join Date
    02-22-2014
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    13

    Question Import Image Macro

    Hi,
    I want to record a macro that imports an image (png file) from
    -file path specified in column AU (which has been generated from a concatenate formula)
    -file name starting with 141 (i.e. like a wildcard as my file is generated based on many factors but always starts as 141)

    I want the macro to
    - do this for every row until there are 2 empty cells in AU (incase there is just a gap between two data rows)
    - resize the image to 2x2cm and resize the row and column height accordingly
    - start the import from the 1st empty row in column AU (in case i have already imported 10 lines etc)

    i'm using excel 2010 and the original file dimensions are 3000x2400

    Thank you

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,146
    Hello kryssie.e,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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