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

fukudamasa09 id:fukudamasa09

Officeã¨vbaã«é–¢ã™ã‚‹fukudamasa09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

Office TANAKA - Excel VBA Tips[æ£è¦è¡¨ç¾ã«ã‚ˆã‚‹ãƒžãƒƒãƒãƒ³ã‚°]
VBAã‹ã‚‰æ£è¦è¡¨ç¾ã‚’ä½¿ã†ã«ã¯ã€VBScriptãŒä¾¿åˆ©ã§ã™ã€‚ãŸã ã—ã€æ£è¦è¡¨ç¾ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹VBScriptã¯Ver5.0ã‹ã‚‰ã§ã™ã‹ã‚‰ã€IE5.0ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ãƒ‘ã‚½ã‚³ãƒ³ã§ãªã„ã¨ä½¿ãˆã¾ã›ã‚“ã€‚ VBScriptã®ä¸ã§æ£è¦è¡¨ç¾ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æä¾›ã—ã¦ã„ã‚‹ã®ã¯RegExpã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã™ã€‚å‚ç…§è¨å®šã«ã‚ˆã‚‹Early Bindingã‹ã€CreateObjecté–¢æ•°ã‚’ä½¿ã£ãŸLate Bindingã§å‚ç…§ã—ã¾ã™ã€‚ã“ã“ã§ã¯Late Bindingã«ã‚ˆã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¾ãšã¯ã€æ£è¦è¡¨ç¾ã§ä½¿ç”¨ã™ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚„ãƒ¡ã‚½ãƒƒãƒ‰ã‚’æ•´ç†ã—ã¾ã—ã‚‡ã†ã€‚ RegExpã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã¨ãƒ¡ã‚½ãƒƒãƒ‰
fukudamasa09 2014/05/21
VBA

vbs

æ£è¦è¡¨ç¾

Excel

regex

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Office

VBScript

RegExp

tips
ãƒªãƒ³ã‚¯
Office TANAKA - Excel VBA Tips[é‡è¤‡ã—ãªã„ãƒªã‚¹ãƒˆã‚’ä½œã‚‹(1)]
ã€Œã‚ãƒ¼ã€ã¨ã€Œå€¤ã€ãŒã‚»ãƒƒãƒˆã«ãªã£ã¦ã„ã¦ã€ã€Œç¥žå¥ˆå·çœŒã€ã¨ã„ã†ã‚ãƒ¼ã§ã€Œæ¨ªæµœå¸‚ã€ã¨ã„ã†å€¤ã‚’æ¤œç´¢ã§ãã‚‹ã‚ˆã†ãªä»•çµ„ã¿ã§ã™ã€‚Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã¯ã€ã“ã†ã—ãŸé€£æƒ³é…åˆ—ã«ãƒ‡ãƒ¼ã‚¿(ã‚ãƒ¼ã¨å€¤ã®ã‚»ãƒƒãƒˆ)ã‚’è¿½åŠ ã—ãŸã‚Šã€æ¤œç´¢ã—ãŸã‚Šã€ä»»æ„ã®ã‚ãƒ¼ãŒã™ã§ã«å˜åœ¨ã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã‚’èª¿ã¹ã“ã¨ãªã©ãŒã§ãã¾ã™ã€‚ãªãŠã€é€£æƒ³é…åˆ—ã§ã¯åŒã˜ã‚ãƒ¼ã‚’ç™»éŒ²ã§ãã¾ã›ã‚“ã€‚ Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã£ã¦é‡è¤‡ã—ãªã„ãƒªã‚¹ãƒˆã‚’ä½œæˆã™ã‚‹ã«ã¯ã€æ¬¡ã®ã‚ˆã†ã«è€ƒãˆã¾ã™ã€‚ ã‚»ãƒ«A2ã‹ã‚‰ã‚»ãƒ«A8ã¾ã§é †ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¾ã™ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒé€£æƒ³é…åˆ—ã«ç™»éŒ²ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚‰ç™»éŒ²ã—ã¾ã™ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒé€£æƒ³é…åˆ—ã«ç™»éŒ²ã•ã‚Œã¦ã„ãŸã‚‰ä½•ã‚‚ã—ã¾ã›ã‚“ æµã‚Œã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ã•ã¦ç™»éŒ²ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã§ã™ãŒã€é€£æƒ³é…åˆ—ã§ã¯ã€Œã‚ãƒ¼ã€ã¨ã€Œå€¤ã€ã®äºŒã¤ãŒå¿…è¦ã§ã™ã€‚ä»Šå›žã®ã‚±ãƒ¼ã‚¹ã§ã¯ã€Œåå‰ã€ãƒ‡ãƒ¼ã‚¿ã—ã‹ã‚ã‚Šã¾ã›ã‚“ã€‚ã€Œåå‰ã€ã‚’ã€Œã‚ãƒ¼ã€ã«ã™ã‚‹ã¨ã—ã¦ã€ã€Œå€¤ã€ã«ã¯ä½•ã‚’ç™»éŒ²ã—ãŸã‚‰ã„ã„ã®ã§ã—ã‚‡ã†ã€‚
fukudamasa09 2014/05/01
AS

Microsoft

()

access

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Excel

VBA

Office

é€£æƒ³é…åˆ—

é‡è¤‡ãƒã‚§ãƒƒã‚¯
ãƒªãƒ³ã‚¯
Excel(ã‚¨ã‚¯ã‚»ãƒ«)å…¥é–€/åŸºæœ¬/ä¸Šç´š/å®Ÿç”¨è¬›åº§ã®ç·ç›®æ¬¡
Excel(ã‚¨ã‚¯ã‚»ãƒ«)åŸºæœ¬è¬›åº§ç›®æ¬¡ [ExcelåŸºæœ¬è¬›åº§ã¸GO!] å„é …ç›®æ¯Žã«è©³ç´°ã«èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ åŸºæœ¬çš„ãªä½¿ã„æ–¹ã‚’å¿˜ã‚ŒãŸã¨ãã«ä¾¿åˆ©? åŸºæœ¬æ“ä½œ(ä¸€èˆ¬æ“ä½œ) Excelã®èµ·å‹•ã¨çµ‚äº† Excelã‚’èµ·å‹•ã™ã‚‹ Excelã‚’çµ‚äº†ã™ã‚‹ ç”»é¢æ§‹æˆ ç”»é¢ã®åç§°ã¨ç°¡å˜ãªèª¬æ˜Ž ã‚·ãƒ¼ãƒˆã®æ“ä½œ æ¨™æº–ã‚·ãƒ¼ãƒˆæ•°ã®å¤‰æ›´ã¨ã‚·ãƒ¼ãƒˆåã®å¤‰æ›´ ã‚·ãƒ¼ãƒˆã®æœ€å¤§è¡Œåˆ—æ•° æ–°è¦ã‚·ãƒ¼ãƒˆæ•°ã®å¤‰æ›´ ã‚·ãƒ¼ãƒˆåã®å¤‰æ›´ ã‚·ãƒ¼ãƒˆã®è¿½åŠ ã¨å‰Šé™¤ãŠã‚ˆã³éžè¡¨ç¤º ã‚·ãƒ¼ãƒˆã®è¿½åŠ ã‚·ãƒ¼ãƒˆã®å‰Šé™¤ ã‚·ãƒ¼ãƒˆã‚’éžè¡¨ç¤ºã«ã™ã‚‹ ã‚·ãƒ¼ãƒˆã®å†è¡¨ç¤ºã‚’ç¦æ¢ã™ã‚‹ ã‚·ãƒ¼ãƒˆã®ç§»å‹•ã¨ã‚³ãƒ”ãƒ¼ ã‚·ãƒ¼ãƒˆã®ç§»å‹• ã‚·ãƒ¼ãƒˆã®ã‚³ãƒ”ãƒ¼ è¤‡æ•°ã‚·ãƒ¼ãƒˆã®æ“ä½œ è¤‡æ•°ã®ã‚·ãƒ¼ãƒˆã‚’è¡¨ç¤ºã™ã‚‹ è¤‡æ•°ã®ã‚·ãƒ¼ãƒˆã«åŒæ™‚ã«å…¥åŠ›ã‚„æ›¸å¼ã‚’è¨å®šã™ã‚‹ å¤šãã®ã‚·ãƒ¼ãƒˆã‹ã‚‰ç´ æ—©ãç›®çš„ã®ã‚·ãƒ¼ãƒˆã‚’é¸æŠžã™ã‚‹ ã‚·ãƒ¼ãƒˆã®ä¿è· ã‚·ãƒ¼ãƒˆã®æ“ä½œ ã‚»ãƒ«ã®æ“ä½œ ã‚»ãƒ«ã®æ“ä½œæ–¹æ³• ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ«ã®ç§»å‹• ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ«ã®ç§»å‹•ã®åŸºæœ¬ ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ«ã®ç§»å‹•ã®å¿œç”¨ åŠ¹çŽ‡çš„ãª
fukudamasa09 2014/04/30
excel

tips

office

ä»•äº‹

VBA

ã‚¨ã‚¯ã‚»ãƒ«

windows

ã¾ã¨ã‚

å…¥é–€

microsoft
ãƒªãƒ³ã‚¯
1GBãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãƒ»ãƒ—ãƒãƒã‚¤ãƒ€ãƒ¼ Amusement BiG-NET | www.big.or.jp/~seto/vbaref/vbaref13.htm
ã“ã¡ã‚‰ã¯ç‹¬è‡ªãƒ‰ãƒ¡ã‚¤ãƒ³ã‹ã‚‰ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã€ãƒ•ãƒ¬ãƒƒãƒ„æŽ¥ç¶šå°‚ç”¨ä¼šå“¡ã¾ã§ãƒˆãƒ¼ã‚¿ãƒ«ã‚µãƒãƒ¼ãƒˆã®ãƒ—ãƒãƒã‚¤ãƒ€ãƒ¼ã€BiG-NETã§ã™ã€‚ ã„ã¤ã‚‚å¼Šç¤¾ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã—ã¦é ‚ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ http://www.big.or.jp/~seto/vbaref/vbaref13.htm 404 Not Found (ãƒ•ã‚¡ã‚¤ãƒ«ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“) ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ãŒã€ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹è¦æ±‚ã•ã‚Œã¾ã—ãŸä¸Šè¨˜ãƒšãƒ¼ã‚¸ã¯ã€ç¾åœ¨ã‚¢ã‚¯ã‚»ã‚¹ãŒå‡ºæ¥ã¾ã›ã‚“ã€‚ å¼Šç¤¾ã§ã¯ã€ãªãœã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ã®ã‹ã¨è¨€ã†ç¬¬ä¸‰è€…ã‹ã‚‰ã®ãŠå•ã„åˆã‚ã›ã«ã¯ãŠç”ãˆã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã›ã‚“ã€‚ ã‚‚ã—ã“ã®ãƒšãƒ¼ã‚¸ã®é–¢ä¿‚è€…ã‚’ã”å˜çŸ¥ã§ã—ãŸã‚‰ã€é€£çµ¡ã‚’å–ã£ã¦ã¿ã‚‹ã“ã¨ã‚’ãŠè–¦ã‚è‡´ã—ã¾ã™ã€‚ ä½•å’ã”å®¹èµ¦ä¸‹ã•ã„ã€‚
fukudamasa09 2014/04/25
ãƒ•ã‚©ãƒ«ãƒ€

application

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

VBA API

Office

Excel

excel-vba

*VB

VBA

displayfullscreen
ãƒªãƒ³ã‚¯
Office TANAKA - ã‚·ãƒ¼ãƒˆã®æ“ä½œ[ä¿è·/è§£é™¤ã™ã‚‹]
Protectãƒ¡ã‚½ãƒƒãƒ‰ã¨Unprotectãƒ¡ã‚½ãƒƒãƒ‰ ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã™ã‚‹ã«ã¯Protectãƒ¡ã‚½ãƒƒãƒ‰ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã—ã¾ã™ã€‚ Sub Sample07() ActiveSheet.Protect End Sub ä¿è·ã‚’è§£é™¤ã™ã‚‹ã«ã¯Unprotectãƒ¡ã‚½ãƒƒãƒ‰ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚·ãƒ¼ãƒˆã®ä¿è·ã‚’è§£é™¤ã—ã¾ã™ã€‚ Sub Sample07_2() ActiveSheet.Unprotect End Sub ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ä»˜ãã®ä¿è· ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã™ã‚‹ã¨ãã¯ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã§ãã¾ã™ã€‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ä»˜ãã§ä¿è·ã•ã‚ŒãŸã‚·ãƒ¼ãƒˆã¯ã€è§£é™¤ã™ã‚‹ã¨ãã«ã‚‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ã§ã™ã€‚æ¨©é™ã‚’æŒãŸãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯ã‚·ãƒ¼ãƒˆã®å†…å®¹ã‚’è¦‹ã›ãŸããªã„ã¨ããªã©ã«æœ‰åŠ¹ã§ã™ãã€‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä»˜ã‘ã¦ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã™ã‚‹ã«ã¯ã€Protectãƒ¡ã‚½ãƒƒãƒ‰ã®å¼•æ•°Passwordã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¾ã™ã€‚æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚·ãƒ¼
fukudamasa09 2012/03/30
office

vba

excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
Office TANAKA - Excel VBA Tips[ãƒ–ãƒƒã‚¯ãŒé–‹ã‹ã‚Œã¦ã„ã‚‹ã‹ã©ã†ã‹èª¿ã¹ã‚‹]
ãƒ–ãƒƒã‚¯ã‚’é–‹ãã«ã¯ã€Workbooksã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã®Openãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ã¾ã™ã€‚ æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã€C:\Book1.xlsã‚’é–‹ãã¾ã™ã€‚ Sub Sample1() Workbooks.Open Filename:="C:\Book1.xls" End Sub ã¾ã£ãŸãä½•ã¦ã“ã¨ã®ãªã„å‡¦ç†ã§ã™ãŒã€ã“ã®ãƒ–ãƒƒã‚¯ã‚’ã™ã§ã«èª°ã‹ãŒé–‹ã„ã¦ã„ãŸã¨ã—ãŸã‚‰ã€ã„ã‚ã„ã‚ã¨ã€ã‚„ã£ã‹ã„ãªã“ã¨ãŒèµ·ã“ã‚Šã¾ã™ã€‚ãªãŠã€C:\Book1.xlsã¯ã€Œå…±æœ‰ãƒ–ãƒƒã‚¯ã§ã¯ãªã„ã€ã¨ã—ã¾ã™ã€‚å…±æœ‰ãƒ–ãƒƒã‚¯ã‚’èª°ãŒé–‹ã„ã¦ã„ã‚‹ã‹èª¿ã¹ã‚‹æ–¹æ³•ã¯ã€Œå…±æœ‰ãƒ–ãƒƒã‚¯ã‚’é–‹ã„ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’èª¿ã¹ã‚‹ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ è‡ªå‹•çš„ã«[é€šçŸ¥]ã§é–‹ã‹ã‚Œã¦ã—ã¾ã† å…±æœ‰ãƒ–ãƒƒã‚¯ã§ã¯ãªã„æ™®é€šã®ãƒ–ãƒƒã‚¯ã‚’ã€ã™ã§ã«èª°ã‹ãŒé–‹ã„ã¦ã„ãŸã¨ãã€ãã®åŒã˜ãƒ–ãƒƒã‚¯ã‚’æ‰‹å‹•ã§é–‹ã“ã†ã¨ã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ãªç¢ºèªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ è¨±ã•ã‚ŒãŸé¸æŠžè‚¢ã¯[èªã¿å–ã‚Šå°‚ç”¨]ã¨[é€šçŸ¥]ã®2ã¤ã§ã™ã€‚[èªã¿å–ã‚Šå°‚ç”¨]ãƒœã‚¿ãƒ³ã§é–‹ãã¨ã€
fukudamasa09 2012/03/26
Open

Book

office

Excel

ãƒ•ã‚¡ã‚¤ãƒ«æ“ä½œ

VBA
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
fukudamasa09 2012/03/19
Access

ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ ãƒãƒ¼

Office

db

Excel

access

vba

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Office TANAKA - VBA Tips
VBAã‚³ãƒ³ãƒ†ãƒ³ãƒ„ Home Excel VBA Excel VBA Tips ã‚»ãƒ« ã‚»ãƒ«ãŒé¸æŠžã•ã‚Œã¦ã„ã‚‹ã‹åˆ¤å®šã™ã‚‹ ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã§ãªã„ã‚·ãƒ¼ãƒˆã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ« çµåˆã‚»ãƒ«ã‚’èª¿ã¹ã‚‹ ç°¡å˜ã«ç½«ç·šã‚’å¼•ã ã‚»ãƒ«ã®Value2ãƒ—ãƒãƒ‘ãƒ†ã‚£ ã‚ã‚‹ã‚»ãƒ«ãŒã‚»ãƒ«ç¯„å›²ã«å«ã¾ã‚Œã‚‹ã‹ã©ã†ã‹ ã‚»ãƒ«ç¯„å›²ã®æ“ä½œ ç¢ºå®Ÿã«é¸æŠžã•ã‚Œã¦ã„ã‚‹ã‚»ãƒ«ã‚’æ“ä½œã™ã‚‹ å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã®æœ€çµ‚ã‚»ãƒ«ã‚’å–å¾—ã™ã‚‹ è¤‡æ•°ã®ã‚»ãƒ«ã‚’é¸æŠžã™ã‚‹ ç‰¹å®šã®ã‚»ãƒ«ç¯„å›²å†…ã‚’æ¤œç´¢ã™ã‚‹ éžè¡¨ç¤ºã®ã‚»ãƒ«ã‚’æ¤œç´¢ã™ã‚‹ ã™ã¹ã¦æ¤œç´¢ã™ã‚‹ æ—¥ä»˜ã‚’æ¤œç´¢ã™ã‚‹ 1ã¨001ã®å•é¡Œ Range(å·¦ä¸Šã‚»ãƒ«, å³ä¸‹ã‚»ãƒ«)ã®ä½¿ã„æ–¹ ã‚»ãƒ«ã®ç½«ç·šã«é–¢ã™ã‚‹ã“ã¨ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã‚¿ æ›¸ãæ–¹ã®åŸºæœ¬ æ–‡å—åˆ—ã§çµžã‚Šè¾¼ã‚€ æ•°å€¤ã§çµžã‚Šè¾¼ã‚€ æ—¥ä»˜ã§çµžã‚Šè¾¼ã‚€ è‰²ã§çµžã‚Šè¾¼ã‚€ ä½œæ¥åˆ—ã§çµžã‚Šè¾¼ã‚€ çµžã‚Šè¾¼ã‚“ã çµæžœã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ çµžã‚Šè¾¼ã‚“ã çµæžœã‚’é›†è¨ˆã™ã‚‹ çµžã‚Šè¾¼ã‚“ã çµæžœã®è¡Œã‚’æ“ä½œã™ã‚‹ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã‚¿ã®çŠ¶æ³ã‚’åˆ¤å®šã™ã‚‹ æ•°å¼ã®ã‚¨ãƒ©ãƒ¼ã§çµžã‚Šè¾¼ã‚€ ã‚·
fukudamasa09 2011/11/11
office

VBA

Excel

ã‚¨ã‚¯ã‚»ãƒ«

Tips

*ã¾ã¨ã‚

Office
ãƒªãƒ³ã‚¯
OfficeProã¯Excelã‚„Accessã®é–¢æ•°ã€VBAã€ãƒžã‚¯ãƒã®ç„¡æ–™è§£èª¬ã‚µã‚¤ãƒˆã§ã™
OfficeProã§ã¯Excelã‚„Accessãªã©ã®ä½¿ã„æ–¹ã‚„VBAã®è¨˜è¿°æ–¹æ³•ãªã©ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ Excel Excelã®ä½¿ã„æ–¹ Excelã®åŸºæœ¬çš„ãªæ“ä½œæ–¹æ³•ã‹ã‚‰ã‚»ãƒ«ã«å¯¾ã™ã‚‹æ›¸å¼è¨å®šã‚„ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½¿ã„æ–¹ã‚’è§£èª¬ Excelã‚°ãƒ©ãƒ•ã®ä½¿ã„æ–¹ Excelã®ã‚°ãƒ©ãƒ•ã®å„ç¨®è¨å®šæ–¹æ³•ã®è§£èª¬ã¨ã‚°ãƒ©ãƒ•åˆ¥ã®è©³ç´°ãªåˆ©ç”¨æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ Excelé–¢æ•°å…¥é–€ Excelé–¢æ•°ã®ç¨®é¡žã¨ä½¿ã„æ–¹ Excelãƒžã‚¯ãƒå…¥é–€ ãƒžã‚¯ãƒã®è‡ªå‹•è¨˜éŒ²ã®æ‰‹é †ã‚„ãƒžã‚¯ãƒã‚’èµ·å‹• Excel VBAå…¥é–€ Excelã‚„Accessãªã©ã§åˆ©ç”¨ã§ãã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®VBAã®ä½¿ã„æ–¹ã§ã™
fukudamasa09 2011/05/12
Excel

VBA

ãƒžã‚¯ãƒ

office
ãƒªãƒ³ã‚¯
Excel/VBAã‚¯ãƒªãƒ‹ãƒƒã‚¯ï¼Œä»Šæœˆã®è¨ºæ–
Microsoft Excelã¯ï¼ŒVBA(Visual Basic for Applications)ã¨å‘¼ã¶ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã‚’ä½¿ãˆã¾ã™ã€‚ã“ã®é€£è¼‰ã§ã¯ï¼ŒVBAã‚’ä½¿ã†ä¸Šã§ç”Ÿã˜ã‚‹æ‚©ã¿ã‚„ç–‘å•ã‚’ï¼Œã‚¯ãƒªãƒ‹ãƒƒã‚¯å½¢å¼ã§è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ ã€ç¬¬1å›žã€‘ãƒã‚°ã®äºˆé˜²ã«ã‚¨ãƒ©ãƒ¼ãƒ»ãƒˆãƒ©ãƒƒãƒ— ã€ç¬¬2å›žã€‘è‡ªä½œé–¢æ•°ã«ãƒ˜ãƒ«ãƒ—ã‚’è¨å®šã™ã‚‹å‡¦æ–¹ ã€ç¬¬3å›žã€‘Accessã®ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šè¾¼ã‚€å‡¦æ–¹ ã€ç¬¬4å›žã€‘å°åˆ·æ™‚ã®æ€ªç¾è±¡ã«å¯¾å‡¦ã™ã‚‹å‡¦æ–¹ ã€ç¬¬5å›žã€‘å°åˆ·æ™‚ã®æ€ªç¾è±¡ã«å¯¾å‡¦ã™ã‚‹å‡¦æ–¹ãã®2 ã€ç¬¬6å›žã€‘ãƒžã‚¯ãƒã ã‘ã‚’æ›´æ–°ã™ã‚‹ã«ã¯ ã€ç¬¬7å›žã€‘è‡ªä½œãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã§ãƒžã‚¯ãƒå®Ÿè¡Œã‚’å®¹æ˜“ã«ã™ã‚‹å‡¦æ–¹ ã€ç¬¬8å›žã€‘ã‚¤ãƒ™ãƒ³ãƒˆãƒ»ãƒ—ãƒã‚·ã‚¸ãƒ£ã‚’é–¢æ•°ä»£ã‚ã‚Šã«æ´»ç”¨ã™ã‚‹ ã€ç¬¬9å›žã€‘ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«Officeã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆã‚’åˆ©ç”¨ã™ã‚‹ ã€ç¬¬10å›žã€‘ã‚¨ãƒ©ãƒ¼ãƒ»ãƒˆãƒ©ãƒƒãƒ—ãŒåƒã‹ãªã„ã¨ãã®å¯¾å‡¦æ³•ã¨æ‰‹æŠœããƒ†ã‚¯ãƒ‹ãƒƒã‚¯ ã€ç¬¬11å›žã€‘ã‚»ãƒ«ã®ã‚¤ãƒ™ãƒ³ãƒˆãƒ»ãƒ‰ãƒªãƒ–ãƒ³ã§è‡ªå‹•å…¥åŠ› ã€ç¬¬12å›žã€‘å†å¸°çš„ã«è¡¨ç¾ã§ã
fukudamasa09 2011/04/23
ãƒžã‚¯ãƒ

VBA

Excel

office

Microsoft

Access

@IT

vba

ã‚¨ã‚¯ã‚»ãƒ«

tips
ãƒªãƒ³ã‚¯
1