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

3 replies

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