Office TANAKA - Excel VBA Tips[APIを使ã‚ãªã„ã§å®Ÿè¡Œä¸ã®ã‚¿ã‚¹ã‚¯ä¸€è¦§ã‚’調ã¹ã‚‹]Excel VBAã®Tipsã¨ã—ã¦ã¯ã€ã‹ãªã‚Šã®å則ã ã¨æ€ã„ã¾ã™ã€‚ã ã£ã¦ã€Excel VBAã®æ©Ÿèƒ½ã§ã¯ãªã„ã®ã§ã™ã‹ã‚‰ã€‚ ã“ã‚Œã¯ã€å…ˆæ—¥ä½œæˆã—ã¦ã„ãŸãƒžã‚¯ãƒã§ã€ã©ã†ã—ã¦ã‚‚ã“ã®æƒ…å ±ãŒå¿…è¦ã«ãªã‚Šã€ã‚ã‚Œã“れ探ã—ã¦ã„ãŸã‚‰å¶ç„¶è¦‹ã¤ã‘ãŸãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã§ã™ã€‚見ã¤ã‘ãŸã¨ãã«æ€ã£ãŸã®ã¯ã€Œãˆã‡ï½žã‚ºãƒ«ã„ï¼ã€ã¨ã„ã†å°è±¡ã§ã—ãŸ(^^; ç¾åœ¨å®Ÿè¡Œã—ã¦ã„ã‚‹ã™ã¹ã¦ã®ã‚½ãƒ•ãƒˆã‚’調ã¹ã‚‹ã«ã¯ã€ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚’èµ·å‹•ã—ã¦[アプリケーション]タブを開ãã¾ã™ã€‚ã“ã“ã«ãƒªã‚¹ãƒˆã•ã‚Œã‚‹ã€Œãƒ—ãƒã‚»ã‚¹ä¸€è¦§ã€ã‚’プãƒã‚°ãƒ©ãƒ ã‹ã‚‰å–å¾—ã™ã‚‹ã«ã¯ã€Windowsã®APIã‚„ã€WMI(Windows Management Instrumentation)ãªã©ã‚’使ã†ã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ã“ã®ã€Œãƒ—ãƒã‚»ã‚¹ä¸€è¦§ã€ã‚’VBAã ã‘ã§å–å¾—ã—よã†ã¨ã„ã†ã®ãŒä»Šå›žã®ãƒ†ãƒ¼ãƒžã§ã™ã€‚次ã®ã‚ˆã†ã«ã‚„ã‚Šã¾ã™ã€‚ Sub Sample1() Dim WD, task, n As Long Set WD = Create
{{#tags}}- {{label}}
{{/tags}}