Photos stored in worksheet

Hi Everybody

I have a problem with macro and hope you can help me

I created macro which extracts data from worksheet, copy it to new file and adds photo. Everything works great besides those photos which don't display when new file is opened on different computer (client, colleagues)

is there any way to save photo in the file so it appears on other computers?

this is how i insert photo:

Range("O12").Select
           ActiveSheet.Pictures.Insert( _
         "C:\podpis.jpg").Select
           Selection.ShapeRange.ScaleHeight 0.5, msoFalse, msoScaleFromTopLeft

any help would be great

anybody? please help me

Does "C:\podpis.jpg" exist on your other computer???

I would suggest moving the pictures to a shared drive on your network that all the computers can access, then change your code to pull the pictures from there.

 ... .Pictures.Insert("\\server\share\directory\podpis.jpg").Select

I do not believe your code physically embedds the photo into a worksheet only pulls one into the shape.

I have a worksheet without macro and with photo which appears on every computer where i send it

I know that if i place jpg on a share drive it would work but only inside my company and what about outside? To be honest this is only needed for external use.

Is there any way to insert photo which will appear on completely different computer which has no access to my or shared drive?