I have a sheet set up where i fill in details of a report.
On the sheet i also have code to place a photo/s over a cell if required and size to suit cell.
When the report is done, i generally print it to pdf.
Then clear all the data and photo's from the report ready for a new report.
I do this by using code to save the data into another sheet in a single row across from A1:R1.
I also save (included in the A1:R1) the photo's location(eg. C:My Documents/My Pictures/Image1.jpg). I store this in the report by using this line of code when the image is selected :
The photo's themselves are NOT STORED.
I have a macro set up to narrow down the required report by 3 x Listboxes on a userform. When the value is selected in Listbox3, the selected data is placed back from the stored row, into the original report sheet. (This works Well thus far)
But my Question is :
Can i add code to bring the original photo that was in the report back into the report BY USING THE Photo's Location value stored in the cell below the photo ?
I understand that IF that particular photo was not in it's original folder it would not work, but if unmoved could this be done ?
EG. Say the stored location of the photo was(C:My Documents/My Pictures/Image1.jpg), and this value was stored in a cell in say R1 int he stored data sheet. Could VBA code select that image and place it back into the sheet ?
Corey....
Bookmarks