概要 InternetExplorerをExcel-VBA経由で操作するサンプルを記述する。 Google検索を自動で行い、検索数を取得してみる。 Excel単体テスト仕様書との連携が待たれない。 コード 参照設定: Microsoft HTML Object Library Microsoft Internet Controls Attribute VB_Name = "Module1" Option Explicit Private Const URL_TARGET As String = "http://google.co.jp/" Private Const TIME_MINIMUMWAIT As Integer = 1 Private Const TIME_MAXWAIT As Integer = 3 Public Sub Main() Dim ie As InternetExp
![ExcelVBAによるIE自動操作サンプル - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/076db07f20d88376067e6dea51b8d5bbf27d7151/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-412672c5f0600ab9a64263b751f1bc81.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9RXhjZWxWQkElRTMlODElQUIlRTMlODIlODglRTMlODIlOEJJRSVFOCU4NyVBQSVFNSU4QiU5NSVFNiU5MyU4RCVFNCVCRCU5QyVFMyU4MiVCNSVFMyU4MyVCMyVFMyU4MyU5NyVFMyU4MyVBQiZ0eHQtYWxpZ249bGVmdCUyQ3RvcCZ0eHQtY29sb3I9JTIzMUUyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTU2JnM9NzkwZDMxNjViOWE3Mjk1Y2Q2YTA5NTJkNjY1Y2FjNzY%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDBuZXp1cSZ0eHQtY29sb3I9JTIzMUUyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9M2FlMjc3MTExNWUyMjExZGJkZWY4NDRiNmFmOTc0NGQ%26blend-x%3D142%26blend-y%3D486%26blend-mode%3Dnormal%26s%3D534933e998480e1e87513ea3cf49df63)