SOLVED

Changing a Photo based on cell Value in Excel

Copper Contributor

Running Excel "Office365 for Business"  I want to type in a photo file name and have the image shown change to the filename from a folder the excel file sits in:

GSAInsp_0-1627767326348.png

 

Columns A, B, E, F, G, & H always stay the same.

Column C will contain the image name

Column D is the Image - Note: the image must be named "Picture" & the number in Column A

There are 188 photos that would need to be modified based on the value of Column C.

 

This is a much larger project then just this worksheet and will have to be able to change based on where the excel file resides.

i.e.

\\server\folder1\folder2\workingfolderALPHA\File.xls 

\\server\folder1\folder2\workingfolderBETA\File.xls 

 

I have already defined the worksheet as a TABLE with the columns NAMED and correspond with other worksheets in the file.

3 Replies
best response confirmed by GSAInsp (Copper Contributor)
Solution

@GSAInsp 

Here are some suggested solutions, see the file, even if I did not understand what exactly your plan is. The translation doesn't help either.

 

But I recommend you insert a file (without sensitive data) and explain your project in detail in this file. Knowing which Excel version and operating system you have at the same time would be beneficial for everyone involved.

 

Recommend you to read this link:

Welcome to your Excel discussion space!

 

Hope this information could help you.

 

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

@GSAInsp 

 

Did you ever find a solution to this? I'm looking to do something similar.

@StephenRutherford 

 

I have a VB module I wrote that works pretty well. Still some bugs to work through like adjusting rotation and resolution, but so far it is doing what I expect it to do.

1 best response

Accepted Solutions
best response confirmed by GSAInsp (Copper Contributor)
Solution

@GSAInsp 

Here are some suggested solutions, see the file, even if I did not understand what exactly your plan is. The translation doesn't help either.

 

But I recommend you insert a file (without sensitive data) and explain your project in detail in this file. Knowing which Excel version and operating system you have at the same time would be beneficial for everyone involved.

 

Recommend you to read this link:

Welcome to your Excel discussion space!

 

Hope this information could help you.

 

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

View solution in original post