■ Excel/ㅡExcel VBA Study
엑셀 VBA 웹크롤링
with seok
2021. 5. 7. 20:35
엑사남 주식 현재가 크롤링
| ie.Document.getElementsByClassName("AAA") ie.Document.getElementsByClassName("AAA")(1).Innertext ie.Document.getElementsByClassName("AAA")(1) .getElementsByTagName("li")(1).Innertext |
| ie.Document.getElementsByTagName("P") ie.Document.getElementsByTagName("P")(5).InnerText |
| ie.Document.getElementByID("A02").InnerText ie.Document.getElementByID("A02") .getElementsByTagName("li")(1).InnerText |
| dim strText as string dim V_Text strText = ie.Document.getElementByTagName("P")(5).InnerText V_Text = Split(strText,"/") Msgbox V_Text(1) |
728x90