Inserting pictures from a file name that is made from 3 cells [Closed]

Report
Posts
2
Registration date
Wednesday June 28, 2017
Status
Member
Last seen
June 28, 2017
-
 Blocked Profile -
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


insert fails from mobile app
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Wednesday June 28, 2017
Status
Member
Last seen
June 28, 2017

Image NAMES* currently follow no . . .

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!