On Error Resume Next
Jim,
What do you mean by 'cannot open'.
I tried it with a file that didn't exits, and it went ok. B TW I declared p
as a Picture object.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Jim Sharrock" wrote in message
...
On Error Resume Next
Set p = ActiveSheet.Pictures.Insert(strPicRef)
When I access a picture that I cannot open, the above gives me run time
error 1004 via the debug dialogue box and no means of trapping the error.
Any idea why ?
Thanks, Jim.
|