Macro to check file loading of picture

[GoodmanJim]

I want to check to see if I have valid variable file address for the picture. If valid I want to insert picture on worksheet. If invalid I want to check four different drives locations before inserting a default picture from another work sheet.


Note all picture have the same file name (folder.jpg)

Dim PicPath As String Ref (D:\Music\Jazz\Boney James Backbone\Folder.jpg)

Dim pic As Picture (picture to insert)

error check on PicPath (this does not work for a picture)
Set pic = ActiveSheet.Pictures.Insert(PicPath) (this works to insert a know file)
(if not a know file I get macro fault)

Thanks for your help
Jim

 

[Smitty]

Please stick with your Original Post.

It helps everyone stay on track.