Hello, I have little to no experience in righting codes. I have managed to get my hands on the code bellow .
Function: insert's picture in excel from location
The problem i have is once I send the file to another user, if he/she will not have an opened connection to the location from were the pictures were inserted , they will get an error instead of the picture. It's something with "ActiveSheet.Pictures.Insert" that requires an established connection to the source, even thow the pictures were inserted in the sheet.
"Shapes.Addpicture" and "SaveWithDocument" should solve this problem. I`ve tried myself to modify the code with no result.
Can you please help me ?
Please Login or Register to view this content.
Bookmarks