Private Declare Sub Sleep Lib "kernel32" (ByVal ms As Long)
Function getHTML(strSheetName As String, strUrl As String) As Boolean
getHTML = True
Dim objIE As Object
Set objIE = CreateObject("InternetExplorer.Application")
objIE.Visible = True
objIE.FullScreen = False
objIE.Top = 200
objIE.Left = 100
objIE.Width = 800
objIE.Height = 600
objIE.navigate strUrl
While objIE.readyState <> 4 Or objIE.Busy = True
DoEvents
Wend
DoEvents
objIE.ExecWB 17, 0
objIE.ExecWB 12, 0
Set sh = Worksheets.Add(After:=Worksheets(Worksheets.Count))
sh.Name = strSheetName
sh.Range("A1").Select
sh.Paste
objIE.Quit
DoEvents
err_flg:
Set sh = Nothing
Set objIE = Nothing
Sleep 5000
End Function
’エラー処理とか必要