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

ton__ton id:ton__ton

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

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

Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
ton__ton 2015/01/15
selenium

vba
ãƒªãƒ³ã‚¯
UWSC + SeleniumVBAã§Chromeã‚„Firefoxã‚’è‡ªå‹•æ“ä½œã™ã‚‹
Seleniumã‚’ä½¿ã‚ãšã«ãƒ–ãƒ©ã‚¦ã‚¶ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ›¸ãã¾ã—ãŸ UWSCã§Seleniumã‚’ä½¿ã‚ãšã«Edgeã€Chromeã€Firefoxãªã©ã‚’æ“ä½œã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ›¸ã„ãŸ èˆˆå‘³ã‚ã‚‹æ–¹ã¯ã©ã†ãž SeleniumVBAã¯ä»Šå¾Œæ›´æ–°ã•ã‚Œã¾ã›ã‚“ï¼SeleniumBasicã¨åã‚’å¤‰ãˆã¦GitHubã§å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ SeleniumVBAã¯SeleniumBasicã«ãªã£ã¦ã¾ã—ãŸ ã«å°Žå…¥æ–¹æ³•ãªã‚“ã‹ã‚’æ›¸ãã¾ã—ãŸã®ã§ã€ãã¡ã‚‰ã‚’å¾¡è¦§ãã ã•ã„ãª å‰å›žã¯éžå¸¸ã«ã•ã£ãã‚Šã ã£ãŸã®ã§ã€ä»Šå›žã¯ InternetExplorer.Application ã¨æ¯”ã¹ãªãŒã‚‰ç°¡å˜ãªä½¿ã„æ–¹ã‚’ç´¹ä»‹ã™ã‚‹æ„Ÿã˜ã®è¨˜äº‹ã§ã™ æº–å‚™ ä½•ã¯ã¨ã‚‚ã‚ã‚Œå…ˆãšã¯SeleniumVBAã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ã‚‡ã† https://code.google.com/p/selenium-vba/#Download ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã«å¾“ã£ã¦ã¡ã‚‡ã¡ã‚‡ã„ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼
ton__ton 2015/01/15
selenium

vba
ãƒªãƒ³ã‚¯
VBAã§Firefoxã‚’è‡ªå‹•åˆ¶å¾¡ã™ã‚‹æ–¹æ³• ï¼ˆåŸºæœ¬æ“ä½œï¼‰ - ClockAhead é–‹ç™ºBlog
SeleniumVBAã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€VBAã‹ã‚‰Firefoxã‚’è‡ªå‹•åˆ¶å¾¡/æ“ä½œã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã€æ›¸ã„ã¦ããŸè¨˜äº‹ã®Indexã‚’ä½œæˆã—ã¾ã—ãŸã€‚ â€»ã€€SeleniumVBAè‡ªä½“ã¯ã€Firefoxã«é™ã‚‰ãšã€Chromeã‚„PhantomJSã€IEã®åˆ¶å¾¡ãŒå¯èƒ½ã§ã™ã€‚ åŸºæœ¬çš„ãªæ“ä½œã¯ç¶²ç¾…ã—ã¦ã‚‹ã¯ãšãªã®ã§ã€VBAã§ãƒ–ãƒ©ã‚¦ã‚¶ã®è‡ªå‹•åˆ¶å¾¡ã‚’è¡Œã„ãŸã„æ–¹ã®ã¨ã£ã‹ã‹ã‚Šã«ã¯ãªã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ï¼ˆVBAã§IEã®è‡ªå‹•åˆ¶å¾¡ã‚’æ—¢ã«æ‰‹æŽ›ã‘ãŸã“ã¨ãŒã‚ã‚‹äººã§ã‚ã‚Œã°ã€å®Ÿè³ªçš„ã«ã¯æ–‡æ³•ã®é•ã„ã ã‘ãªã®ã§ã™ã‚“ãªã‚Šä½¿ãˆã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ï¼‰ Index SeleniumVBAã®æ¦‚è¦ Selenium VBAï¼šã€€ãƒ–ãƒ©ã‚¦ã‚¶ã‚’VBAã‹ã‚‰è‡ªå‹•æ“ä½œã™ã‚‹ã ãŸï¼‘ã¤ã®å†´ãˆãŸæ–¹æ³• åŸºæœ¬çš„ãªæ“ä½œæ–¹æ³• Firefoxã‚’èµ·å‹•ã™ã‚‹ : Excelã‹ã‚‰Firefoxè‡ªå‹•åˆ¶å¾¡(1) æŒ‡å®šã—ãŸURLã«ç§»å‹• : Excelã‹ã‚‰Firefoxè‡ªå‹•åˆ¶å¾¡(2) F
ton__ton 2015/01/15
selenium

VBA
ãƒªãƒ³ã‚¯
IE ç”»é¢ã‚’ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§æ“ä½œã™ã‚‹ (ãƒ‘ã‚½ã‚³ãƒ³ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«é›†)
Excel VBA ã®å ´åˆã¯ã€Microsoft Internet Controls ã‚’å‚ç…§è¨å®š Excel VBA ã®å ´åˆã¯ã€ Microsoft Internet Controls ã¨ Microsoft HTML Object Library ã‚’å‚ç…§è¨å®šã—ã¦ãŠãã¨ã€ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã§ã€.(ãƒ‰ãƒƒãƒˆ)ã‚’æŠ¼ã—ãŸã¨ãã«ã€ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚„ãƒ¡ã‚½ãƒƒãƒ‰ã®å€™è£œãŒå‡ºã¦ãã‚‹ã®ã§ä¾¿åˆ©ã§ã™ã€‚ å‚è€ƒï¼š VBAã§IEåˆ¶å¾¡ã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªè¿½åŠ (å‚ç…§è¨å®š) http://www.vba-ie.net/library/ ã‚¨ã‚¯ã‚»ãƒ«VBAã§IE(Internet Explorer)ã‚’æ“ä½œã™ã‚‹æ™‚ã«å½¹ã«ç«‹ã¤ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¾ã¨ã‚ http://matome.naver.jp/odai/2137349926300192301 ä¸‰æµå›VBAã§IEæ“ä½œ ã¾ãšã¯ã€å‚ç…§è¨å®šã‹ã‚‰ http://www.ken3.org/cgi-bin/group
ton__ton 2015/01/09
IE

vba
ãƒªãƒ³ã‚¯
ç¬¬19å›žã€€TextStreamã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã† ï¼»æœ€çµ‚å›žï¼½
ç¬¬19å›žã€€TextStreamã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã† ï¼»æœ€çµ‚å›žï¼½ï¼šåŸºç¤Žè§£èª¬ æ¼”ç¿’æ–¹å¼ã§èº«ã«ã¤ã‘ã‚‹ãƒã‚§ãƒƒã‚¯å¼WSHè¶…å…¥é–€ï¼ˆ2/2 ãƒšãƒ¼ã‚¸ï¼‰ FileSystemObjectãŒå«ã¾ã‚Œã‚‹Microsoft Scripting Runtimeãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã¯ã€ä»Šå›žå–ã‚Šä¸Šã’ãŸTextStreamã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãªã©ã€ã„ãã¤ã‹ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒå˜åœ¨ã™ã‚‹ã€‚ã“ã‚Œã¾ã§ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯ã™ã¹ã¦FileSystemObjectã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’CreateObjectã—ã¦ã€ãã“ã‹ã‚‰ãŸã©ã‚Šç€ãã“ã¨ãŒã§ããŸãŒã€1ã¤ã ã‘ãŸã©ã‚Šç€ã‘ãªã„ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒå˜åœ¨ã™ã‚‹ã€‚ãã‚ŒãŒDictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã‚ã‚‹ã€‚Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯ProgIDãŒâ€œScripting.Dictionaryâ€ã§ã‚ã‚Šã€ã“ã‚Œã ã‘ã¯ç›´æŽ¥CreateObjectã—ã¦ä½œæˆã™ã‚‹ã€‚ ã•ã¦ã€Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã‚ã‚‹ãŒã€
ton__ton 2012/05/24
é€£æƒ³é…åˆ—

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

vba
ãƒªãƒ³ã‚¯
Excelã¨Wordã§ç°¡æ˜“ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
ton__ton 2010/08/03
Excel

vba

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
ãƒªãƒ³ã‚¯
ABåž‹ã®å¤‰ã‚ã‚Šè€… ï¼«ï½…ï½Žï¼“ã®ï¼¨ï¼° ã‚µã‚¤ãƒˆãƒžãƒƒãƒ—
<a href="http://www.ken3.org/cgi-bin/map.asp">http://www.ken3.org/cgi-bin/map.asp</a>
ton__ton 2009/07/08
vba

ãƒ–ãƒ©ã‚¦ã‚¶
ãƒªãƒ³ã‚¯
Excel VBAã§ã¯ã˜ã‚ã‚‹ã‚¯ãƒ©ã‚¹å…¥é–€ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€Visual BasicãŒç‹¬è‡ªã®ã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã—ã¦ä½¿ãˆã‚‹ã‚ˆã†ã«ã€Officeã«æè¼‰ã•ã‚Œã¦ã„ã‚‹VBAã§ã‚‚ç‹¬è‡ªã®ã‚¯ãƒ©ã‚¹ã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«çµ„ã¿è¾¼ã‚€ã“ã¨ãŒã§ãã¾ã™ã€‚ä½œæˆã—ãŸã‚¯ãƒ©ã‚¹ã¯ã€å„Officeã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã€Œã‚¤ãƒ³ãƒãƒ¼ãƒˆã€ã€Œã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã€ãŒã§ãã‚‹ãŸã‚ã€æ±Žç”¨æ€§ã®ã‚ã‚‹ã‚¯ãƒ©ã‚¹ã‚’1ã¤ä½œæˆã™ã‚Œã°ä»–ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®VBAã§ã‚‚åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ã€€ãã“ã§ã€æœ¬ç¨¿ã§ã¯Excel 2003ã§åˆ©ç”¨ã§ãã‚‹ã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã—ãªãŒã‚‰ã€VBAã§ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å¯¾è±¡èªè€…ã€€Excel VBAã‚’ä½¿ã£ã¦ãƒžã‚¯ãƒï¼ˆãƒ—ãƒã‚°ãƒ©ãƒ ï¼‰ã‚’ä½œã£ãŸã“ã¨ã®ã‚ã‚‹äººã€Visual BasicãŒä½¿ãˆã‚‹äººãŒå¯¾è±¡ã§ã™ã€‚å¿…è¦ãªç’°å¢ƒã€€Excel 2000ã€2002ã€2003ãŒä½¿ç”¨ã§ãã‚‹ç’°å¢ƒã€‚ã‚¯ãƒ©ã‚¹ã¯ä¾¿åˆ©ã€€VBAã§ã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã¯ã€è¤‡é›‘ãªå‡¦ç†ã‚’1ã¤ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«ã¾ã¨ã‚ã€ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚„ãƒ¡ã‚½ãƒƒãƒ‰ã‚’é€šã˜ã¦ãã®æ©Ÿèƒ½ã‚’å‘¼ã³å‡ºã—ãŸã‚Šãƒ‘ãƒ©ãƒ¡ãƒ¼
ton__ton 2006/09/19
vba

Excel
ãƒªãƒ³ã‚¯
ExcelãƒŽãƒ¼ãƒˆ é …ç›®ä¸€è¦§
ton__ton 2006/09/04
excel

vba
ãƒªãƒ³ã‚¯
â˜† Excelã§ãŠä»•äº‹ï¼(Excelå…¨èˆ¬ã®è§£èª¬ã‚µã‚¤ãƒˆ) â˜†
Excelã«é–¢ã™ã‚‹ã‚µã‚¤ãƒˆãŒæ•°ã‚ã‚‹ä¸ã€ãŠè¶Šã—ã„ãŸã ã„ã¦ã¾ã“ã¨ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã“ã¡ã‚‰ã¯ä»•äº‹ã«ã€ŒMicrosoft Excelã€ã‚’æ´»ç”¨ã—ã‚ˆã†ã¨ã„ã†æ–¹ã‚’å¿œæ´ã™ã‚‹ã‚µã‚¤ãƒˆã§ã™ã€‚ ä¸€èˆ¬äº‹å‹™ä½œæ¥ã§ã‚‚ãƒ—ãƒã‚°ãƒ©ãƒ é–‹ç™ºåˆ†é‡Žã§ã‚‚ã€Microsoft Excelã¯éžå¸¸ã«åˆ©ç”¨é »åº¦ã®é«˜ã„ã‚½ãƒ•ãƒˆã§ã™ã€‚ Excelã¯ã€ãƒ¯ãƒ¼ãƒ—ãƒã‚½ãƒ•ãƒˆã®ã‚ˆã†ãªå˜ãªã‚‹æ–‡æ›¸ä½œæˆãƒ„ãƒ¼ãƒ«ã§ã¯ãªãã€ã€Œãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’è¡Œãªã†ã“ã¨ãŒã§ãã‚‹ã‚‚ã£ã¨ã‚‚èº«è¿‘ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ è±Šå¯Œãªãƒ„ãƒ¼ãƒ«ã‚„è¨ˆç®—å¼ã€ãƒžã‚¯ãƒç‰ã‚’æ´»ç”¨ã—ã¦ä»•äº‹ã®åˆç†åŒ–ãƒ»è¿…é€ŸåŒ–ãƒ»ç²¾åº¦å‘ä¸Šã«å½¹ç«‹ã¦ã¦ã‚‚ã‚‰ã„ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãã®ãŸã‚ã«ã€å„ã‚¸ãƒ£ãƒ³ãƒ«ã§ç›®çš„åˆ¥ã®ãƒ¯ãƒ³ãƒã‚¤ãƒ³ãƒˆé›†ã‚’ã§ãã‚‹ã ã‘ç¶²ç¾…ã—ã‚ˆã†ã¨ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚‹ç¨‹åº¦Excelã®çµŒé¨“ãŒã‚ã‚‹äººã§ã‚‚ã€ç›®çš„ã‚’é€†å¼•ãã«åˆ©ç”¨ã—ã¦ã„ãŸã ãã¨é¢ç™½ã„å†…å®¹ãŒè¦‹ã¤ã‹ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸã€ã€Œãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€ã‚³ãƒ¼ãƒŠãƒ¼ã«ã¯ã€ExcelãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã„ç’°å¢ƒã§ã‚‚åˆ©ç”¨ã§ãã‚‹ãƒ•ãƒªãƒ¼ã‚½ãƒ•
ton__ton 2006/09/04
excel

vba
ãƒªãƒ³ã‚¯
1