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

kokemono id:kokemono

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

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

ï¼»VBAä¾¿åˆ©æŠ€ï¼½Excelã®ãƒªã‚¹ãƒˆã«å¾“ã£ã¦ãƒ¡ãƒ¼ãƒ«ã‚’ä¸€æ–‰é€ä¿¡
Excelã§ç®¡ç†ã—ã¦ã„ã‚‹é¡§å®¢ã®é€£çµ¡å…ˆã‚„ã‚µãƒ¼ã‚¯ãƒ«ã®ãƒ¡ãƒ³ãƒãƒ¼æƒ…å ±ã‚’åŸºã«ã€ãƒ¡ãƒ¼ãƒ«ã‚’é…ä¿¡ã§ãã‚Œã°ä¾¿åˆ©ã ã¨æ€ã„ã¾ã›ã‚“ã‹ã€‚ãƒ¡ãƒ¼ãƒ«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§é…ä¿¡ã‚°ãƒ«ãƒ¼ãƒ—ã‚’å®šç¾©ã—ãŸã‚Šã€å°‚ç”¨ã®ãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ãŸã‚Šã—ãªãã¦ã‚‚ã€ãƒžã‚¯ãƒã‚’ä½œæˆã™ã‚Œã°ã€Excelä¸Šã‹ã‚‰ãã®ã¾ã¾ãƒ¡ãƒ¼ãƒ«ã‚’é…ä¿¡ã§ãã¾ã™ã€‚ä¸€éƒ¨ã®äººã ã‘é…ä¿¡å…ˆã‹ã‚‰é™¤å¤–ã—ãŸã„ã¨ã„ã†å ´åˆã‚‚ã€Excelä¸Šã§ã€Œâ—‹ã€ã€ŒÃ—ã€ã®ãƒ•ãƒ©ã‚°ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹ã ã‘ã§ç°¡å˜ã«å¯¾å¿œã§ãã¾ã™ï¼ˆå›³1ï¼‰ã€‚ Basp21ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã“ã§ã¯ã€é¦¬å ´é”å¤«æ°ãŒé–‹ç™ºã—ãŸãƒ•ãƒªãƒ¼ã‚¦ã‚¨ã‚¢ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã€ŒBasp21ã€ã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Basp21ã¯ã€ãƒ¡ãƒ¼ãƒ«é€ä¿¡ã‚’ã¯ã˜ã‚ã€ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã€æ–‡å—ã‚³ãƒ¼ãƒ‰å¤‰æ›ãªã©ã€ã‹ã‚†ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šãã•ã¾ã–ã¾ãªæ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã€åŒæ°ã®Webã‚µã‚¤ãƒˆï¼ˆhttp://www.hi-ho.ne.jp/babaq/basp21.htmlï¼‰ã‹ã‚‰ã€ŒBASP2
kokemono 2014/04/08
Excel

VBA
ãƒªãƒ³ã‚¯
ã€ç‰¹é›†ã€‘Excel VBAã§IEã‚’æ€ã„ã®ã¾ã¾ã«æ“ä½œã§ãã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¡“ ï½žçª“ã®æœ ç‰¹åˆ¥ãƒ¬ãƒƒã‚¹ãƒ³ï½ž
kokemono 2013/05/16
vba

Excel

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
kokemono 2013/04/25
Excel

ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

vba
ãƒªãƒ³ã‚¯
Excel(ã‚¨ã‚¯ã‚»ãƒ«)VBAå…¥é–€ï¼šç›®æ¬¡
Excel(ã‚¨ã‚¯ã‚»ãƒ«)VBAã®åŸºæœ¬çš„ãªæ§‹æ–‡ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ ç°¡æ˜“ãªã‚µãƒ³ãƒ—ãƒ«ã‚’ä½¿ã£ã¦èª¬æ˜Žã—ã¦ã„ã¾ã™ã®ã§ã€Excel VBA(ãƒžã‚¯ãƒ)ã®å¦ç¿’ã®ä¸€åŠ©ã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ ãƒžã‚¯ãƒãã‚Œã¨ã‚‚VBA ã“ã®2ã¤ã‚’åŒºåˆ¥ã™ã‚‹ã¨ã€ ãƒžã‚¯ãƒï¼šã‚ã‚‹ç›®çš„ã®æ“ä½œæ‰‹é †ã‚’ç™»éŒ²ã—ã¦ãŠãã€ã“ã‚Œã‚’å®Ÿè¡Œã™ã‚‹æ©Ÿèƒ½ã€‚ VBA(Visual Basic For Application)ï¼šMicrosoftç¤¾ã®è£½å“ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€‚ ã¨ã„ã†ã“ã¨ã«ãªã‚‹ã®ã§ã—ã‚‡ã†ã‹ãƒ»ãƒ»ãƒ» ã©ã¡ã‚‰ã‚’ä½¿ã†ã®ãŒé©å½“ã‹ã‚ˆãã‚ã‹ã‚‰ãªã„ã®ã§ã™ãŒã€å¼Šã‚µã‚¤ãƒˆã§ã¯ã€ŒVBAã®ä½¿ã„æ–¹ã€ã¨ã„ã†ã“ã¨ã§èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ VBAå…¥é–€ ãƒžã‚¯ãƒã®è‡ªå‹•è¨˜éŒ²ã¨å®Ÿè¡Œ ãƒžã‚¯ãƒã®è‡ªå‹•è¨˜éŒ²ã¨å®Ÿè¡Œï¼ˆExcel2007ç·¨ï¼‰ ãƒžã‚¯ãƒãŒç„¡åŠ¹ã«ã•ã‚Œã‚‹(ãƒžã‚¯ãƒã‚’å«ã‚“ã ãƒ–ãƒƒã‚¯ã‚’é–‹ã) VBAã‚³ãƒ¼ãƒ‰(ãƒ—ãƒã‚°ãƒ©ãƒ )ã®è¨˜è¿°ã¨å®Ÿè¡Œã®æ‰‹é † VBE(Visual Basic Editor/VBã‚¨ãƒ‡ã‚£ã‚¿)ã®
kokemono 2011/12/11
Excel

vba
ãƒªãƒ³ã‚¯
Office TANAKA - Excel VBA Tips[ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã‚¿[çŠ¶æ³ã®åˆ¤å®š]]
Filterã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®Operatorãƒ—ãƒãƒ‘ãƒ†ã‚£ãŒè¿”ã™ã®ã¯ã€ã“ã‚Œã‚‰"å®Ÿä½“"ã®æ•°å€¤ã§ã™ã€‚ã¤ã¾ã‚Šã€Operatorãƒ—ãƒãƒ‘ãƒ†ã‚£ã§å–å¾—ã§ãã‚‹æ•°å€¤ã‹ã‚‰ã€ä¸Šè¨˜ã®ã„ãšã‚Œã‹ã‚’å°Žã‹ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚æœ¬é …ã®å†’é ã§ã€Œè¨å®šã•ã‚Œã¦ã„ã‚‹æ¡ä»¶ã‚’èª¿ã¹ã‚‹ã®ã¯å¤§å¤‰ã§ã™ã€ã¨æ›¸ã„ãŸã®ã¯ã€ã“ã†ã„ã†ç†ç”±ã§ã™ã€‚ã¡ãªã¿ã«ã€Œ1åˆ—ç›®ãŒ"ç”°ä¸"ã¨ç‰ã—ã„ã€ã®ã‚ˆã†ã«ã€1ã¤ã®åˆ—ã«1ã¤ã®æ¡ä»¶ã—ã‹æŒ‡å®šã—ã¦ã„ãªã„ã¨ãã€ã¤ã¾ã‚Šå¼•æ•°Operatorã‚’æŒ‡å®šã—ã¦ã„ãªã„ã¨ãã¯ã€Operatorãƒ—ãƒãƒ‘ãƒ†ã‚£ãŒ0ã‚’è¿”ã—ã¾ã™ã€‚ ä»¥ä¸Šã‚’ãµã¾ãˆãŸä¸Šã§ã€å°‘ã—ã ã‘å®Ÿç”¨çš„ãªã‚³ãƒ¼ãƒ‰ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ä¸‹å›³ã¯ã€Œ1åˆ—ç›®ãŒ"ç”°ä¸"ã¾ãŸã¯"åºƒç€¬"ã§ã‚ã‚‹ã€ã¨ã€Œ3åˆ—ç›®ãŒ"40ã‚ˆã‚Šå¤§ãã„"ã‹ã¤"80ã‚ˆã‚Šå°ã•ã„"ã€ã§çµžã‚Šè¾¼ã‚“ã§ã„ã¾ã™ã€‚ Sub Macro7() Range("A1").AutoFilter 1, "ç”°ä¸", xlOr, "åºƒç€¬" Range("A1").AutoFilter 3,
kokemono 2011/12/11
Excel

vba

tips
ãƒªãƒ³ã‚¯
ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®é«˜é‚„å…ƒçŽ‡ã®å„ªè‰¯åº—ã‚’é¸ã¶ãŸã‚ã«ã¯
ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®é«˜é‚„å…ƒçŽ‡ã®å„ªè‰¯åº—ã‚’é¸ã¶ãŸã‚ã«ã¯ ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®å„ªè‰¯åº—ã‚’é¸ã¶ãƒã‚¤ãƒ³ãƒˆã¯ã€æ›é‡‘çŽ‡ã‚„ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚‚ã‚ã‚Šã¾ã™ãŒã€ãã®ã»ã‹ã«ã‚‚è¦‹ã¦ãŠããŸã„ãƒã‚¤ãƒ³ãƒˆã‚‚ã‚ã‚Šã¾ã™ã€‚ ãŠé‡‘ã«åŽ³ã—ã„äººãŒåˆ©ç”¨ã—ã¾ã™ã®ã§ã€æ‰‹æ•°æ–™ã‚„ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ã®æœ‰ç„¡ã€ä¾¡æ ¼äº¤æ¸‰ãŒã§ãã‚‹æ¥è€…ã¨ã„ã†ã“ã¨ã¯è¦‹ã¦ãŠããŸã„ã¨ã“ã‚ã§ã™ã€‚ ãã‚Œãžã‚Œã©ã®ã‚ˆã†ãªå†…å®¹ãªã®ã§ã—ã‚‡ã†ã‹ã€‚ æ‰‹æ•°æ–™ãŒç„¡æ–™ã§ã‚ã‚‹ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ç¾é‡‘åŒ–ã®æ¥è€…ã«ã¯ã€æ‰‹æ•°æ–™ã‚’ã™ã¹ã¦ç„¡æ–™ã§ã—ã¦ãã‚Œã‚‹ã¨ã“ã‚ãŒã‚ã‚Šã¾ã™ã€‚ æ¥è€…ã«ã‚ˆã£ã¦ã¯ã€å˜ç´”ã«æ‰‹æ•°æ–™ã¨ã„ã†åç›®ã§æ¥è€…å´ã®åˆ©ç›ŠãŒã¨ã‚‰ã‚Œã¦ã„ãŸã‚Šã€æŒ¯è¾¼æ‰‹æ•°æ–™ã€äº‹å‹™æ‰‹æ•°æ–™ã¨ã„ã†åç›®ã§å°‘é¡ãªãŒã‚‰ãŠé‡‘ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã›ã£ã‹ãé«˜ã„æ›é‡‘çŽ‡ãŒè¨˜è¼‰ã•ã‚Œã¦ã„ã¦ã‚‚ã€æ‰‹æ•°æ–™ã®åˆ†ãŒå·®ã—å¼•ã‹ã‚Œã‚‹ã“ã¨ã§ã€æã‚’ã—ãŸã‚ˆã†ãªæ°—æŒã¡ã«ãªã£ãŸã‚Šå¾Œã‹ã‚‰æ°—ã¥ãã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã‚‰ã®æ‰‹æ•°æ–™ã¯æœ€åˆã‹ã‚‰å…¬å¼ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã«è¨˜è¼‰ãŒã‚ã‚‹å ´åˆã¯äº†æ‰¿ã—ãŸã†ãˆã§ç”³ã—è¾¼ã¿ã‚‚ã§ã
kokemono 2011/03/30
Excel

vba

ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸/windows/microsoft office/EXCEL/VBA/ã‚¨ã‚¯ã‚»ãƒ«ã§WEBã‚µã‚¤ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã† - å‹‰å¼·ç”¨ãƒ¡ãƒ¢
æœ€çµ‚æ›´æ–°æ—¥æ™‚&date()ã€€&link_edit(text=ã“ã“ã‚’ç·¨é›†) â– ç›®æ¬¡ #contents_line() â– æœ¬æ–‡ &link_edit(text=ã“ã“ã‚’ç·¨é›†) *ãƒšãƒ¼ã‚¸ãƒ•ãƒƒã‚¿ **ã“ã®ãƒšãƒ¼ã‚¸ã®1éšŽå±¤ä¸Šã®ãƒšãƒ¼ã‚¸ &link_parent() **ã“ã®ãƒšãƒ¼ã‚¸ã®1éšŽå±¤ä¸‹ã®ãƒšãƒ¼ã‚¸ #lsd() **ã“ã®ãƒšãƒ¼ã‚¸ã«å«ã¾ã‚Œã‚‹ã‚¿ã‚° &tags() **ã“ã®ãƒšãƒ¼ã‚¸ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ•° ä»Šæ—¥ï¼š&counter(today) æ˜¨æ—¥ï¼š&counter(yesterday) ã“ã‚Œã¾ã§åˆè¨ˆï¼š&counter(total)
kokemono 2010/12/01
vbaã§HTMLã‚’xpathã™ã‚‹

VBA

excel
ãƒªãƒ³ã‚¯
ã€ŒExcelã€ä¸Šã§å‹•ä½œã™ã‚‹æ‰‹è»½ãªæ´å²ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚²ãƒ¼ãƒ ã€Œæ¥µå°ä¸‰åœ‹å¿—ã€ï¼å§‰å¦¹å“ã«æ—¥æœ¬ã®æˆ¦å›½æ™‚ä»£ã‚’èˆžå°ã«ã—ãŸã€Œæ¥µå°å¤©ä¸‹çµ±ä¸€ã€ã‚‚ã€ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‘
kokemono 2010/07/13
ã‚²ãƒ¼ãƒ

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

VBA
ãƒªãƒ³ã‚¯
1