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
Bookmarks