Hello,
I have a excel file where I have a flowchart. I am trying to link each box in flowchart to a picture that happens to be in the same directory as the excel file.
All I want to do is when I click on the textbox, I want a particular bmp or jpeg to be inserted in the document.
I tried with macro recording and it worked. The concern is I am going to explain this flowchart to clients and all my data will be on flash drive.
So I have to get rid of the absolute path of the jpeg location and make it dependent on the directory or path where the excel file is located.
Any ideas how to do it?
Thanks
I have a excel file where I have a flowchart. I am trying to link each box in flowchart to a picture that happens to be in the same directory as the excel file.
All I want to do is when I click on the textbox, I want a particular bmp or jpeg to be inserted in the document.
I tried with macro recording and it worked. The concern is I am going to explain this flowchart to clients and all my data will be on flash drive.
So I have to get rid of the absolute path of the jpeg location and make it dependent on the directory or path where the excel file is located.
Any ideas how to do it?
Thanks