Are there error codes? check Err.Number and Err.Description after a failed connection. (test it by intentionally removing a letter from the web site name)
Perhaps you're using an "On Error Resume Next"? In which case, it moves on when there is an error. You can test for the error code and proceed however you wish. Paul ________________________________ From: vitovla <slbcr...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Monday, April 6, 2009 10:18:29 AM Subject: $$Excel-Macros$$ Re: Connecting with yahoo finance servers Hello Ashish Jain, Yes you are right but my real problem it's that I don't know what is/ are the condition to establish that the connection fails. I tried put in a "On Error GoTo" statement but the problem persist because Excel doesn't close the failed connection Do you have any suggestion? Thanks Vitovla On Apr 6, 2:37 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi vitovla, > > Use Exit keyword to break a process. You can use it to come out of > Subroutine or a Loop. > Its possible combinations are: > > Exit Do > Exit For > Exit Sub > > Regards > Ashish Jain > > On Apr 4, 9:12 pm, vitovla <slbcr...@gmail.com> wrote: > > > Hello, > > > I'm developing an application to download the data from yahoo finance > > servers. > > > How Can I do to break a process if the yahoo page is not available and/ > > or the connection failed? > > > thanks a lot --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
