Jul 31 2021 02:48 PM
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:
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.
Aug 01 2021 10:48 AM
SolutionHere 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.
Feb 21 2022 10:59 PM
Feb 22 2022 04:31 AM
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.
Aug 01 2021 10:48 AM
SolutionHere 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.