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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---