[B! VBA][excel] decoy2004ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

decoy2004 id:decoy2004

VBAã¨excelã«é–¢ã™ã‚‹decoy2004ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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}}

vbaDeveloper - Excel VBAã®ã‚³ãƒ¼ãƒ‰ã‚’ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã™ã‚‹
ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã§ã‚ã‚Œã°èª°ã‚‚ãŒã‚³ãƒ¼ãƒ‰ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã«ç™»éŒ²ã—ã¦ãŠããŸã„ã¨æ€ã†ã‚‚ã®ã§ã—ã‚‡ã†ã€‚ä½•ã‹ã‚ã£ãŸæ™‚ã«å·®ã—æˆ»ã›ã¾ã™ã—ã€å¤‰æ›´ã®ç¢ºèªã«ã‚‚ä½¿ãˆã¾ã™ã€‚ä¸€äººã¯ã‚‚ã¡ã‚ã‚“ã€è¤‡æ•°äººã§ã®é–‹ç™ºã¨ã‚‚ãªã‚Œã°å¿…é ˆã®ä»•çµ„ã¿ã§ã™ã€‚ ã—ã‹ã—VBAï¼ˆExcelï¼‰ã§ã¯ãã®ã‚ˆã†ãªãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã®ä»•çµ„ã¿ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ä½¿ã„ãŸã„ã®ãŒvbaDeveloperã§ã™ã€‚ vbaDeveloperã®ä½¿ã„æ–¹ vbaDeveloperã¯åŒã˜VBAã§ã§ãã¦ãŠã‚Šã€è‹¥å¹²ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒé¢å€’ãªã‚‚ã®ã®ã€ãã‚ŒãŒçµ‚ã‚ã‚Œã°é–¢æ•°ã‚’å®Ÿè¡Œã™ã‚‹ã ã‘ã§ã™ã€‚å®Ÿè¡Œå¾Œã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆå…¨ä½“ãŒä¸€ã¤ãšã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã•ã‚Œã¾ã™ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ãŒå‡ºåŠ›ã•ã‚Œã¦ã—ã¾ãˆã°ã€å¾Œã¯ä»»æ„ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã§ã‚³ãƒŸãƒƒãƒˆã™ã‚Œã°OKã§ã™ã€‚è‡ªå‹•åŒ–ã•ã‚Œã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€Git/Mercurial/Subversion/CVSãªã©ã‚·ã‚¹ãƒ†ãƒ ã®é¸æŠžè‚¢ã¯å¤šã„ã®ãŒä¾¿åˆ©ãã†ã§ã™ã€‚ vbaDevelop
decoy2004 2016/08/06
Excel

VBA

git
ãƒªãƒ³ã‚¯
æ˜¨æ—¥ã¾ã§JavaJavaã—ã¦ãŸäººãŒã„ããªã‚ŠExcelã®VBAã‚’å®Ÿè£…ã™ã‚‹ç¾½ç›®ã«ãªã£ãŸã¨ãã®ãŸã‚ã®ãƒ¡ãƒ¢ - Qiita
Excel ã¯æ»…ã³ã¬ï¼ Excel ã®åŠ›ã“ãæ—¥æœ¬ä¼æ¥ã®å¤¢ã ã‹ã‚‰ã ï¼ VBA å®Ÿè£…ã—ã¦ã¦å¦ã‚“ã ã“ã¨ã¨ã‹ã®ãƒ¡ãƒ¢ã€‚ Java Java ã—ã¦ãŸã‹ã¯ã‚ã¾ã‚Šé–¢ä¿‚ãªã„ã‹ã‚‚ã€‚ #ã‚¨ãƒ‡ã‚£ã‚¿ã®ä½¿ã„æ–¹ ##ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã™ã‚‹ Alt + F11 ã§ VB ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ ##ç’°å¢ƒè¨å®š ###èƒŒæ™¯è‰²ãƒ»ãƒ•ã‚©ãƒ³ãƒˆã‚’èª¿æ•´ã™ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ç™½èƒŒæ™¯ã¨ã‹æ°—ãŒç‹‚ã†ã®ã§ã€æš—ã„è‰²ã«ã™ã‚‹ã€‚ ã€Œãƒ„ãƒ¼ãƒ«ã€â†’ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚’é¸æŠžã—ã€ã€Œã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã®è¨å®šã€ã‚¿ãƒ–ã‚’é–‹ãã€‚ ã€Œã‚³ãƒ¼ãƒ‰ã®è¡¨ç¤ºè‰²ã€ã‚’é¸æŠžã—ã¦ã€ã€ŒèƒŒæ™¯ã€ã®è‰²ã‚’é¸æŠžã™ã‚‹ã€‚ ã¤ã„ã§ã«ãƒ•ã‚©ãƒ³ãƒˆã‚‚è¦‹ã‚„ã™ã„ã‚„ã¤ã«å¤‰æ›´ã™ã‚‹ã€‚ ã“ã‚Œã ã‘ã§é–‹ç™ºåŠ¹çŽ‡ãŒï¼•å‰²å¢—ã—ã«ãªã‚‹ã€‚ ###ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ ####ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚’è¡¨ç¤ºã™ã‚‹ ã„ã‚ã‚†ã‚‹ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã«å½“ãŸã‚‹ã®ãŒã€__ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦__ã¨å‘¼ã°ã‚Œã‚‹ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã€‚ Ctrl + G ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ ####ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«å‡º
decoy2004 2016/05/05
excel

VBA
ãƒªãƒ³ã‚¯
vbacã§ã‚¨ã‚¯ã‚»ãƒ«VBAã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’Gitãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã™ã‚‹æ–¹æ³•
ã¿ãªã•ã‚“ã€ã“ã‚“ã«ã¡ã¯ï¼ ãã‚ãã‚ãƒãƒ¼ãƒ ãƒ—ãƒ¬ã‚¤ã‚‚è©¦ã—ãŸã„ã‚¿ã‚«ãƒã‚·(@ntakahashi0505)ã§ã™ã€‚ ä»¥å‰ã“ã‚Œã‚‰ã®è¨˜äº‹ã§éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®åˆå¿ƒè€…å‘ã‘Gitãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã‚„ã€Gitãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã«ä¾¿åˆ©ãªSource Treeã®ä½¿ã„æ–¹ã«ã¤ã„ã¦ãŠä¼ãˆã—ã¦ãã¾ã—ãŸã€‚
decoy2004 2015/11/17
Excel

VBA
ãƒªãƒ³ã‚¯
xlwingsÂ·ã•ã‚ˆãªã‚‰VBAã€‚Pythonã¨Excelã®ç›¸äº’ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ©ã‚¤ãƒ–ãƒ©ãƒª MOONGIFT
Webã‚¢ãƒ—ãƒªå…¨ç››ã®ç¾åœ¨ã¨ã‚ã£ã¦ã‚‚ã€æ¥å‹™ã§ã¯æœªã ã«ExcelãŒå¤šãä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ãã®çµæžœã¨ã—ã¦VBAãŒæ´»èºã—ã¦ãŠã‚Šã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒé›£ã—ã‹ã£ãŸã‚Šã€ã‚³ãƒ”ãƒšã•ã‚Œã‚‹ã‚³ãƒ¼ãƒ‰ãŒé‡ç”£ã•ã‚Œã¦ã„ãŸã‚Šã—ã¾ã™ã€‚VBAãŒãƒ€ãƒ¡ã¨ã„ã†è¨³ã§ã¯ãªã„ã®ã§ã™ãŒã€è§¦ã‚ŠãŸããªã„ã¨è€ƒãˆã‚‹ãƒ—ãƒã‚°ãƒ©ãƒžã¯å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ã‚‚ã£ã¨è‡ªåˆ†ãŒä½¿ã„æ…£ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§Excelã‚’æ‰±ã„ãŸã„ã¨è€ƒãˆã‚‹äººã«ä½¿ã£ã¦ã¿ã¦ã„ãŸã ããŸã„ã®ãŒxlwingsã§ã™ã€‚Pythonã¨Excelã§åŒæ–¹å‘ã®æ“ä½œãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ xlwingsã®ä½¿ã„æ–¹ ãƒ‡ãƒ¢ã€‚Excelã‹ã‚‰Pythonã‚’å‘¼ã³å‡ºã—ã¾ã™ã€‚ xlwingsã¯Pythonã‹ã‚‰Excelã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚“ã ã‚Šã€Excelã‹ã‚‰Pythonã‚’ã‚³ãƒ¼ãƒ«ã§ãã¾ã™ã€‚ãã®çµæžœã€Pythonã‹ã‚‰Excelã«ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸã‚Šã€æ¤œç´¢çµæžœã‚’è¡¨ç¤ºã•ã›ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚VBAã®ä»£ã‚ã‚Šã«ä½¿ã†ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ Pythonã§ã‚ã‚Œã°
decoy2004 2014/10/12
ã€Žxlwingsã¯Pythonã‹ã‚‰Excelã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚“ã ã‚Šã€Excelã‹ã‚‰Pythonã‚’ã‚³ãƒ¼ãƒ«ã§ãã¾ã™ã€‚ãã®çµæžœã€Pythonã‹ã‚‰Excelã«ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸã‚Šã€æ¤œç´¢çµæžœã‚’è¡¨ç¤ºã•ã›ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€

excel

VBA

python
ãƒªãƒ³ã‚¯
ã‚¹ã‚¯ã‚·ãƒ§ã‚’Excelã«å¼µã‚Šä»˜ã‘ã‚‹ã®ã«å½¹ç«‹ã¤4ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
ã‚¹ã‚¯ã‚·ãƒ§ã‚’Excelã«å¼µã‚Šä»˜ã‘ã‚‹ã®ã«å½¹ç«‹ã¤4ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼šãƒ†ã‚¹ãƒˆã‚¨ãƒ“ãƒ‡ãƒ³ã‚¹å–å¾—è‡ªå‹•åŒ–ã®ç§˜æŠ€ï¼ˆå¾Œç·¨ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«ãŠã‘ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ†ã‚¹ãƒˆï¼ˆçµåˆãƒ†ã‚¹ãƒˆï½žã‚·ã‚¹ãƒ†ãƒ ãƒ†ã‚¹ãƒˆï¼‰ã«ãŠã„ã¦é‡è¦è¦–ã•ã‚Œã‚‹ã‚¨ãƒ“ãƒ‡ãƒ³ã‚¹ï¼ˆä½œæ¥è¨˜éŒ²ï¼‰ã€‚å‰å¾Œç·¨ã®2å›žã«ã‚ãŸã£ã¦ã€ã‚¨ãƒ“ãƒ‡ãƒ³ã‚¹ã¨ã—ã¦ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆã‚’ã‚ãƒ£ãƒ—ãƒãƒ£ã—ã€ãƒ†ã‚¹ãƒˆä»•æ§˜æ›¸ã‚„ç´å“æ›¸ã«å¼µã‚Šä»˜ã‘ã¦ã„ãä½œæ¥ã‚’è‡ªå‹•åŒ–ã™ã‚‹ãŸã‚ã®VBAï¼ãƒžã‚¯ãƒã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚å¾Œç·¨ã¯ã€ç”»åƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚·ãƒ¼ãƒˆã«å¼µã‚Šä»˜ã‘ã€Excel 2013ã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã‚¹ã‚¯ã‚·ãƒ§ã‚’ç›´ã«å¼µã‚Šä»˜ã‘ã€ç”»åƒã‚’ç¸®å°ã—ã€æŒ‡å®šã—ãŸæ™‚é–“ã«ãƒžã‚¯ãƒã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã€‚ å‰ç·¨ã€ŒSelenium VBAã‚’ä½¿ã£ã¦è‡ªå‹•ã§ãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ã‚’æ“ä½œã—ã¦ã‚¹ã‚¯ã‚·ãƒ§ã‚’Excelã«å¼µã‚Šä»˜ã‘ã¦ã¿ãŸã€ã§ã¯ã€ã‚¨ãƒ“ãƒ‡ãƒ³ã‚¹ã¨ã—ã¦ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆï¼ˆä»¥ä¸‹ã€ã‚¹ã‚¯ã‚·ãƒ§ï¼‰ã‚’æ’®ã‚‹æ„ç¾©ã‚„ã€Selenium VBAã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã¨ä½¿ã„æ–¹ã€ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒ
decoy2004 2014/08/27
ã€Žç”»åƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«å¼µã‚Šä»˜ã‘ã‚‹Pictures.Insertãƒ¡ã‚½ãƒƒãƒ‰ã€

VBA

excel

ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆ

è‡ªå‹•åŒ–
ãƒªãƒ³ã‚¯
Excel ã‹ã‚‰ Redmine ã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹æ–¹æ³• - åœ°å¹³ç·šã«è¡Œã
Excel ãƒžã‚¯ãƒ(VBA)ã§ Redmine ã®æƒ…å ±ã‚’å–å¾—ã—ã¦ã€è¡¨ã«ã¾ã¨ã‚ã‚‹æ–¹æ³•ã‚’è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ ã‚ˆãã‚ã‚‹ã‹ã‚‚ã—ã‚Œãªã„è³ªå• Q. ãªã‚“ã§ Excel ã§ã‚„ã‚ã†ã¨æ€ã£ãŸï¼Ÿ A. ãã“ã« Excel ãŒã‚ã£ãŸã‹ã‚‰ã€‚ æ‰‹ã£å–ã‚Šæ—©ãè©¦ã—ã¦ã¿ãŸã„æ–¹ ã‚µãƒ³ãƒ—ãƒ«ã‚’ç½®ã„ã¦ãŠã„ãŸã®ã§ã€ã“ã¡ã‚‰ã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚ http://hp.vector.co.jp/authors/VA049605/etc/redmine.xls ã¾ãŸã€ã‚³ãƒ¼ãƒ‰ã¯ GitHub Gist ã«ã‚‚ç½®ã„ã¦ã„ã¾ã™ã€‚ https://gist.github.com/YujiSoftware/5429273 ã‚µãƒ³ãƒ—ãƒ«å®Ÿè¡Œæ‰‹é † ãƒžã‚¯ãƒã® Module1 â†’ API ã¨ã„ã†å¤‰æ•°ã‚’ã€ã”åˆ©ç”¨ã® Redmine ã® URL ã«æ›¸ãæ›ãˆã¦ä¸‹ã•ã„ã€‚ Redmine ã®è¨å®šã§APIã‚¢ã‚¯ã‚»ã‚¹ã‚ãƒ¼ãŒå¿…è¦ã«ãªã£ã¦ã„ã‚‹å ´åˆã¯ã€ä»¥ä¸‹ã® URL ã‚’å‚è€ƒã« API ã‚¢ã‚¯ã‚»ã‚¹
decoy2004 2014/08/01
ã€ŽRedmine ã‹ã‚‰ REST API ã¨ã„ã†æ©Ÿèƒ½ã§æƒ…å ±ã‚’å–å¾—ã—ã¦ã„ã¾ã™ã€‚ã€

redmine

api

REST

VBA

excel
ãƒªãƒ³ã‚¯
1