Hello,
We the following macro code to place pictures in an Excel workbook the code to do this works in Excel 2002 but receives an error message in Excel 2007.
The code to place the picture is:
If CheckURL(v_url) Then
Set MyRng = Range("B" & rep_row)
v_left = MyRng.Left + 8
v_top = MyRng.Top + 12
myDocument.Shapes.AddPicture _
v_url, _
True, True, v_left, v_top, 50, 50
Else
The error message says "The specified file wasn't found".
Any assistance would be appreciated.
Thanks,
Rick
We the following macro code to place pictures in an Excel workbook the code to do this works in Excel 2002 but receives an error message in Excel 2007.
The code to place the picture is:
If CheckURL(v_url) Then
Set MyRng = Range("B" & rep_row)
v_left = MyRng.Left + 8
v_top = MyRng.Top + 12
myDocument.Shapes.AddPicture _
v_url, _
True, True, v_left, v_top, 50, 50
Else
The error message says "The specified file wasn't found".
Any assistance would be appreciated.
Thanks,
Rick