{"id":4790,"date":"2022-01-26T19:37:12","date_gmt":"2022-01-26T10:37:12","guid":{"rendered":"https:\/\/saving.if8x.com\/?p=4790"},"modified":"2022-01-26T19:39:44","modified_gmt":"2022-01-26T10:39:44","slug":"post-4790","status":"publish","type":"post","link":"https:\/\/saving.if8x.com\/?p=4790","title":{"rendered":"Excel\u30de\u30af\u30ed\uff08VBA\uff09\u3067Web\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u3059\u308b\u6642\u306b\u5fc5\u8981\u306aSelenium\u306e\u8a2d\u5b9a\u3002\u5b9f\u884c\u6642\u30a8\u30e9\u30fc33\u306e\u76f4\u3057\u65b9"},"content":{"rendered":"<div class=\"502ed48402477407308c71c483e67fba\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- if8x saving link up -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9170790507767546\"\r\n     data-ad-slot=\"6178874004\"\r\n     data-ad-format=\"link\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>\u4eca\u56de\u306f\u3001\u304b\u306a\u308a\u30de\u30cb\u30a2\u30c3\u30af\u306a\u5185\u5bb9\u3067\u3059\u304c\u3001VBA\u3067Web\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u3057\u305f\u3044\u3068\u601d\u3063\u3066\u3044\u308b\u521d\u5fc3\u8005\u306e\u65b9\u306b\u306f\u5f79\u7acb\u3064\u5185\u5bb9\u3067\u3059\u3002<\/p>\n<p><strong>\uff11\uff0eSeleniumBasic\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/strong><br \/>\n<a href=\"https:\/\/github.com\/florentbr\/SeleniumBasic\/releases\/tag\/v2.0.9.0\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/florentbr\/SeleniumBasic\/releases\/tag\/v2.0.9.0<\/a><\/p>\n<p>SeleniumBasic-2.0.9.0.exe\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b\u5834\u6240\u3000C:\\Users\\XXXXXX\\AppData\\Local\\SeleniumBasic<\/p>\n<p><a href=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4791\" src=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601.png\" alt=\"\" width=\"751\" height=\"491\" srcset=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601.png 751w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-300x196.png 300w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-530x347.png 530w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-565x369.png 565w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-710x464.png 710w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-725x474.png 725w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p><strong>\uff12\uff0echromedriver.exe\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/strong><\/p>\n<p><a href=\"https:\/\/sites.google.com\/chromium.org\/driver\/\" target=\"_blank\" rel=\"noopener\">https:\/\/sites.google.com\/chromium.org\/driver\/<\/a><\/p>\n<p>chrome\u306e\u30d8\u30eb\u30d7\u304b\u3089\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u78ba\u8a8d\u3057\u3066\u3001\u540c\u3058\u30d0\u30fc\u30b8\u30e7\u30f3\u306echromedriver.exe\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3002<br \/>\n32bit\u3057\u304b\u3042\u308a\u307e\u305b\u3093\u304c\u300164bit\u30de\u30b7\u30f3\u3067\u3082\u3001\u3061\u3083\u3093\u3068\u4f7f\u3048\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4794\" src=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604.png\" alt=\"\" width=\"1129\" height=\"504\" srcset=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604.png 1129w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-300x134.png 300w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-1024x457.png 1024w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-768x343.png 768w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-530x237.png 530w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-565x252.png 565w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-710x317.png 710w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012604-725x324.png 725w\" sizes=\"auto, (max-width: 1129px) 100vw, 1129px\" \/><\/a><\/p>\n<p><strong>\uff13\uff0e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u300cchromedriver.exe\u300d\u3092\u3001\u4e0a\u8a18\uff11\u306e\u30d5\u30a9\u30eb\u30c0\u5185\u306b\u4e0a\u66f8\u304d\u3059\u308b<\/strong><\/p>\n<p><a href=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4791\" src=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601.png\" alt=\"\" width=\"751\" height=\"491\" srcset=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601.png 751w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-300x196.png 300w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-530x347.png 530w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-565x369.png 565w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-710x464.png 710w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012601-725x474.png 725w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p>\u4e0a\u8a18\uff11\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u3001\u305d\u306e\u30d5\u30a9\u30eb\u30c0\u5185\u306bchromedriver.exe\u304c\u5165\u3063\u3066\u3044\u308b<\/p>\n<p>\u4e0a\u8a18\uff12\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fchromedriver.exe\u3092\u4e0a\u66f8\u304d\u3059\u308b\u3002<\/p>\n<p><strong><span style=\"color: #ff0000;\">\u203b\u3053\u308c\u3092\u3084\u3089\u306a\u3044\u3068VBA\u5b9f\u884c\u6642\u306b\u300c\u30a8\u30e9\u30fc&#8217;33&#8217;\u300d\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/span><\/strong><\/p>\n<p><strong>\uff14\uff0eExcel\u3067VBA\u3092\u66f8\u304f\u3002\u305d\u3057\u3066Visual Basic Editor\u3092\u7acb\u3061\u4e0a\u3052\u305f\u6642\u306b\u3001\u300c\u30c4\u30fc\u30eb\u300d\u2192\u300c\u53c2\u7167\u8a2d\u5b9a\u300d\u2192\u300cSelenium Type Library\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3059\u308b\u3002<\/strong><\/p>\n<p><a href=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4792\" src=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602.png\" alt=\"\" width=\"785\" height=\"466\" srcset=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602.png 785w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602-300x178.png 300w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602-768x456.png 768w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602-530x315.png 530w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602-565x335.png 565w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602-710x421.png 710w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012602-725x430.png 725w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4793\" src=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603.png\" alt=\"\" width=\"974\" height=\"498\" srcset=\"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603.png 974w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603-300x153.png 300w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603-768x393.png 768w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603-530x271.png 530w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603-565x289.png 565w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603-710x363.png 710w, https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603-725x371.png 725w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>\uff15\uff0e\u30c6\u30b9\u30c8\u7528\u30b5\u30f3\u30d7\u30ebVBA<\/strong><\/p>\n<p>\u3082\u3057\u3001\u5168\u90e8\u554f\u984c\u306a\u3051\u308c\u3070\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001chrome\u304c\u7acb\u3061\u4e0a\u304c\u308a\u3001\u30e4\u30d5\u30fc\u306e\u30b5\u30a4\u30c8\u304c\u958b\u304d\u307e\u3059\u3002<\/p>\n<p>Sub Macro1()<br \/>\nDim Driver As New Selenium.WebDriver<br \/>\nDriver.Start &#8220;chrome&#8221;<br \/>\nDriver.Get &#8220;https:\/\/www.yahoo.co.jp\/&#8221;<br \/>\nStop<br \/>\nEnd Sub<\/p>\n<p><a href=\"https:\/\/lifestyle.blogmura.com\/goodlife\/ranking\/in?p_cid=10899380\" target=\"_blank\" rel=\"noopener\">\u5f79\u3060\u3063\u305f\u3089\u3053\u3053\u3092\u30dd\u30c1\u3063\u3068\u30af\u30ea\u30c3\u30af\u3057\u3066\u5fdc\u63f4\u3088\u308d\u3057\u304f\u304a\u9858\u3044\u81f4\u3057\u307e\u3059\u3002\u306b\u307b\u3093\u30d6\u30ed\u30b0\u6751<\/a><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u4eca\u56de\u306f\u3001\u304b\u306a\u308a\u30de\u30cb\u30a2\u30c3\u30af\u306a\u5185\u5bb9\u3067\u3059\u304c\u3001VBA\u3067Web\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u3057\u305f\u3044\u3068\u601d\u3063\u3066\u3044\u308b\u521d\u5fc3\u8005\u306e\u65b9\u306b\u306f\u5f79\u7acb\u3064\u5185\u5bb9\u3067\u3059\u3002 \uff11\uff0eSeleniumBasic\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb https:\/\/github.com\/florentbr\/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4793,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[66,331,59],"tags":[],"class_list":["post-4790","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excelword","category-331","category-59"],"views":4179,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/saving.if8x.com\/wp-content\/uploads\/2022012603.png","_links":{"self":[{"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/posts\/4790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4790"}],"version-history":[{"count":3,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/posts\/4790\/revisions"}],"predecessor-version":[{"id":4797,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/posts\/4790\/revisions\/4797"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=\/wp\/v2\/media\/4793"}],"wp:attachment":[{"href":"https:\/\/saving.if8x.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saving.if8x.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}