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

cyokodog id:cyokodog

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

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

Excelã®â€œæ¡ä»¶ä»˜ãæ›¸å¼â€ã‚’éŽå°è©•ä¾¡ã—ã¦ã¾ã—ãŸã¨æ„Ÿã˜ãŸè¶…ä¾¿åˆ©ãªå°ãƒ¯ã‚¶4ã¤ - é€±åˆŠã‚¢ã‚¹ã‚ãƒ¼
ã‚¨ã‚¯ã‚»ãƒ«ã®è¡¨ã£ã¦å¤§ãããªã‚Œã°ãªã‚‹ã»ã©ã€æ•°å—ã°ã‹ã‚Šã«ãªã£ã¦è¦‹ã¥ã‚‰ããªã‚Šã¾ã™ã‚ˆãã€‚ãã“ã§ãœã²æ´»ç”¨ã—ãŸã„ã®ãŒâ€œæ¡ä»¶ä»˜ãæ›¸å¼â€ã§ã™ã€‚ã¤ã¾ã‚Šã€ã‚»ãƒ«ã®å€¤ã«ã‚ˆã£ã¦æ›¸å¼ã‚’å¤‰ãˆã‚‹ã“ã¨ã§ã€ç‰¹å®šã®ã‚»ãƒ«ã‚’ç›®ç«‹ãŸã›ã¦è¦‹ã‚„ã™ãã—ã‚ˆã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ç§è‡ªèº«ã‚‚ã€ã“ã“ã¾ã§ç°¡å˜ã§ã‹ã¤ä¾¿åˆ©ã ã¨ã¯ä»Šã¾ã§çŸ¥ã‚‰ãšã€â€œæ¡ä»¶ä»˜ãæ›¸å¼â€ã‚’éŽå°‘è©•ä¾¡ã—ã¦ã¾ã—ãŸã€‚ â– æˆç¸¾è¡¨ã®ä¸Šä½10äººãŒãƒ‘ãƒƒã¨è¦‹ã¦ã‚ã‹ã‚‹ã‚ˆã†è‰²åˆ†ã‘ã™ã‚‹ é¸æŠžã—ãŸç¯„å›²ã®å€¤ã®ä¸ã§ã€å¤§ããªã‚‚ã®ã‹ã‚‰10é …ç›®ã ã‘æ›¸å¼ã‚’å¤‰æ›´ã§ãã¾ã™ã€‚æˆç¸¾è¡¨ã‚„ãƒ†ã‚¹ãƒˆã®ç‚¹æ•°ã®ä¸Šä½è€…ãŒã²ã¨ç›®ã§ã‚ã‹ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚è‡ªå‹•çš„ã«æŠœãå‡ºã—ã¦ãã‚Œã‚‹ã®ã§ãƒŸã‚¹ã‚‚å°‘ãªããªã‚Šã¾ã™ã‚ˆã€‚
cyokodog 2014/04/08
excel

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

vba
ãƒªãƒ³ã‚¯
VBAã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã™ã‚‹æ–¹æ³•ã®ã¾ã¨ã‚
VBAã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ã€ä¸‹è¨˜ã®2é€šã‚Šã«ã¤ã„ã¦ç°¡å˜ãªã‚µãƒ³ãƒ—ãƒ«ã‚’ä½¿ã£ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹ é…åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹ ï¼‘ï¼Žã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‡ºåŠ›ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ« ä»¥ä¸‹ã®ã‚³ãƒ¼ãƒ‰ã¯ã€ã‚»ãƒ«ã®A1ï½žA10ã®å†…å®¹ã‚’ã€ŒC:\sample.txtã€ã«å‡ºåŠ›ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚ Sub Test() Dim stream As Object Set stream = CreateObject("ADODB.Stream") stream.Type = 2 stream.Charset = "UTF-8" stream.LineSeparator = 10 stream.Open stream.Position = 0 Dim i As Integer For i = 1 To 10 stream.WriteText ThisWorkbook.Wor
cyokodog 2014/04/07
vba
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«VBAã‚’å¦ã³ãŸã„ã®ã§ã€åˆå¿ƒè€…å‘ã‘ã«è‰¯ã•ãã†ãªã‚µã‚¤ãƒˆã‚’ã¾ã¨ã‚ãŸ - FXåˆå¿ƒè€…å‘ã‘ã¾ã¨ã‚è§£èª¬ï¼ˆæ ªå¼æŠ•è³‡ã‚‚ã‚ã‚‹ã‚ˆï¼‰
æ–‡ç³»äººé–“ãªã‚“ã§ã™ï¼ˆãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã‹ç„¡ç†ï¼‰ ã‚ãŸã—ã¯ã‘ã£ã“ã†ãªæ–‡ç³»äººé–“ã§ã€ç‰¹ã«PCã¨ã®è¦ªå’Œæ€§ãŒéžå¸¸ã«ä½Žã„ã€‚ ã©ã®ãã‚‰ã„è‹¦æ‰‹ã‹ã¨ã„ã†ã¨ã€ACCESSã»ã¼ç„¡ç†ï¼ˆæœ€åˆã‹ã‚‰çµ„ã¾ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ç¨‹åº¦ï¼‰ã€EXCELã¯ãƒžã‚¯ãƒã¾ã§ã£ã¦æ„Ÿã˜ã€‚SEãŒå¤šã„ã¨è¨€ã‚ã‚Œã‚‹ã¯ã¦ãªãƒ¦ãƒ¼ã‚¶ãƒ¼ã˜ã‚ƒçã—ã„ãƒ¬ãƒ™ãƒ«ã®ãƒ€ãƒ¡ã•ã€ã ã¨æ€ã†ã€‚ ã‚‚ã¨ã‹ã‚‰ãã‚Œã»ã©PCãŒå¤§å¥½ãã£ã¦ã‚¿ã‚¤ãƒ—ã˜ã‚ƒç„¡ã‹ã£ãŸã€‚ ã‘ã©ã€ã“ã“ã¾ã§ã§ããªã„ã®ã¯ã€ã‚ã¾ã‚Šã“ã®æ‰‹ã®ã‚¹ã‚ãƒ«ãŒè¦æ±‚ã•ã‚Œãªã„è·å ´ç’°å¢ƒã ã£ãŸã“ã¨ã‚‚å½±éŸ¿ã—ã¦ã„ã‚‹ã¨æ€ã†ã€‚ãªã‚“ã¨ã„ã†ã‹ã„ã‚ã„ã‚ã™ã§ã«æ•´ã£ã¦ã„ã¦ã€æ—¢å˜ã‚‚ã®ã‚’åˆ©ç”¨ã—ãŸã»ã†ãŒåŠ¹çŽ‡ãŒè‰¯ã•ãã†ãªæ„Ÿã˜ã€‚ ãŒã€ä¸€æ–¹ã§è‡ªåˆ†ã§ãƒ—ãƒã‚°ãƒ©ãƒ ä½œã‚Œã‚‹ã£ã¦ã“ã¨ã¸ã®æ¼ ç„¶ã¨ã—ãŸã‚ã“ãŒã‚Œã¯ã‚ã‚‹ã€‚ ã¾ãŸã€ã•ã™ãŒã«ç¤¾ä¼šäººã¨ã—ã¦çµŒé¨“å¹´æ•°ã‚‚å¢—ãˆã¦ããŸã®ã§ã€ã‚‚ã†å°‘ã—PCã‚¹ã‚ãƒ«ã‚‚ä¸Šã’ã¦ãŠããŸã„ã¨ã“ã‚ã€‚ ãŠãã‚‰ãè‡ªåˆ†ã§ï¼ˆç°¡å˜ãªï¼‰VBAãã‚‰ã„ã§ãã‚Œã°ã€æ¥å‹™ã®æŸ”è»Ÿæ€§ã¿ãŸã„ãªã‚‚ã®ãŒå‘ä¸Šã™ã‚‹æ°—ãŒ
cyokodog 2014/04/03
excel

vba
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…ã§ã‚‚å›³è§£ã§åˆ†ã‹ã‚‹ï¼ VBEã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã¨VBAãƒ—ãƒã‚°ãƒ©ãƒ ã®åŸºç¤Žæ–‡æ³•
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ã‚’å¯¾è±¡ã«Excelãƒžã‚¯ãƒï¼VBAã‚’ä½¿ã£ãŸæ¥å‹™è‡ªå‹•åŒ–ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä½œã‚Šæ–¹ã‚’ä¸€ã‹ã‚‰è§£èª¬ã™ã‚‹æœ¬é€£è¼‰ã€ŒExcelãƒžã‚¯ãƒï¼VBAã§å§‹ã‚ã‚‹æ¥å‹™è‡ªå‹•åŒ–ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã€‚å‰å›žã®ã€ŒExcelã§ãƒ—ãƒã‚°ãƒ©ãƒ ä½œæˆã‚’å§‹ã‚ã‚‹ãƒ¡ãƒªãƒƒãƒˆã¨ãƒžã‚¯ãƒã®åŸºæœ¬ã€ã§ã¯ã€ãã‚‚ãã‚‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¨ã¯ä½•ã‹ã€Visual Basicã¨VBAã¨ãƒžã‚¯ãƒã®é•ã„ã€ãƒžã‚¯ãƒã®ä½œã‚Šæ–¹ã€ä¿å˜ï¼å‰Šé™¤ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£è¨å®šãªã©ã«ã¤ã„ã¦è§£èª¬ã—ãŸã€‚ ä»Šå›žã¯Excel VBAãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®åŸºæœ¬çš„ãªç”¨èªžè§£èª¬ã‚’ãƒ¡ã‚¤ãƒ³ã«ã€VBEï¼ˆVisual Basic Editorã€VBã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ï¼‰ã®ç”»é¢æ§‹æˆã‚„ä½¿ã„æ–¹ã‚‚è§£èª¬ã™ã‚‹ã€‚ãƒ—ãƒãƒ‘ãƒ†ã‚£ã€ãƒ¡ã‚½ãƒƒãƒ‰ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãªã©å°‚é–€ç”¨èªžãŒå‡ºã¦ãã‚‹ãŒã€ã§ãã‚‹ã ã‘åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ãŸã„ã¨æ€ã†ã€‚ã©ã†ã‹ã€å«Œã«ãªã‚‰ãšã«ç€ã„ã¦ãã¦ã»ã—ã„ã€‚ ã“ã‚Œã‚‰ã®ç”¨èªžã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’ã™ã‚‹ä¸Šã§ã¯å¿…ãšå‡ºã¦ãã‚‹ã‚‚ã®ã§ã‚ã‚Šã€æ„å‘³ã‚’çŸ¥ã‚‰ãšã—ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹ã“ã¨
cyokodog 2014/02/14
excel

vba
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã®ExcelVBAï½žã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ï½ž | DevelopersIO
ã¡ã‚‡ã£ã¨ã”ç„¡æ²™æ±°ã—ã¦ã¾ã—ãŸã€‚ã‚¯ãƒ‹å‰ã§ã™ã€‚ ã‚¯ãƒªã‚¹ãƒžã‚¹ãŒè¿‘ã„ã§ã™ãã€‚ ã‚¢ã‚¤ã‚ãƒ£ãƒƒãƒã‚’ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã—ã¦ã¿ã¾ã—ãŸï½— ã‚‚ã¡ã‚ã‚“ãƒ‘ãƒ¯ãƒä½œã§ã™ï¼ˆï¼¾ï¼¾ï¼‰ ã•ã¦ã€ä»Šå›žã¯å‰å›žã®ã€Œã¯ã˜ã‚ã¦ã®Excel VBAï½žåŸºæœ¬ï½žã€ã§å‡ºãŸã€Œã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã€ã«ã¤ã„ã¦ã§ã™ã€‚ ã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã¯ ã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã¯ã€ç‰¹å®šã®å‹•ä½œã«ã‚ˆã£ã¦å‡¦ç†ã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã®ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã“ã¨ã§ã™ã€‚ ä¾‹ãˆã°ã€Œãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆãŒã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã«ãªã£ãŸæ™‚ã€ã€ã€Œå€¤ãŒå¤‰æ›´ã•ã‚ŒãŸæ™‚ã€ç‰ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ ã“ã®ã€Œâ—‹â—‹ã—ãŸæ™‚ã€ã®è¨å®šï¼ˆã‚¤ãƒ™ãƒ³ãƒˆï¼‰ã«ã‚ˆã£ã¦æ§‹æ–‡ãŒå¤‰åŒ–ã—ã¾ã™ã€‚ ã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ç¨®é¡ž ã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯ã€å¤§ãããƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã®ã‚¤ãƒ™ãƒ³ãƒˆã¨ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã®ã‚¤ãƒ™ãƒ³ãƒˆã®2ã¤ã«åˆ†é¡žã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã‚¤ãƒ™ãƒ³ãƒˆã¯ã€ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ï¼ˆExcelãƒ•ã‚¡ã‚¤ãƒ«ï¼‰ãŒé–‹ã„ãŸæ™‚ã«å®Ÿè¡Œã™ã‚‹ãªã©ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã‚’æ“ä½œã—ãŸéš›ã«ç™ºç”Ÿã™ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ã™ã€‚
cyokodog 2013/12/12
vba
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã®ExcelVBAï½žåŸºæœ¬ï½ž | DevelopersIO
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¯ãƒ‹å‰ã§ã™ã€‚ å¹´æ˜Žã‘æ—©ã€…ã€èƒƒè…¸ç‚Žã«é¢¨é‚ªã®ãƒ€ãƒ–ãƒ«ãƒ‘ãƒ³ãƒã§å¤§å¤‰ã§ã—ãŸã€‚ã€‚ã€‚ éŠã³ã«ã„ãã©ã“ã‚ã‹èªæ›¸ã‚‚é€²ã¾ãªã„ã—ã€ãƒ¬ã‚¤ãƒˆãƒ³æ•™æŽˆvsé€†è»¢è£åˆ¤ï¼ˆã‚²ãƒ¼ãƒ ï¼‰ã‚‚ãªã‹ãªã‹é€²ã¾ãšã€ã¡ã‚‡ã£ã¨ã‚¹ãƒˆãƒ¬ã‚¹æºœã¾ã‚Šã¾ã—ãŸï¼› ã¨ã‚Šã‚ãˆãšã€ã»ã¼å¾©æ´»ï¼&ã‚¯ãƒªã‚¢ã§ã™ï¼ˆï¼¾ï¼¾ï¼‰væ¬¡ã¯ã‚·ãƒ¥ã‚¿ã‚¤ãƒ³ã‚ºã‚²ãƒ¼ãƒˆã ã£ï¼ æœ€è¿‘Accessã®ãƒ–ãƒã‚°ã°ã£ã‹ã‚Šã ã£ãŸã®ã§ã€ã¡ã‚‡ã£ã¨é•ã†å†…å®¹ã‚’æ›¸ããŸã„ãªãƒ¼ã¨ã„ã†ã“ã¨ã§ã€ä»Šå›žã¯VBAã‚’ãƒã‚¿ã«ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å…¨ãã¨ã„ã£ã¦ã„ã„ã»ã©ã‚ã‹ã‚‰ãªã‹ã£ãŸã®ã§ï¼ˆä»Šã‚‚ãƒžã‚¹ã‚¿ãƒ¼ã—ã¦ã¾ã›ã‚“ï¼‰ã€ã‚ã‹ã‚‰ãªã‹ã£ãŸæ™‚ã®ã“ã¨ã‚’æ€ã„å‡ºã—ãªãŒã‚‰æ›¸ã„ã¦ã„ãã¾ã™ã€‚ ãªãœVBAã‚’ä½¿ã†ã®ã‹ æ§˜ã€…ãªè¨€èªžãŒã‚ã‚‹ä¸ã©ã†ã—ã¦VBAãªã®ã‹ã¨ã„ã†ã¨ã€ç§ã¯äº‹å‹™è·ã®ãŸã‚Excelã‚„Accessã‚’ä½¿ã†ã‹ã‚‰ã§ã™ã€‚ VBAã‚‚æ§˜ã€…ãªå‡¦ç†ã‚’ãƒœã‚¿ãƒ³ã²ã¨ã¤ã€ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã²ã¨ã¤ã§å®Ÿè¡Œã§ãã¾ã™ã€‚ ä¾‹ãˆã°ãƒœã‚¿ãƒ³ã‚¯ãƒªãƒƒã‚¯ã§é›†è¨ˆã‚’ã—ãŸã‚Šã€æ–‡å—å…¥åŠ›å¾Œã«æ›¸å¼ã‚’å¤‰æ›´ã—ãŸã‚Šã€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸
cyokodog 2013/02/25
vba
ãƒªãƒ³ã‚¯
Excelã‚·ãƒ¼ãƒˆã‚’èªã¿å–ã£ã¦ï¼ŒINSERTæ–‡SQLã‚’ç”Ÿæˆã™ã‚‹ãƒãƒƒãƒã€€ï¼ˆKingsoft Spreadsheetã‚’WSH/JScriptã§è‡ªå‹•æ“ä½œï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ãƒãƒƒãƒã®ã¾ã¨ã‚TOPã¸ ã€ŒExcelã®è¡¨ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å–ã£ã¦ï¼ŒDBã¸ã®ãƒ‡ãƒ¼ã‚¿æŠ•å…¥SQLã‚’ç”Ÿæˆã™ã‚‹ãƒžã‚¯ãƒã€ ã¯ï¼Œã‚ã¡ã“ã¡ã«ã‚ã‚‹ã€‚ Excelã‹ã‚‰SQLã®INSERTæ–‡ã‚’ä½œæˆã™ã‚‹ãƒžã‚¯ãƒ http://d.hatena.ne.jp/grachro/2011061... ã‚¨ã‚¯ã‚»ãƒ«ã§ä½œæˆã—ãŸãƒ‡ãƒ¼ã‚¿ã‹ã‚‰insertSQLã‚’ä½œæˆã™ã‚‹ãƒžã‚¯ãƒ http://t-daman.seesaa.net/article/111... ã—ã‹ã—ï¼ŒMS Officeä»¥å¤–ã®ã‚ªãƒ•ã‚£ã‚¹ã‚½ãƒ•ãƒˆã®ãƒ‘ã‚¯ãƒªï¼ˆKingsoft Officeç‰ï¼‰ã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆï¼ŒVBAãƒžã‚¯ãƒãŒå‹•ã‹ãªã„ã€‚ ãã®æ™‚ç‚¹ã§ï¼Œé–‹ç™ºè€…ã®è¦³ç‚¹ã‹ã‚‰ã™ã‚‹ã¨ã‚ªãƒ•ã‚£ã‚¹ã‚½ãƒ•ãƒˆã¨ã—ã¦å¤±æ ¼ãªã®ã ãŒï¼Œ ãã†ã„ã†å ´åˆã§ã‚‚ãªã‚“ã¨ã‹ã—ã¦è¡¨ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å–ã£ã¦ï¼Œä½œæ¥ã‚’è‡ªå‹•åŒ–ã—ãŸã„ã€‚ Kingsoftã®å ´åˆï¼ŒVBAãƒžã‚¯ãƒã¯å®Ÿè¡Œã§ããªã„ãŒï¼Œå¹¸ã„ã‚ªãƒ¼ãƒˆãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®COMãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ VBAãƒžã‚¯ãƒ
cyokodog 2013/01/09
vba
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
cyokodog 2012/01/30
excel

vba
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘Excel VBAã§Webã‚µãƒ¼ãƒ“ã‚¹ - Excelã§Twitterã¨é€£æºã™ã‚‹ å®Œæˆç·¨ | ãƒ‘ã‚½ã‚³ãƒ³ | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ã¯ã˜ã‚ã« ä»Šå›žã‚‚å¼•ãç¶šãTwitterã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚å‰å›žå–å¾—ã—ãŸã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒˆãƒ¼ã‚¯ãƒ³ã‚’ä½¿ã£ã¦ã€ã„ã‚ˆã„ã‚ˆTwitterã§ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã‚’å–å¾—ã—ãŸã‚Šã€ãƒ„ã‚¤ãƒ¼ãƒˆã‚’æŠ•ç¨¿ã—ãŸã‚Šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚å‹•ä½œç¢ºèªã¯ã€Windows 7ã€Excel 2010ã€VBA 7.0ãŠã‚ˆã³Windows XPã€Excel 2007ã€VBA 6.5ã§è¡Œã£ã¦ã„ã¾ã™ã€‚ å›³1ï¼Žå®Œæˆã‚µãƒ³ãƒ—ãƒ« å®Œæˆã‚µãƒ³ãƒ—ãƒ«ã¯sample.lzhã®ä¸ã«åŽéŒ²ã—ã¦ã„ã¾ã™ã€‚ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ Excel VBAã§Webã‚µãƒ¼ãƒ“ã‚¹ - å¤©æ°—äºˆå ±ã‚’å–å¾—ã—ã¦ã¿ã‚ˆã† Excel VBAã§Webã‚µãƒ¼ãƒ“ã‚¹ - MSNãƒžãƒãƒ¼ã‹ã‚‰æ ªä¾¡ã®æŽ¨ç§»ã‚’å–å¾—ã—ã‚ˆã† Excel VBAã§Webã‚µãƒ¼ãƒ“ã‚¹ - Excelã§æ›¸ç±æƒ…å ±ã‚’æ¤œç´¢ãƒ»å–å¾—ã—ã¦ã¿ã‚ˆã† Excel VBAã§Webã‚µãƒ¼ãƒ“ã‚¹ - YouTube APIã§å‹•ç”»ã‚’æ¤œç´¢ã—ã‚ˆã† Excel VBAã§Webã‚µãƒ¼ãƒ“ã‚¹
cyokodog 2011/11/05
****ã‚ã¨ã§ã¿ã‚‹

vba

excel

___favorite
ãƒªãƒ³ã‚¯
ä¸‰æµå›VBA:Excel èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ãŠè©±(å¼•æ•°çš„ãªãƒ©ãƒ–ãƒ¬ã‚¿ãƒ¼ã‚’æ¸¡ã—ãŸã„)
[ä¸‰æµå›] ï¼ï¼ï¼ž [ï¼¶ï¼¢ï¼¡ã§æ¥½ã—ã] ï¼ï¼ï¼ž [ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ä¸€è¦§] ï¼ï¼ï¼ž No.086 Excel èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ãŠè©±(å¼•æ•°çš„ãªãƒ©ãƒ–ãƒ¬ã‚¿ãƒ¼ã‚’æ¸¡ã—ãŸã„) çµå±€ã€ã†ã¾ãã§ããªã‹ã£ãŸã®ã§ã€ Set oApp = CreateObject("Excel.Application") oApp.Run "é–¢æ•°å", ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ ã§æ¸¡ã—ãŸã‚ˆã†ã«è¦‹ã›ãŸã ã‘ã§ã—ãŸãƒ»ãƒ»ãƒ» â€»ã‚‚ã£ã¨ã‚¹ãƒžãƒ¼ãƒˆãªæ–¹æ³•ãŒã‚ã‚Šãã†ã§ã™ãŒã€ä½•ã‹ã®å‚è€ƒã¨ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ ãƒ¡ãƒ«ãƒžã‚¬ç™ºè¡Œå†…å®¹ ï¼œExcel èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ãŠè©±(å¼•æ•°çš„ãªãƒ©ãƒ–ãƒ¬ã‚¿ãƒ¼ã‚’æ¸¡ã—ãŸã„)ï¼ž ã©ã†ã‚‚ã€ä¸‰æµãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®ï¼«ï½…ï½Žï¼“ã§ã™ã€‚ ä»Šå›žã¯ã€ Excelã®èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ãŠè©±ã§ã™ /* * ï¼‘ï¼Žä»Šå›žã®ã‚ãƒƒã‚«ã‚± */ http://www.ken3.org/cgi-bin/bbs/vba/wforum.cgi æŽ²ç¤ºæ¿ã«ã€ä¸‹è¨˜ã®è³ªå•ãŒæ¥ã¾ã—ãŸã€‚ ------------
cyokodog 2010/09/09
ã‚ã‚ŠãŒãŸã™ãŽï¼

vba

vbscript

___favorite
ãƒªãƒ³ã‚¯
VBAåŸºç¤Žæ–‡æ³•æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ - ã„ã‚ã„ã‚è§£æžæ—¥è¨˜
VBAã®æ–‡æ³•ä¸€è¦§ã§ã™ã€‚ä»–ã®è¨€èªžã‚’ã‚ã‚‹ç¨‹åº¦çŸ¥ã£ã¦ã„ã‚‹äººã¯ã“ã‚Œã‚’èªã‚ã°VBAã®åŸºç¤Žã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã¦VBAã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ç°¡æ˜“ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¨ã—ã¦ã‚‚åˆ©ç”¨ã§ãã‚‹ã¨æ€ã„ã¾ã™ã®ã§ã€ã“ã‚Œã¯è¶³ã‚Šãªã„ã¨æ€ã†ã‚‚ã®ãŒã‚ã‚Œã°æ•™ãˆã¦ãã ã•ã„ã€‚ 1. åŸºç¤Ž Visual Basic Editorã®èµ·å‹• VBAã¯Visual Basic Editorã§ç·¨é›†ãƒ»å®Ÿè¡Œã—ã¾ã™ã€‚Visual Basic Editorã¯æ¬¡ã®ã‚ˆã†ã«èµ·å‹•ã—ã¾ã™ã€‚ Excelã‚„Wordã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã§[ãƒ„ãƒ¼ãƒ«]-[ãƒžã‚¯ãƒ]-[Visual Basic Editor]ã‚’é¸æŠžã™ã‚‹ æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è¿½åŠ VBAã¯æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«è¨˜è¿°ã—ã¾ã™ã€‚æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯æ¬¡ã®ã‚ˆã†ã«è¿½åŠ ã—ã¾ã™ã€‚ Visual Basic Editorã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã§[æŒ¿å…¥]-[æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«]ã‚’é¸æŠžã™ã‚‹ã€‚ å¤‰æ•°å®£è¨€ã®å¼·åˆ¶ å¤‰æ•°å®£è¨€ã‚’å¼·åˆ¶ã™ã‚‹ãŸã‚ã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®å…ˆé ã«å¿…ãšä»¥ä¸‹ã®è¡Œã‚’æ›¸ã
cyokodog 2010/02/01
*etc

vba

å…¥é–€
ãƒªãƒ³ã‚¯
1