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

GoHappy id:GoHappy

VBAã«é–¢ã™ã‚‹GoHappyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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ã§JSONãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ‘ãƒ¼ã‚¹ã™ã‚‹ - SO NOTE ãã†ã®ã¦ (ï¼›^Ï‰^)
COMã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ScriptControlã‚’ä½¿ã†ã¨ã€VBAä¸Šã§JScriptãŒå®Ÿè¡Œå‡ºæ¥ã¾ã™ã€‚ã£ã¦äº‹ã¯ã€VBAã§ã‚‚JSONãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‘ãƒ¼ã‚¹ãŒå‡ºæ¥ã‚‹ã‚“ã˜ã‚ƒãï¼Ÿã¨å‰ã€…ã‹ã‚‰æ€ã£ã¦ãŸã®ã‚’è©¦ã—ã¦ã¿ãŸã¨ã“ã‚ã€æ‹åæŠœã‘ã™ã‚‹ãã‚‰ã„ç°¡å˜ã«å‡ºæ¥ã¾ã—ãŸã€‚ ã‚½ãƒ¼ã‚¹ Option Explicit Sub VBA_de_JSON() Const cnsJSONString As String = "{ ""familyname"":""yamada"", ""personalname"":""tarou"" }" Dim sc As Object Dim strFunc As String Dim objJSON As Object Set sc = CreateObject("ScriptControl") sc.Language = "JScript" 'jsonã«ãƒ‘ãƒ¼ã‚¹ã™ã‚‹é–¢æ•°æ–‡å—åˆ— strFunc = "
GoHappy 2015/09/01
VBA

vb

web

json
ãƒªãƒ³ã‚¯
VBAåŸºç¤Žæ–‡æ³•æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ - ã„ã‚ã„ã‚è§£æžæ—¥è¨˜
VBAã®æ–‡æ³•ä¸€è¦§ã§ã™ã€‚ä»–ã®è¨€èªžã‚’ã‚ã‚‹ç¨‹åº¦çŸ¥ã£ã¦ã„ã‚‹äººã¯ã“ã‚Œã‚’èªã‚ã°VBAã®åŸºç¤Žã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã¦VBAã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ç°¡æ˜“ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¨ã—ã¦ã‚‚åˆ©ç”¨ã§ãã‚‹ã¨æ€ã„ã¾ã™ã®ã§ã€ã“ã‚Œã¯è¶³ã‚Šãªã„ã¨æ€ã†ã‚‚ã®ãŒã‚ã‚Œã°æ•™ãˆã¦ãã ã•ã„ã€‚ 1. åŸºç¤Ž Visual Basic Editorã®èµ·å‹• VBAã¯Visual Basic Editorã§ç·¨é›†ãƒ»å®Ÿè¡Œã—ã¾ã™ã€‚Visual Basic Editorã¯æ¬¡ã®ã‚ˆã†ã«èµ·å‹•ã—ã¾ã™ã€‚ Excelã‚„Wordã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã§[ãƒ„ãƒ¼ãƒ«]-[ãƒžã‚¯ãƒ]-[Visual Basic Editor]ã‚’é¸æŠžã™ã‚‹ æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è¿½åŠ VBAã¯æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«è¨˜è¿°ã—ã¾ã™ã€‚æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯æ¬¡ã®ã‚ˆã†ã«è¿½åŠ ã—ã¾ã™ã€‚ Visual Basic Editorã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã§[æŒ¿å…¥]-[æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«]ã‚’é¸æŠžã™ã‚‹ã€‚ å¤‰æ•°å®£è¨€ã®å¼·åˆ¶ å¤‰æ•°å®£è¨€ã‚’å¼·åˆ¶ã™ã‚‹ãŸã‚ã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®å…ˆé ã«å¿…ãšä»¥ä¸‹ã®è¡Œã‚’æ›¸ã
GoHappy 2014/12/11
VBA
ãƒªãƒ³ã‚¯
http://www.red.oit-net.jp/tatsuya/vb/fixed.htm
GoHappy 2014/04/18
vb6

VBA

VB

å®šæ•°

æŠ€è¡“

Programming
ãƒªãƒ³ã‚¯
VBA XMLãƒ‡ãƒ¼ã‚¿ã‚’DOMã§æ‰±ã†æ–¹æ³• - SMILE JAPAN WIKI
çµè«–ã‹ã‚‰è¨€ãˆã°ã€ä¸Šè¨˜ã®ã‚³ãƒ¼ãƒ‰ã‚’ï¼‘è¡Œè¿½åŠ ã—ãŸã‚‰ã€ã‚¨ãƒ©ãƒ¼ãŒæ¶ˆãˆã¦ã€XMLã®èªã¿è¾¼ã¿ã«æˆåŠŸã—ãŸï¼ ã¯ï½žã€ã“ã‚Œã ã‘ã®ãŸã‚ã«ä½•æ™‚é–“è²»ã‚„ã—ãŸã“ã¨ã‹â€¦ãƒˆãƒ›ãƒ›ã®ãƒ›ï¼žï¼œ ã¾ã¨ã‚ã‚‹ã¨ã€ã“ã‚“ãªæ„Ÿã˜ã®Excel VBAã‚³ãƒ¼ãƒ‰ã§ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆURLã‹ã‚‰XMLãƒ‡ãƒ¼ã‚¿ã®èªè¾¼ã¿ï¼†æ“ä½œãŒã§ãã‚‹ã€‚ 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
GoHappy 2014/01/16
XML

VBA

DOM
ãƒªãƒ³ã‚¯
Office XP Web Services Toolkit 2.0 ã‚’ä½¿ç”¨ã—ã¦ XML Web ã‚µãƒ¼ãƒ“ã‚¹ã§è¤‡åˆãƒ‡ãƒ¼ã‚¿åž‹ã‚’é€å—ä¿¡ã™ã‚‹
ã“ã®ãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œãªããªã‚Šã¾ã—ãŸã€‚ Microsoft Edge ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã¨ã€æœ€æ–°ã®æ©Ÿèƒ½ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ›´æ–°ãƒ—ãƒã‚°ãƒ©ãƒ ã€ãŠã‚ˆã³ãƒ†ã‚¯ãƒ‹ã‚«ãƒ« ã‚µãƒãƒ¼ãƒˆã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ Frank C. Rice Microsoft Corporation July 2002 å¯¾è±¡: MicrosoftÂ® Office XP Web Services Toolkit 2.0 Microsoft SOAP Toolkit 3.0 æ¦‚è¦ : Microsoft Office XP Web Services Toolkit 2.0 ã«ã¯ã€ XML Web ã‚µãƒ¼ãƒ“ã‚¹ã§å˜ç´”ãƒ‡ãƒ¼ã‚¿åž‹ã¨è¤‡åˆãƒ‡ãƒ¼ã‚¿åž‹ã®ä½¿ç”¨ã‚’ç°¡ç•¥åŒ–ã™ã‚‹ Web Service References Tool 2.0 ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®è³‡æ–™ã§ã¯ã€SOAP 3.0 DLL ãŠã‚ˆã³ Web Service References Tool 2
GoHappy 2014/01/16
VBA

xml

SOAP

Webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
1