Inserting pictures from a file name that is made from 3 cells

Closed
Ritna Posts 2 Registration date Wednesday June 28, 2017 Status Member Last seen June 28, 2017 - Jun 28, 2017 at 09:13 AM
 Blocked Profile - Jun 28, 2017 at 04:37 PM
I am looking for a macro to insert all of the pictures from a folder who's address is derived from multiple cells.

Picture location is as follows:
S:\Quality\QA\Warranty Photos 2017\ "cell N4" \ "cell K4" \ "merged cells J3 and K3"

All files in that folder will be ".jpeg"

Image currently follow no set pattern but if it needs to it can be done.
If so lets call them "p1", "p2", "p3" . . . "p7" (no more than 7 photos would be needed)

Image insertion location could be cell "V4" but doesn't really matter

No image modifications need to be done.

Is this even possible?

Any input is greatly appreciated
Related:

3 responses

Blocked Profile
Jun 28, 2017 at 12:21 PM
insert fails from mobile app
1
Blocked Profile
Jun 28, 2017 at 04:37 PM
Sorry for your thread being a test for my mobile device app. I was trying to post the following:

To programmatically construct the file path, it would be something like this:

="S:\filefolder\" & H1 & "\" & I1 & "\" & J1 & ".PNG"


This will not place the picture, but only construct the path!

Please vote it back up!
1
Ritna Posts 2 Registration date Wednesday June 28, 2017 Status Member Last seen June 28, 2017
Jun 28, 2017 at 09:14 AM
Image NAMES* currently follow no . . .
0