Hi Here’s my problem : I try to insert a picture in an Excel worksheet using an url with the “AddPicture” function. If my URL is correct it works fine, but when the url is not correct an excel error occurs. I can’t check if my url is correct as I could do with a File, that’s why I would like to know if there’s a way to catch this error after executing my function. Note that the pictures can’t be accessed through the file system (for security concerns), I can only use URLs. My English is not perfect so ask me for more detailled explanations if I’m not understable [:I]. regards
There might be an event you could try to catch. Try to enable “WithEvents” property for your automation variable(s) and check if there is an event you can catch.
Unfortunately the WithEvents option doesn’t allow me to catch errors from excel. I must change my approach. Anyway thank you for help Thomas