I've the code below to insert pictures on a Excel sheet. The pictures are on a network drive. This works fine and I can see the pictures on my computer when I open the file.
If I save the file on another PC and try to open it, I can't see the pictures and instead of the picture I get the message displayed on the attached image.
I'm working with Excel 2010. Three months ago I was working with Excel 2003 and I didn't had this problem. I only have this problem since our company upgraded to Excel 2010.
Can annyone please help me understand what I'm missing here?
On Error Resume Next
Dim result() As String
result = Split(ActiveCell.Value, "-")
Dim num As Long
num = result(0)
"P:\Backup Montagem Final\ARQUIVO\Agenda MF 2011\FOTOS MF 2011\000" & num & ".JPG").Select