[VBA]30分ã‚ã‚Œã°ã§ãã‚‹VBAスクレイピング - Qiita#0 å‰ç½®ã 昨今ã€æ§˜ã€…ãªè¨€èªžã§ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ングãŒå‡ºæ¥ã¾ã™ãŒã€VBAãªã‚‰é–‹ç™ºç’°å¢ƒæ§‹ç¯‰ãŒä¸è¦ã§ã‚µã‚¤ãƒˆã‹ã‚‰å¼•ã£å¼µã£ã¦ããŸå€¤ã‚’Csvã«å‡ºã™å¿…è¦ã‚‚ãªã直接セルã«è¨å®šã§ãã‚‹ã®ã¯ä¸ã€…é…力的ã ã¨å€‹äººçš„ã«æ€ã„ã¾ã™ã€‚ 作æˆã—ãŸãƒžã‚¯ãƒã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã®ã§ã‚ˆã‹ã£ãŸã‚‰ã©ã†ãž #1 事å‰æº–å‚™ ##1.1 å¿…è¦ãªç’°å¢ƒ ・Excel ・Internet Explore ※ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¤ã„ã¦ã¯çŸ¥ã‚‰ãªã„ ã“ã‚Œã ã‘ã§ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ングãŒã§ãる環境ãŒæ•´ã„ã¾ã™ã€‚ä»–ã®è¨€èªžã«æ¯”ã¹ã‚‹ã¨ã‹ãªã‚ŠãŠæ‰‹è»½ã ã¨æ€ã„ã¾ã›ã‚“？ ##1.2 ライブラリã®è¿½åŠ 標準ã®ãƒ©ã‚¤ãƒ–ラリã ã¨DOMæ“作ã€ãŠã‚ˆã³ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ングã¯ã§ããªã„ã®ã§ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’è¿½åŠ ã—ã¾ã™ã€‚ â‘ Excelã‚’é–‹ã„ãŸã‚‰VBEã‚’é–‹ã(Alt+F11) ②メニューãƒãƒ¼â†’「ツールã€â†’「å‚ç…§è¨å®šã€ â‘¢ãšã‚‰ãšã‚‰ã¨ãƒ©ã‚¤ãƒ–ラリãŒä¸¦ã‚“ã§ã„ã‚‹ãŒã€ ãã®ä¸ã‹ã‚‰ä»¥ä¸‹ã®äºŒã¤ã‚’探ã—ã¦ãƒã‚§ãƒƒã‚¯ã‚’入れる。 ・Microsoft
![[VBA]30分ã‚ã‚Œã°ã§ãã‚‹VBAスクレイピング - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/50bdb0395c93e4852460c49736b81ba849c73916/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-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9JTVCVkJBJTVEMzAlRTUlODglODYlRTMlODElODIlRTMlODIlOEMlRTMlODElQjAlRTMlODElQTclRTMlODElOEQlRTMlODIlOEJWQkElRTMlODIlQjklRTMlODIlQUYlRTMlODMlQUMlRTMlODIlQTQlRTMlODMlOTQlRTMlODMlQjMlRTMlODIlQjAmdHh0LWFsaWduPWxlZnQlMkN0b3AmdHh0LWNvbG9yPSUyMzFFMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT01NiZzPTk3NzlkY2M3YmM3M2QxOWE0N2Q3Y2U5MDlkMDUyMDFm%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDBTb3JlS2lpdGEmdHh0LWNvbG9yPSUyMzFFMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT0zNiZ0eHQtYWxpZ249bGVmdCUyQ3RvcCZzPTQzNDhmNWM2Y2MzOWEyODY4ZDA4NGQ3ZDRiOTgxZTk4%26blend-x%3D142%26blend-y%3D486%26blend-mode%3Dnormal%26s%3De4e77d8020356f5677ec2c21ebaecaf1)
{{#tags}}- {{label}}
{{/tags}}