Dim vDoc Dim j as integer If WebBrowser1.ReadyState = READYSTATE_COMPLETE Then Set vDoc = WebBrowser1.Document.getElementsByTagName("a") vCount = vDoc.Length End If
For j = 0 To vCount If vDoc(j).innerText = xlSheet.Cells(i, 2).Value Then vDoc(j).Click Exit For End If next j
ÔÚvbÖÐÔõôÅжϣ¬²åÈëµ½Êý¾Ý¿âÖеÄÖµÊÇÖØ¸´µÄ£¬±¾È˲ŸսӴ¥VBÓïÑÔ£¬ÉõÊÇÓÐºÃ¶àµØ·½»¹²»¶®£¬»¹Çë¸÷λ´óÏÀÃǸø³ö´úÂ룬ллÁËѽ£¡£¡£¡ ²åÈë֮ǰselectһϰ¢¡£ »òÕßдһ¸ö×éºÏSQL²åÈëÓï¾ä£¬ÀýÈç IF not Exist( & ......