源代碼 如何通過網(wǎng)頁源代碼來提取網(wǎng)頁中的圖片?
如何通過網(wǎng)頁源代碼來提取網(wǎng)頁中的圖片?Dim URL As StringDim MySheet As ObjectDim MyBrowser As ObjectSet MyBrowser=UserFo
如何通過網(wǎng)頁源代碼來提取網(wǎng)頁中的圖片?
Dim URL As String
Dim MySheet As Object
Dim MyBrowser As ObjectSet MyBrowser=UserForm1.WebBrowser1
設置MySheet=此工作簿。工作表(“測試”)
MySheet.Cells.NumberFormat格式=“@”
。導航URL
Do Until.ReadyState=4
DoEvents
Loop
End With
設置MyBrowser=Nothing End Sub