Hello, We are using a function to add pictures to an Excel workbook in a VB macro, the function call looks like this:
myDocument.Shapes.AddPicture _ v_url, _ True, True, v_left, v_top, 45, 65 The picture is returned from another server from the URL string that is obtained from our data. The problem is sometimes there is no corresponding picture to be returned and the macro abends. We would like to be able to test the call and if there is no picture available post a message to the cell and continue processing. Any assistance would be appreciated. Thanks, Rick --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---