[B! vba] tyamamotoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tyamamoto id:tyamamoto

vbaã«é–¢ã™ã‚‹tyamamotoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (38)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒã®ãŠä½œæ³•ï¼ˆè¨ˆç®—ç”¨ã‚·ãƒ¼ãƒˆã¨ã„ã†è«¸æ‚ªã®æ ¹æºã«ã¤ã„ã¦ï¼‰
å‰ç½®ãã“ã®æ—¥è¨˜ã®å†…å®¹ã¯ã€ä¼šç¤¾ã®å¾Œè¼©ã‹ã‚‰ã€Œæœ€è¿‘ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒã‚’å‹‰å¼·ã—å§‹ã‚ã¦ï¼ˆã‚ãƒ©ã‚ãƒ©ï¼‰ã€ã¨ã„ã†è©±ã‚’èžã„ã¦ã€å…ˆè¼©ãƒ ãƒ¼ãƒ–ã‚’ã‹ã¾ã™ãŸã‚ã«è©±ã—ãŸå†…å®¹ã«ãªã‚Šã¾ã™ã€‚ ã¨ã«ã‹ãã“ã‚Œã‹ã‚‰èª¬æ˜Žã™ã‚‹ã€Œè¨ˆç®—ç”¨ã‚·ãƒ¼ãƒˆã€ãŒæ†Žãã¦æ†Žãã¦ãŸã¾ã‚‰ãšã€ã¡ã‚‡ã£ã¨å¼•ã‹ã‚Œã‚‹ã»ã©ç†±å¼ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ãŸã ã€ä»–ã®æ–¹ãŒã©ã†ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã‚„ã€é€†ã«ã€Œè¨ˆç®—ç”¨ã‚·ãƒ¼ãƒˆã€ã‚’æ„›ç”¨ã™ã‚‹æ–¹ã®æ„è¦‹ã‚‚èžããŸããªã‚Šã€å¢—ç”°ã«æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ å¢—ç”°ã®çµŒæ´ä¸å°ä¼æ¥ã®éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼ˆäº‹å‹™è·å“¡ï¼‰ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒæ´ï¼˜å¹´ãã‚‰ã„ åˆã‚ã¦è§¦ã£ãŸè¨€èªžãŒï¼¶ï¼¢ï¼¡ã§ã€å‰ä»»ãŒä½œã£ãŸã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒã‚’æ”¹ä¿®ã‚’ã„ããªã‚Šé ¼ã¾ã‚ŒãŸã®ãŒãã£ã‹ã‘ä¼šç¤¾ã®éƒ½åˆã§Java Scriptã€PHPã‹ã‚‰ãªã‚‹ç¤¾å†…ã‚·ã‚¹ãƒ†ãƒ ã®æ”¹ä¿®ã€ä¿å®ˆã‚’æ‹…å½“ã—ãŸã“ã¨ã‚ã‚Š ä»Šã¯è¶£å‘³ã§Pythonã§NLPã€LLMã‚’å‹‰å¼·ä¸ã“ã®è¨˜äº‹ã®è¶£æ—¨ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒã®ãŠä½œæ³•ã¨ã‹æ›¸ãã¾ã—ãŸãŒã€è¦ã™ã‚‹ã«ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒã§ã€Œè¨ˆç®—ç”¨ã‚·ãƒ¼ãƒˆã€ã£ã¦è‰²ã€…ãªæ„å‘³ã§ã‚ˆããªã„ã‚ˆãã€
tyamamoto 2024/03/04
excel

vba
ãƒªãƒ³ã‚¯
Excelã§VBAã‚’ä½¿ã‚ãªã„ã§ãƒ†ãƒˆãƒªã‚¹ã‚’å†ç¾ã™ã‚‹
VBAã‚’ä½¿ã‚ãªã„ã§ã‚²ãƒ¼ãƒ ã‚’ä½œã£ã¦ã¿ã‚‹ç¬¬6å¼¾ã«ãªã‚Šã¾ã™ã€‚ä»Šå›žã¯ãƒ†ãƒˆãƒªã‚¹ã‚’å†ç¾ã—ã¦ã¿ã¾ã—ãŸã€‚å˜ç´”ãªä»•æ§˜ã§ã¯ã‚ã‚Šã¾ã™ãŒæ£ç›´ãƒ‰ãƒ©ã‚¯ã‚¨ã‚ˆã‚Šã‚‚é›£ã—ã‹ã£ãŸã§ã™ã€‚ ã“ã‚“ãªã®ã§ãã¾ã—ãŸ VBAã‚’ä½¿ã‚ãªã„Excel ã‚²ãƒ¼ãƒ ç¬¬6å¼¾ã€ãƒ†ãƒˆãƒªã‚¹ãŒã§ãã¾ã—ãŸã€‚ ãƒ‰ãƒ©ã‚¯ã‚¨ã§èª²é¡Œã¨ãªã£ã¦ã„ãŸã€Œã‚ˆãåˆ†ã‹ã‚‰ãªã„ãŒãªãœã‹å‹•ãã€ã‚’è§£æ±ºã—ã€å‡¦ç†é€Ÿåº¦ãŒé…ããªã‚‹åŽŸå› ã¨å¯¾ç–ã‚’è¦‹ã¤ã‘ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã—ãŸã€‚ å®Ÿè£…æ–¹æ³•ã‚„ãƒ•ã‚¡ã‚¤ãƒ«ã¯å¾Œæ—¥ãƒ–ãƒã‚°ã§å…¬é–‹ã—ã¾ã™ã€‚#Excel #NoVBA #ãƒ†ãƒˆãƒªã‚¹ #Tetris pic.twitter.com/GvV5u5JnCD â€” ãƒ‘ãƒ‘ã‚»ãƒ³ã‚»ã‚¤@Excelã§éŠã¶äºº (@10mikiya) January 12, 2021 ã™ãã«ã‚²ãƒ¼ãƒ ãŒå§‹ã¾ã‚Šã€ãƒœã‚¿ãƒ³æ“ä½œã§ãƒŸãƒŽã‚’æ“ä½œã—ã¦ãƒ†ãƒˆãƒªã‚¹ãŒéŠã¹ã¾ã™ã€‚ä¸Šã¾ã§ãƒŸãƒŽãŒç©ã¿ä¸ŠãŒã‚‹ã¨ã‚²ãƒ¼ãƒ ã‚ªãƒ¼ãƒãƒ¼ã«ãªã£ã¦ã€RESETã™ã‚‹ã“ã¨ã§å†ã‚¹ã‚¿ãƒ¼ãƒˆã™ã‚‹ä»•æ§˜ã§ã™ã€‚ [ad01] ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å…¬é–‹ã—ã¾
tyamamoto 2023/05/29
vba

excel
ãƒªãƒ³ã‚¯
Excelã§â€œVBAã‚’ä½¿ã‚ãšâ€ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆIIIã€ã‚’å†ç¾ã™ã‚‹çŒ›è€…ãŒç¾ã‚‹
Excelã§â€œVBAã‚’ä½¿ã‚ãšâ€ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆIIIã€ã‚’å†ç¾ã™ã‚‹çŒ›è€…ãŒç¾ã‚‹ ç·¨é›†éƒ¨ï¼šGueed è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã¨ã—ã¦ãŠé¦´æŸ“ã¿ã®Microsoft Excelã§ï¼ŒVBAï¼ˆVisual Basic for Applicationsï¼šMicrosoft Officeã‚·ãƒªãƒ¼ã‚ºã«æè¼‰ã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžï¼‰ã‚’ä½¿ã‚ãšã«ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆIIIã€ã‚’å†ç¾ã™ã‚‹çŒ›è€…ãŒç¾ã‚ŒãŸã¨è©±é¡Œã«ãªã£ã¦ã„ã‚‹ã€‚ ä½œè€…ã¯â€œæ–°æ½Ÿã§Excelã‚’çœºã‚ã‚‹ãŠä»•äº‹â€ã‚’ã—ã¦ã„ã‚‹ã¨ã„ã†ãƒ‘ãƒ‘ã‚»ãƒ³ã‚»ã‚¤æ°ã€‚Twitterã§â€œVBAã‚’ä½¿ã‚ãªã„Excel ã‚²ãƒ¼ãƒ â€ã¨ã—ã¦ã©ã‚“ãªã‚²ãƒ¼ãƒ ã‚’ä½œã‚‹ã®ãŒã‚ˆã„ã®ã‹ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã‚’ã¨ã£ãŸã¨ã“ã‚ï¼Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆãŒæœ€ã‚‚å¤šã‹ã£ãŸã“ã¨ã‹ã‚‰ï¼Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆIIIã‚’å†ç¾ã™ã‚‹ã“ã¨ã«ãªã£ãŸãã†ã ã€‚ åˆã‚ã¦è³ªå•ç®±ã‚’ä½¿ã£ã¦ã¿ã¾ã™ã€‚ãªã‹ãªã‹æ±ºã‚ã‚‰ã‚Œãªãã¦â€¥â€¥ã€‚ VBAã‚’ä½¿ã‚ãªã„Excel ã‚²ãƒ¼ãƒ ã€ã©ã‚Œã‚’ä½œã‚‹ã®ãŒè‰¯ã•ãã†ã§ã™ã‹ï¼Ÿâ€” ãƒ‘ãƒ‘ã‚»ãƒ³ã‚»ã‚¤
tyamamoto 2023/05/29
vba

excel
ãƒªãƒ³ã‚¯
Excelã®VBAãƒžã‚¯ãƒãŒãƒ–ãƒãƒƒã‚¯ã•ã‚Œã¦è§£é™¤ã§ããªã„ï¼ ãƒ–ãƒãƒƒã‚¯ã®è§£é™¤æ–¹æ³•ã‚’è§£èª¬ï¼ã€ŒMicrosoft Officeã€ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¼·åŒ–ã«æˆ¸æƒ‘ã„ã®å£°ã€ã‚„ã˜ã†ã¾ã®æœã€‘
tyamamoto 2022/09/06
microsoft

Office

excel

vba

security
ãƒªãƒ³ã‚¯
ã€VBAãƒžã‚¯ãƒã€‘LANä¸Šã«ã‚ã‚‹ãƒžã‚¯ãƒæœ‰åŠ¹Excelãƒ•ã‚¡ã‚¤ãƒ«ãŒã€Œã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚½ãƒ¼ã‚¹ãŒä¿¡é ¼ã§ããªã„ãŸã‚ã€Microsoftã«ã‚ˆã‚Šãƒžã‚¯ãƒã®å®Ÿè¡ŒãŒãƒ–ãƒãƒƒã‚¯ã•ã‚Œã¾ã—ãŸã€ã¨è¡¨ç¤ºã•ã‚Œã‚‹ã‚‚ã®ã‚’ãªã‚“ã¨ã‹ã—ãŸä»¶
å…ˆæ—¥ã€NASã«ã‚ã‚‹ãƒžã‚¯ãƒæœ‰åŠ¹ãƒ–ãƒƒã‚¯ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã«ã¦ä»¥ä¸‹ã®è¡¨ç¤ºãŒå‡ºã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ã“ã®è¡¨ç¤ºã¯ã€ã©ã†ã‚„ã‚‰ã€ŒEmotetã€ã®æ„ŸæŸ“çˆ†ç™ºã«ã‚ˆã£ã¦Microsoftã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¼·åŒ–ã®ä¸€ç’°ã¨ã—ã¦è¡Œã‚ã‚Œã¦ãŠã‚Šã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦è¡Œã£ã¦ã„ã‚‹ã‚‰ã—ã„ã§ã™ã€‚
tyamamoto 2022/09/02
microsoft

excel

security

vba
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã®ãƒžã‚¯ãƒã¯ã€Office ã§æ—¢å®šã§ãƒ–ãƒãƒƒã‚¯ã•ã‚Œã¾ã™ - Microsoft 365 Apps
VBA ãƒžã‚¯ãƒã¯ã€æ‚ªæ„ã®ã‚ã‚‹ã‚¢ã‚¯ã‚¿ãƒ¼ãŒãƒžãƒ«ã‚¦ã‚§ã‚¢ã‚„ãƒ©ãƒ³ã‚µãƒ ã‚¦ã‚§ã‚¢ã‚’å±•é–‹ã™ã‚‹ãŸã‚ã®ä¸€èˆ¬çš„ãªæ–¹æ³•ã§ã™ã€‚ ãã®ãŸã‚ã€Office ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’å¼·åŒ–ã™ã‚‹ãŸã‚ã«ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ãƒ•ã‚¡ã‚¤ãƒ«å†…ã®ãƒžã‚¯ãƒã‚’ãƒ–ãƒãƒƒã‚¯ã™ã‚‹ã‚ˆã†ã« Office ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ—¢å®šã®å‹•ä½œã‚’å¤‰æ›´ã—ã¦ã„ã¾ã™ã€‚ ã“ã®å¤‰æ›´ã¯ã€ãƒžã‚¯ãƒã‚’å«ã‚€é›»åãƒ¡ãƒ¼ãƒ«ã®æ·»ä»˜ãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ“ä½œã™ã‚‹æ–¹æ³•ã«å½±éŸ¿ã—ã¾ã™ã€‚ ã“ã‚Œã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã“ã®ã‚ˆã†ãªãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã¨ã€æ¬¡ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ [ è©³ç´°æƒ…å ±] ãƒœã‚¿ãƒ³ã¯ã€ãƒžã‚¯ãƒã‚’ä½¿ç”¨ã—ãŸæ‚ªæ„ã®ã‚ã‚‹ã‚¢ã‚¯ã‚¿ãƒ¼ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ ãƒªã‚¹ã‚¯ã€ãƒ•ã‚£ãƒƒã‚·ãƒ³ã‚°ã‚„ãƒžãƒ«ã‚¦ã‚§ã‚¢ã‚’é˜²ããŸã‚ã®å®‰å…¨ãªãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã€ãŠã‚ˆã³ã“ã‚Œã‚‰ã®ãƒžã‚¯ãƒã‚’æœ‰åŠ¹ã«ã™ã‚‹æ–¹æ³• (å¿…è¦ãªå ´åˆ) ã®æ‰‹é †ã‚’å«ã‚€ ã‚¨ãƒ³ãƒ‰ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã‚¤ãƒ³ãƒ•ã‚©ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ¯ãƒ¼ã‚«ãƒ¼å‘ã‘ã®è¨˜äº‹ ã«ç§»å‹•ã—ã¾ã™ã€‚ å ´åˆã«ã‚ˆã£ã¦ã¯ã€ãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚¤ãƒ³ãƒˆãƒ©ãƒãƒƒãƒˆå†…ã®
tyamamoto 2022/09/02
vba

security

excel
ãƒªãƒ³ã‚¯
ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ä¸Šã®ãƒžã‚¯ãƒå…¥ã‚ŠExcelãŒå…¨åŠ›ã§ãƒ–ãƒãƒƒã‚¯ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã‚‰ã—ã„
ãƒªãƒ³ã‚¯ çª“ã®æœ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸVBAãƒžã‚¯ãƒã¯æ—¢å®šã§ãƒ–ãƒãƒƒã‚¯ã¸ ï½žã€ŒMicrosoft Officeã€æ”»æ’ƒã¸ã®å¯¾ç–ã‚’å¼·åŒ–ï¼è¦å‘Šã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãƒãƒ¼ã¯èµ¤è‰²ã¸å¤‰æ›´ã€ãƒœã‚¿ãƒ³ã ã‘ã§ã¯æœ‰åŠ¹åŒ–ä¸èƒ½ã« ç±³Microsoftã¯2æœˆ7æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰å…¥æ‰‹ã—ãŸVBAï¼ˆVisual Basic for Applicationsï¼‰ãƒžã‚¯ãƒã‚’æ—¢å®šã§ãƒ–ãƒãƒƒã‚¯ã™ã‚‹æ–¹é‡ã‚’æ˜Žã‚‰ã‹ã«ã—ãŸã€‚ã€ŒMicrosoft Officeã€ã‚’ç‹™ã†æ”»æ’ƒã‹ã‚‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä¿è·ã™ã‚‹ãŸã‚ã§ã‚ã‚‹ã¨ã„ã†ã€‚ 26 users 71 ãƒªãƒ³ã‚¯ çª“ã®æœ Microsoftã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸVBAãƒžã‚¯ãƒã‚’æ—¢å®šã§ãƒ–ãƒãƒƒã‚¯ã™ã‚‹æ–¹é‡ã‚’ä¸€æ™‚æ’¤å›žã‹ï¼ã€ŒMicrosoft 365 ç®¡ç†ã‚»ãƒ³ã‚¿ãƒ¼ã€ã§æœ€æ–°ãƒãƒ£ãƒãƒ«ã®ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã‚’é€šçŸ¥ ç±³Microsoftã¯7æœˆ7æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸVBAãƒžã‚¯ãƒã‚’æ—¢å®šã§ãƒ–ãƒãƒƒã‚¯ã™ã‚‹å¤‰æ›´ã‚’ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã—ã€ã€ŒMicrosoft O
tyamamoto 2022/09/02
microsoft

Office

vba

security
ãƒªãƒ³ã‚¯
AccessVBA32bitã‚’64bitã«å¤‰æ›ã™ã‚‹ã«ã¯ï¼ŸDLLãŒå‹•ã‹ãªã„ï¼
Accessã®æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ï¼ˆ32bitï¼‰ã§ä½œæˆã•ã‚ŒãŸVBAãƒžã‚¯ãƒã‚’æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Accessã‚„æœ€æ–°Windows OSï¼ˆ64bitï¼‰ã§å‹•ã‹ãã†ã—ã¦ã¿ãŸã¨ã“ã‚ã€ã‚ˆãã‚ã‹ã‚‰ãªã„ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¦ã—ã¾ã„å‹•ã‹ãªã„ï¼ã¨ã„ã£ãŸç¾è±¡ã«ç™ºç”Ÿã—ãŸã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ PCã®å…¥ã‚Œæ›¿ãˆã«ä¼´ã„Windowsã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’å¤‰ãˆãŸï¼ˆWindows7â†’Windows10ï¼‰ã‚‰ã€ä»Šã¾ã§ä½¿ãˆã¦ã„ãŸAccessãƒžã‚¯ãƒãŒå‹•ã‹ãªã„ï¼Accessã‚’ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã‚‰å‹•ã‹ãªã„ï¼32bitç‰ˆã®Accessã‹ã‚‰64bitç‰ˆã®Accessã«å¤‰ãˆãŸã‚‰å‹•ã‹ãªã„ï¼Accessã‹ã‚‰Access Runtimeã«å¤‰ãˆãŸã‚‰å‹•ã‹ãªã„ï¼
tyamamoto 2021/10/13
vba

access
ãƒªãƒ³ã‚¯
VBA - Invalid Procedure Call Error after 2019-08 Windows Update
Sudden â€œInvalid procedure call or argumentâ€ error in VBA by Philipp Stiefel, originally published August 15th, 2019, last updated September 2nd, 2019 Before we start, letâ€™s put things into perspective: â€œInvalid procedure call or argumentâ€ is a rather common error. If you encounter this error while writing new code, it is most likely an actual error in your code and not related to the topic of this
tyamamoto 2019/08/19
Windows 10

vb6

vba
ãƒªãƒ³ã‚¯
2019å¹´8æœˆWindows Updateå¾Œã€VBé–¢é€£æ»äº¡ã®ä»¶ã¾ã¨ã‚ | RelaxTools Addin for Excel 2010/2013/2016
ã€Œãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®å‘¼ã³å‡ºã—ã€ã¾ãŸã¯å¼•æ•°ãŒä¸æ£ã§ã™ã€‚ã€ã‹ã‚‰æ”¹é¡Œã—ã¾ã—ãŸã€‚ ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã‹ã‚‰ãƒ¤ãƒãƒ¡ãªæƒ…å ±ãŒæµã‚Œã¦ããŸã€‚ï¼˜æœˆï¼‘ï¼”æ—¥ã®Windows Update å¾Œã€VBé–¢é€£ãŒæ»äº¡ã™ã‚‹ã‚‰ã—ã„ã€‚ ã€ã‚¢ãƒ—ãƒ‡/10ã€‘ 2019å¹´8æœˆ14æ—¥ã®WindowsUpdateå¾Œã€VBé–¢é€£ãŒæ»äº¡ã€‚Windows10å…¨ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¦ : ãƒ‹ãƒƒãƒãªPCã‚²ãƒ¼ãƒžãƒ¼ã®ç’°å¢ƒæ§‹ç¯‰ https://t.co/uF1DU9EPzQ https://t.co/vFBC2LkQEY â€” ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯::Hotentry (@hatebu) August 15, 2019 å®Ÿã¯ã“ã®ç¾è±¡ã‚’ï¼˜æœˆï¼‘ï¼•æ—¥ã«ç¢ºèªã—ã¦ã„ãŸã€‚åŽŸå› ãŒã‚ã‹ã‚‰ãšãµã¦å¯ã—ã¾ã—ãŸãŒã€‚ å†ç¾ã‚½ãƒ¼ã‚¹ Option Explicit Sub SaigenTest() Call a Debug.Print "Success!" End Sub Private Sub a(Para
tyamamoto 2019/08/16
vb

vb6

vba

Windows 10
ãƒªãƒ³ã‚¯
ã€2017å¹´7æœˆç‰ˆã€‘ãƒãƒ¼ã‚¿ãƒ–ãƒ« ãƒ‡ãƒã‚¤ã‚¹ã‹ã‚‰ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹VBAãƒžã‚¯ãƒ | åˆå¿ƒè€…å‚™å¿˜éŒ²
mougã«ã‚ã£ãŸè³ªå•é–¢é€£ã®ãƒ¡ãƒ¢ã§ã™ã€‚ ãƒãƒ¼ã‚¿ãƒ–ãƒ« ãƒ‡ãƒã‚¤ã‚¹ã‹ã‚‰ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹æ‰‹æ®µã¨ã—ã¦ã€ã€ŒCopy/Move Files from Porta ble Deviceã€ã§ã¯Shellã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ â€» Copy/Move F... å…ˆæ—¥ã€ä¸Šè¨˜ãƒžã‚¯ãƒãŒWindows 10 Creators Updateç’°å¢ƒã§å‹•ä½œã—ãªããªã£ãŸã¨ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã„ãŸã ã„ãŸã®ã§ã€ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãç›´ã™ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã®ã‚³ãƒ¼ãƒ‰ã‚’å‚è€ƒã«ãƒ‡ã‚¸ã‚«ãƒ¡ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã„ã¾ã—ãŸãŒï¼ŒWindows10 1703ã€€Cretors updateã€€ã«ä¸Šã’ã¦ã‹ã‚‰ï¼ŒNamespaceã®éƒ¨åˆ†ãŒå‹•ã‹ããªããªã‚Šã¾ã—ãŸã€‚ Shell32.dllãŒï¼Œ2017/6/20ã®ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ã«ãªã£ã¦ãŠã‚Šï¼Œå·®ã—å¤‰ã‚ã£ãŸã“ã¨ãŒåŽŸå› ã¨æŽ¨æ¸¬ã—ã¾ã™ã€‚ è‰²ã€…ãƒˆãƒ©ã‚¤ã—ã¾ã—ãŸãŒï¼Œå›žé¿ç–ãŒãªãã¦å›°ã£ã¦ã„ã¾ã™ã€‚ Option Explicit Public S
tyamamoto 2018/08/06
android

c#

vba
ãƒªãƒ³ã‚¯
Excelã‹ã‚‰SQLiteã‚’ä½¿ã†æ–¹æ³• | Gabekore Garage
æ‰‹ã£å–ã‚Šæ—©ãçµè«–æ•™ãˆã‚ï¼ èƒ½æ›¸ãã¯ã‚¤ãƒ©ãƒãƒ¼ãƒ¼ãƒ¼ï¼ï¼ï¼ ã•ã£ã•ã¨æ•™ãˆã‚ï¼ï¼ï¼ ã¨ã„ã†ã‚»ãƒƒã‚«ãƒã•ã‚“ã¯ã€ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«â†“ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã >> ExcelToSQLite.zip â€»ãƒžã‚¯ãƒãŒå…¥ã£ã¦ã„ã¾ã™ã€‚ãƒ†ã‚¹ãƒˆã¯ã—ã¦ã„ãªã„ã®ã§ã€å‹•ã‹ã™å ´åˆã¯å„è‡ªã®è‡ªå·±è²¬ä»»ã§å‹•ã‹ã—ã¦ãã ã•ã„ã€‚ä½•ã‹å•é¡ŒãŒç™ºç”Ÿã—ã¦ã‚‚ä½œè€…ã¯ä¸€åˆ‡è²¬ä»»ã‚’è² ã„ã¾ã›ã‚“ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã‚‰â€¦ è§£å‡ã—ã‚„ãŒã‚Œã£ï¼ SQLiteForExcelã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã‚„ãŒã‚Œã£ï¼ SQLiteForExcelã‚’è§£å‡ã—ã‚„ãŒã‚Œã£ï¼ SQLiteForExcelã‹ã‚‰SQLite3_StdCall.dllã¨sqlite3.dllã‚’ã‚³ãƒ”ã‚Šã‚„ãŒã‚Œã£ï¼ SQLite3_StdCall.dllã¨sqlite3.dllã‚’ExcelToSQLite.xlsmã¨åŒã˜å ´æ‰€ã«ç½®ãã‚„ãŒã‚Œã£ï¼ ExcelToSQLite.xlsmã‚’èµ·å‹•ã—ã‚„ãŒã‚Œã£ï¼ å‹•ã‹ã—ã‚„ãŒã‚Œã£ï¼ VBAã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰
tyamamoto 2017/12/26
excel

SQLite

VBA
ãƒªãƒ³ã‚¯
VBAã§PDFãƒ•ã‚¡ã‚¤ãƒ«ã‚’çµåˆã™ã‚‹[Excelã®TIPS]
VBAã§PDFãƒ•ã‚¡ã‚¤ãƒ«ã‚’çµåˆã™ã‚‹æ–¹æ³•ã§ã™ã€‚å¤‰æ›å‡¦ç†ã«ã¯å€‹äººãƒ»æ³•äººå•ã‚ãšåˆ©ç”¨ã€å†é…å¸ƒå¯èƒ½ãªã€ŒPDFDesigner Toolsã€(ç„¡æ–™)ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ä»¥å¤–ã«ã‚‚ãƒ¯ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ãƒã‚¤ãƒ³ãƒˆãªã©ã§ã‚‚ä½¿ç”¨å¯èƒ½ã§ã™ã€‚ PDFDesigner Toolsã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ æœ€åˆã«ã€ŒPDFDesigner Toolsã€ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ PDFDesigner Tools http://papy.world.coocan.jp/pdftool/ å·¦ä¸Šã«ã‚ã‚‹ã€Œpdftool.zipã€ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦å±•é–‹ã™ã‚‹ã¨ã€Œpdftool.dllã€ãŒä½œæˆã•ã‚Œã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã‚’èµ·å‹•ã—ã¦ã€Œãƒžã‚¯ãƒæœ‰åŠ¹ãƒ•ã‚¡ã‚¤ãƒ«ã€ã‚’ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ãªã©ã«ä½œæˆã—ã¾ã™ã€‚ãã®ãƒžã‚¯ãƒæœ‰åŠ¹ãƒ•ã‚¡ã‚¤ãƒ«ã¨åŒã˜ãƒ•ã‚©ãƒ«ãƒ€ã«ã€Œpdftool.dllã€ã‚’ç§»å‹•ã—ã¾ã™ã€‚ æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« æ¬¡ã«VBAã§ã€Œæ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã€ã‚’è¿½åŠ ã—ã¦ã€Œpdftool.dllã€ã®APIã‚’å®£è¨€ã—ã¾
tyamamoto 2016/08/03
vba

excel
ãƒªãƒ³ã‚¯
C#ã§VBAå‘ã‘ã®.NETãƒ©ã‚¤ãƒ–ãƒ©ãƒªï¼ˆCOMã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆï¼‰ã‚’ä½œæˆã™ã‚‹ã«ã¯ï¼Ÿ - ï¼ IT
.NET TIPS C#ã§VBAå‘ã‘ã®.NETãƒ©ã‚¤ãƒ–ãƒ©ãƒªï¼ˆCOMã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆï¼‰ã‚’ä½œæˆã™ã‚‹ã«ã¯ï¼Ÿï¼»C#ï¼½ ãƒ‡ã‚¸ã‚¿ãƒ«ã‚¢ãƒ‰ãƒãƒ³ãƒ†ãƒ¼ã‚¸ã€€ä¸€è‰² æ”¿å½¦ 2011/10/06 ã€ŒTIPSï¼šVBAã§ç‹¬è‡ªã®.NETãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã†ã«ã¯ï¼Ÿã€ã§ã¯ã€Microsoft Officeè£½å“ï¼ˆWordã‚„Excelãªã©ï¼‰ã«ç‹¬è‡ªã®å‡¦ç†ã‚’è¿½åŠ ã™ã‚‹ãŸã‚ã®VBAï¼ˆVisual Basic for Applicationsï¼‰ãƒžã‚¯ãƒã§ã€.NET Frameworkã§ä½œæˆã—ãŸç‹¬è‡ªã®ã‚¯ãƒ©ã‚¹ã‚’æ´»ç”¨ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ãŸã€‚ãã“ã§ã¯ã€VBAã¨è¦ªå’Œæ€§ãŒé«˜ã„VBï¼ˆVisual Basicï¼‰ã‚’ä½¿ã£ã¦VBAå‘ã‘ã®.NETãƒ©ã‚¤ãƒ–ãƒ©ãƒªï¼ˆï¼COMã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆï¼‰ã‚’ä½œæˆã—ãŸãŒã€ã‚‚ã¡ã‚ã‚“ã“ã®ã¨ãã«C#ã‚’ä½¿ã†ã“ã¨ã‚‚ã§ãã‚‹ã€‚æœ¬ç¨¿ã§ã¯ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ â—C#ã«ã‚ˆã‚‹VBAå‘ã‘ã®.NETãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ä½œæˆ æœ€åˆã«ã€VBAå‘ã‘ã«.NETã®ã‚¯ãƒ©ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½œæˆã—ã‚ˆã†ã€‚
tyamamoto 2016/02/23
.net

c#

vba

excel
ãƒªãƒ³ã‚¯
Excel 2016ã§UTF-8ã®CSVãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ | åˆå¿ƒè€…å‚™å¿˜éŒ²
ä»¥å‰æ›¸ã„ãŸè¨˜äº‹ã§SharpDevelopã‚’ä½¿ã£ã¦Excelç”¨ã®COMã‚¢ãƒ‰ã‚¤ãƒ³ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã—ãŸãŒã€æœ€è¿‘ã®Windows PCã«ã¯æ¨™æº–ã§C#ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãŒå…¥ã£ã¦ã„ã‚‹ã®ã§(ç’°å¢ƒã«ã‚ˆã£ã¦ã¯å…¥ã£ã¦ã„ã¾ã›ã‚“ãŒã€ã“ã“ã§ã¯ãã†ã„ã£ãŸç’°å¢ƒã¯æ¨ªã«ç½®ã„ã¦ãŠãã¾ã™)ã€ã‚ã–ã‚ã–é‡ã„IDEã‚’ä½¿ã‚ãªãã¦ã‚‚ã€ãƒ¡ãƒ¢å¸³ãªã©ã®è»½ã„ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã ã‘ã§ã€VBAã‹ã‚‰æ‰±ãˆã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªDLLã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ C#ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©(csc.exe)ã®å ´æ‰€ C#ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã®å®Ÿä½“ã¯ã€Œcsc.exeã€ã§ã€ç§ã®ç’°å¢ƒ(Windows 7 32ãƒ“ãƒƒãƒˆç‰ˆ)ã ã¨ä¸‹è¨˜ãƒ•ã‚©ãƒ«ãƒ€ã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã‚Šã¾ã—ãŸã€‚ C:\Windows\Microsoft.NET\Framework\v2.0.50727 C:\Windows\Microsoft.NET\Framework\v3.5 C:\Windows\Microsoft.NET\Fram
tyamamoto 2016/02/23
c#

vba

.NET

excel
ãƒªãƒ³ã‚¯
WinHTTP ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ Web ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°(3)ã€œè§£æžç·¨ã€œ
å®Ÿéš›ã«ã¯ã‚‚ã£ã¨ç´°ã‹ã„æƒ…å ±ã¾ã§å¿…è¦ã¨ã™ã‚‹çŠ¶æ³ã‚‚ã‚ã‚‹ã§ã—ã‚‡ã†ãŒã€ä»Šå›žã¯ã‚ãã¾ã§ãƒ‡ãƒ¢ã‚±ãƒ¼ã‚¹ãªã®ã§ã€ã“ã®ã¦ã„ã©ã«ã—ã¦ãŠãã¾ã™ã€‚ ã©ã®ã¿ã¡ã€æƒ…å ±ã®å–å¾—ã¯å˜èª¿ãªç¹°ã‚Šè¿”ã—ã§ã€å¯¾è±¡è¦ç´ ãŒå¤‰ã‚ã£ã¦ã‚‚ã‚„ã‚Šæ–¹ã¯ãã‚Œã»ã©å¤‰ã‚ã‚Šã¾ã›ã‚“ã€‚ æœ¬ãƒˆãƒ”ãƒƒã‚¯ã‚’èªã¿çµ‚ãˆã‚‹ã“ã‚ã«ã¯ã€ã©ã‚“ãªè¦ç´ ã§ã‚‚è‡ªåœ¨ã«å–ã‚Šå‡ºã›ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ æ£è¦è¡¨ç¾ æ£è¦è¡¨ç¾ã¨ã¯ã€ä¸€å®šã®è¦å‰‡ã«å¾“ã£ãŸãƒ‘ã‚¿ãƒ¼ãƒ³æ–‡å—åˆ—ã‚’èªè˜ã™ã‚‹ãŸã‚ã®æŠ€è¡“ã§ã™ã€‚ ãƒ‘ã‚¿ãƒ¼ãƒ³ã®å®šç¾©ã«ã¯ãƒ¡ã‚¿æ–‡å—ã¨å‘¼ã°ã‚Œã‚‹ç‰¹æ®Šãªæ„å‘³ã‚’æŒã¤æ–‡å—ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ æ¦‚å¿µçš„ã«ã¯ VBA ã® Like æ¼”ç®—åã‚’æ€ã„æµ®ã‹ã¹ã‚‹ã¨ç†è§£ã—ã‚„ã™ã„ã§ã—ã‚‡ã†ã€‚ Like æ¼”ç®—åã«ã‚‚ã„ãã¤ã‹ãƒ¡ã‚¿æ–‡å—ãŒå˜åœ¨ã—ã¾ã™ã€‚ãŸã¨ãˆã°ãƒ¡ã‚¿æ–‡å— "*" ã¯ã€0 å€‹ä»¥ä¸Šã®ä»»æ„ã®æ–‡å—ã‚’æ„å‘³ã—ã¾ã™ã€‚ æ£è¦è¡¨ç¾ã®ãƒ¡ã‚¿æ–‡å—ã¯ã€Like æ¼”ç®—åã®ãã‚Œã¨ã¯å°‘ã—æ„å‘³ãŒç•°ãªã‚Šã¾ã™ãŒã€å¤§é›‘æŠŠã«è¨€ãˆã° Like æ¼”ç®—åã‚’å¼·åŠ›ã«æ‹¡å¼µã—ãŸã‚‚ã®ãŒæ£è¦è¡¨ç¾ï¼ˆã‚ã‚‹
tyamamoto 2015/05/21
ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°

.net

vb

vba
ãƒªãƒ³ã‚¯
WinHTTP ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ Web ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°(2)ã€œ POST ç·¨ã€œ
æ¦‚è¦ å‰å›žã¾ã§ã®ã‚ã‚‰ã™ã˜ JRA ã®ã‚µã‚¤ãƒˆã‹ã‚‰å‡ºé¦¬è¡¨ã‚’ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã™ã‚‹ã€ã¨ã„ã†ç›®æ¨™ã‚’æŽ²ã’ãŸã‚‚ã®ã®ã€è‚å¿ƒã®å‡ºé¦¬è¡¨ãƒšãƒ¼ã‚¸ã‚’ GET ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚¨ãƒ©ãƒ¼ã«ãªã£ã¦ã—ã¾ã†ã“ã¨ãŒåˆ¤æ˜Žã€‚ URL ã‚’ç¢ºèªã—ãŸã¨ã“ã‚ã€åˆ¥ã€…ã®ãƒšãƒ¼ã‚¸ã«è¦‹ãˆãŸã‚‚ã®ãŒã¾ã£ãŸãåŒä¸€ã® URL ã«ãªã£ã¦ã„ã¾ã—ãŸã¨ã•ã€‚ ã€Œå‡ºé¦¬è¡¨ é–‹å‚¬é¸æŠžã€ç”»é¢ ã€Œå‡ºé¦¬è¡¨ ãƒ¬ãƒ¼ã‚¹é¸æŠžã€ç”»é¢ ã€Œå‡ºèµ°é¦¬ä¸€è¦§ã€ç”»é¢ ã•ã¦ã€ã“ã†ã„ã†å ´åˆã¯ã©ã†ã—ã¾ã—ã‚‡ã†ï¼Ÿ åŸºæœ¬ ã“ã“ã§ HTTP ãƒ—ãƒãƒˆã‚³ãƒ«ã«ã¤ã„ã¦ã€åŸºæœ¬ã‚’ãŠã•ã‚‰ã„ã—ã¦ãŠãã¾ã™ã€‚ HTTP ãƒ—ãƒãƒˆã‚³ãƒ«ã¯ã„ãã¤ã‹ã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ ãã®ã†ã¡æœ€ã‚‚ãƒãƒ”ãƒ¥ãƒ©ãƒ¼ãªã®ã¯ GET ã¨ POST ã§ã—ã‚‡ã†ã€‚ GET ã¯ã‚µãƒ¼ãƒã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’è¦æ±‚ã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã§ã™ã€‚é™çš„ãª Web ãƒšãƒ¼ã‚¸ã®å–å¾—ã§ç”¨ã„ã‚‰ã‚Œã‚‹ã®ã¯ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€CGI ã«ã‚ˆã‚‹å‹•çš„ãªãƒšãƒ¼ã‚¸ã‚’ãƒªã‚¯ã‚¨ã‚¹ãƒˆã™ã‚‹å ´åˆã¯ã€ä¸€èˆ¬çš„ã« URI ã« QuerySt
tyamamoto 2015/05/21
ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°

.net

vb

vba
ãƒªãƒ³ã‚¯
WinHTTP ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ Web ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°(1)ï½ž GET ç·¨ï½ž
æ¦‚è¦ Web ã‹ã‚‰æƒ…å ±ã‚’å–å¾—ã—ãŸã„ã¨ã„ã†ãƒ‹ãƒ¼ã‚ºã¯ã€ã„ã¾ã‚„å½“ãŸã‚Šå‰ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚ å¯¾è±¡ã‚µã‚¤ãƒˆãŒ Web API ã‚’æä¾›ã—ã¦ã„ã‚‹å ´åˆã€è©±ã¯ç°¡å˜ã§ã™ã€‚ã—ã‹ã— Web API ã‚’æä¾›ã—ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã°ã‹ã‚Šã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã¨ã„ã†ã‚ˆã‚Šã€æ•°ã§è¨€ã†ãªã‚‰ Web API ã‚’æä¾›ã—ã¦ã„ãªã„ã‚µã‚¤ãƒˆã®æ–¹ãŒåœ§å€’çš„å¤šæ•°ã§ã™ã€‚ãã‚“ãªã‚µã‚¤ãƒˆã®ä¸ã«ã»ã—ã„æƒ…å ±ãŒã‚ã£ãŸå ´åˆã¯ã€å¦å¿œãªã Web ãƒšãƒ¼ã‚¸ã‚’ç›´æŽ¥å–å¾—ã—ã¦æƒ…å ±ã‚’è§£æžãƒ»æŠ½å‡ºã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ åŽŸå§‹çš„ã¨è¨€ã†ã‹åœ°é“ã¨è¨€ã†ã‹ã€ã¨ã«ã‹ãã“ã®ãƒ™ã‚¿ãªã‚„ã‚Šæ–¹ã‚’ç§°ã—ã¦ã€ŒWeb ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã€ï¼ˆæ–‡è„ˆã«ã‚ˆã£ã¦ã¯å˜ã«ã€Œã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã€ï¼‰ã¨å‘¼ã³ã¾ã™ï¼ˆæµ·å¤–ã§ã¯ Web harvesting ã¨å‘¼ã¶å ´åˆã‚‚å¤šã„ã§ã™ãŒã€ãªãœã‹æ—¥æœ¬ã§ã¯ã“ã£ã¡ã¯ã»ã¨ã‚“ã©ç”¨ã„ã‚‰ã‚Œãªã„ã‚ˆã†ã§ã™ï¼‰ã€‚ Access VBA ã§ Web ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’è¡Œã†æ–¹æ³•ã«ã¤ã„ã¦ã¯ã€æœ¬ã‚µã‚¤ãƒˆã«ã™ã§ã«é–¢é€£ãƒˆãƒ”ãƒƒã‚¯ãŒäºŒã¤å˜åœ¨ã—ã¾ã™ã€‚ W
tyamamoto 2015/05/21
ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°

.net

vb

vba
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
tyamamoto 2012/01/30
excel

vba
ãƒªãƒ³ã‚¯
VBScriptã‚’å®Ÿè¡Œãƒ•ã‚¡ã‚¤ãƒ«ã«å¤‰æ›ã™ã‚‹@IExpress
Windows XPã«å…ƒã€…æè¼‰ã•ã‚Œã¦ã„ã‚‹IExpress.exeã‹ã‚‰VBScriptã‚’å®Ÿè¡Œãƒ•ã‚¡ã‚¤ãƒ«ã«å¤‰æ›ã™ã‚‹æ–¹æ³•ãŒè¼‰ã£ã¦ã„ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ã‚¹ã‚¿ãƒ¼ãƒˆâ†’ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šã—ã¦å®Ÿè¡Œ ã« IExpress ã¨å…¥åŠ›ã—ã¦OKã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ Create new SelfExtraction Directive file. ã‚’é¸æŠžã—ã¦ æ¬¡ã¸ ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ Extract Files and run an installation command ã‚’é¸æŠžã—ã¦ æ¬¡ã¸ ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã‚’èžã‹ã‚Œã‚‹ã®ã§é©å½“ãªåå‰ã‚’å…¥åŠ›ã—ã¦ æ¬¡ã¸ ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ No Prompt ã‚’é¸æŠžã—ã¦ãã ã•ã„ã€‚ Do not display a license. ã‚’é¸æŠžã—ã¦ãã ã•ã„ã€‚ å®Ÿè¡Œã•ã›ãŸã„VBScriptã‹BATãƒ•ã‚¡ã‚¤ãƒ«ã‚’ Add ãƒœã‚¿ãƒ³ã§è¿½åŠ ã—ã¦èªã¿è¾¼ã¿ã¾ã™ã€‚ â€»VBScriptã‚’å®Ÿ
tyamamoto 2011/08/23
wsh

vba

JScript
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸