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

whalebone id:whalebone

vbaã«é–¢ã™ã‚‹whaleboneã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

[AutoCAD] - AutoCAD VBAã‚’ä½¿ã„ã€Excelãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ä½œå›³
whalebone 2019/01/28
tips

vba

CAD

excel

illustration

design
ãƒªãƒ³ã‚¯
Toshiyuki Ihara's ã‚¨ã‚¯ã‚»ãƒ«è¨ˆç®—ã®æŠ€
ã»ã¨ã‚“ã©ã®Windowsãƒ‘ã‚½ã‚³ãƒ³ã«ã¯ã€Wordï¼ˆãƒ¯ãƒ¼ãƒ‰ï¼‰ã‚„Excelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ãªã©ã®microsoft officeã®ã‚½ãƒ•ãƒˆãŒå…¥ã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã“ã“ã§ã¯ã“ã®ã‚¨ã‚¯ã‚»ãƒ«ã‚’ä½¿ã£ã¦ã€ç°¡å˜ãªæ•°å€¤è¨ˆç®—ã‚„ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã‚‚ã©ãï¼‰ã‚’ãƒãƒ£ãƒãƒ£ãƒƒã¨ä½œã‚‹ä¾¿åˆ©ãªã€ŒæŠ€ã€ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆVisual Basicãƒ»ãƒžã‚¯ãƒï¼‰ã‚’å…¨ãçŸ¥ã‚‰ãªãã¦ã‚‚ä½œã‚Œã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã‚„ã‚°ãƒ©ãƒ•ã‚’é§†ä½¿ã™ã‚‹ã“ã¨ã§ã€ã“ã‚“ãªã“ã¨ã‚‚ã§ãã¦ã—ã¾ã„ã¾ã™ã‚µãƒ³ãƒ—ãƒ«é›†(upã‚„downã¨æ›¸ã„ãŸã‚»ãƒ«ã«æ³¨ç›®ï¼ï¼‰
whalebone 2016/03/19
excel

vba

tips

3d

visualization

ãªã‚‹ã»ã©

ui
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ¼ã‚½ãƒŠãƒ«
ã€ã‚¢ãƒžã‚¾ãƒ³ã§è²·ã„ç‰©ã‚’ã™ã‚‹â‡’ã€‘ 1.Excelå®šç¾©ã¨VBAãƒ—ãƒã‚°ãƒ©ãƒ æœ¬æ›¸ã§ç´¹ä»‹ã—ã¦ã„ã‚‹Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’åœ§ç¸®å½¢å¼(ï¼¬ï¼ºï¼¨)ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãªãŠã€Microsoft Windowsã®64 ãƒ“ãƒƒãƒˆã‚·ã‚¹ãƒ†ãƒ ã‚’ä½¿ã†å ´åˆ Declareæ–‡ã«PtrSafe å±žæ€§ã‚’æŒ‡å®šã—ã¦ãã ã•ã„ã€‚ Private Declare Function GetTickCount Lib "kernel32" () As Long â†“ Private Declare PtrSafe Function GetTickCount Lib "kernel32" () As Long
whalebone 2014/04/13
excel

tips

visualization

vba

simulation
ãƒªãƒ³ã‚¯
ã„ã¤ã‚‚ã®è¨è¨ˆã‚·ãƒ¼ãƒˆã‚’ã‚¢ãƒ—ãƒªã«ç°¡å˜å¤‰èº«ï¼ Excel VBAæ´»ç”¨è¡“
ã€Œãã†ã¯è¨€ã£ã¦ã‚‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒãã€ã¨ã€è«¦ã‚ã¦ã„ã‚‹æ–¹ã‚‚å¤šã„ã‹ã¨æ€ã„ã¾ã™ãŒã€å®Ÿã¯ã€Excelã®VBAæ©Ÿèƒ½ã‚’ä½¿ã†ã¨ã€ç¾åœ¨ãŠä½¿ã„ã®è¨ˆç®—ã‚·ãƒ¼ãƒˆã«ç°¡å˜ã«å›³2ã®ã‚ˆã†ãªã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚’è¿½åŠ ã§ãã¾ã™ã€‚ã—ã‹ã‚‚ã€ä»Šå›žç´¹ä»‹ã™ã‚‹ç¨‹åº¦ã®æ©Ÿèƒ½ã§ã‚ã‚Œã°ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«é–¢ã™ã‚‹çŸ¥è˜ã‚‚ã»ã¨ã‚“ã©å¿…è¦ã‚ã‚Šã¾ã›ã‚“ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€å›³1ã«ç¤ºã—ãŸãƒãƒå®šæ•°ã®è¨ˆç®—ã‚·ãƒ¼ãƒˆã‚’ä¾‹ã«ã€å›³2ã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦æ©Ÿèƒ½ã‚’å®Ÿè£…ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã€å…·ä½“çš„ã«èª¬æ˜Žã—ã¾ã™ã€‚ã‚„ã‚Šæ–¹ã¯ã¨ã¦ã‚‚ç°¡å˜ã§ã™ã€‚ä¸€åº¦è¦šãˆã‚Œã°ã€ã‚ãšã‹ãªæ‰‹é–“ã§ã€ã•ã¾ã–ã¾ãªè¨ˆç®—ã‚·ãƒ¼ãƒˆã«å›³2ã®ã‚ˆã†ãªæ©Ÿèƒ½ã‚’è¿½åŠ ã§ãã¾ã™ã€‚ ã¾ãšä»•çµ„ã¿ã‚’ç†è§£ã—ã‚ˆã† æ—©é€Ÿä½œã£ã¦ã¿ãŸã„ã¨ã“ã‚ã§ã™ãŒã€ãã®å‰ã«ã€ä»•çµ„ã¿ã¨ä½œæˆã®æ‰‹é †ã‚’èª¬æ˜Žã—ã¾ã™ã€‚å…¥å‡ºåŠ›ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã¨è¨ˆç®—ã‚·ãƒ¼ãƒˆã¨ã®é–¢ä¿‚ã¯ã€å›³3ã«ç¤ºã™ã‚ˆã†ã«ã€ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦å´ã§å…¥åŠ›æ¬„ã«æ•°å€¤ãŒå…¥åŠ›ã•ã‚Œã‚‹ã¨è¨ˆç®—ã‚·ãƒ¼ãƒˆã®è©²å½“ã™ã‚‹ã‚»ãƒ«ã«å…¥åŠ›ã•ã‚ŒãŸæ•°å€¤ãŒã‚³ãƒ”ãƒ¼ã•ã‚Œã¾ã™ã€‚
whalebone 2014/02/21
design

excel

tips

vba

æ‰‹æ®µã®ç›®çš„åŒ–
ãƒªãƒ³ã‚¯
é‡‘ä¸¸éš†å¿—ã®è¬›ç¾©è³‡æ–™
ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç³» Microsoft Office ã®åŸºç¤Žï¼šå·¥å¦é™¢å¤§å¦ (2005å¹´ï½ž) è¨ˆç®—æ©Ÿã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ»ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžç³» [ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ»ã‚¢ã‚»ãƒ³ãƒ–ãƒªè¨€èªž] ãƒžã‚¤ã‚¯ãƒãƒ—ãƒã‚»ãƒƒã‚µåŠã³æ¼”ç¿’ (æœ€çµ‚ç¨¿)ï¼šæ±äº¬è¾²å·¥å¤§å¦ (2001ï½ž2004å¹´) [C/C++] ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã§ C/C++ ã‚’è‡ªç¿’ã—ã‚ˆã†ï¼šå·¥å¦é™¢å¤§å¦ (2020å¹´ï½ž) éžæƒ…å ±ç³»å¦ç”Ÿã®ãŸã‚ã® C/C++ å…¥é–€ï¼šå·¥å¦é™¢å¤§å¦ (2008å¹´ï½ž2019å¹´) ã‚¯ãƒ©ã‚¹ã‹ã‚‰å…¥ã‚‹ C++ï¼šæ±äº¬è¾²å·¥å¤§å¦ (2003å¹´ï½ž2004å¹´) C ã‹ã‚‰å…¥ã‚‹ C++ï¼šæ±äº¬è¾²å·¥å¤§å¦ (2002å¹´) [Basic] Excel ã§å¦ã¶ Visual Basic for Applications (VBA)ï¼šå·¥å¦é™¢å¤§å¦ (2005å¹´ï½ž) é›»åå·¥ä½œç³» LEDã‚„ãƒ¢ãƒ¼ã‚¿ãƒ¼ã‚’Arduinoã§åˆ¶å¾¡ã—ã‚ˆã† (Tinkercadã«ã‚ˆã‚‹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³è¬›ç¾©ç‰ˆ)ï¼šå·¥å¦é™¢å¤§å¦
whalebone 2014/01/16
lecture

vba

programming

excel

tips

math

tutorial
ãƒªãƒ³ã‚¯
Amazon.co.jp: å·¥å¦ã®ãŸã‚ã®VBAãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åŸºç¤Ž: æ‘æœ¨æ£èŠ³: æœ¬
whalebone 2012/12/30
å¦ç”Ÿæ™‚ä»£ã«èªã¿ãŸã‹ã£ãŸå†…å®¹

book

excel

vba

programming

tutorial
ãƒªãƒ³ã‚¯
Excel VBAã§ã‚¸ãƒ§ã‚¤ã‚¹ãƒ†ã‚£ãƒƒã‚¯å…¥åŠ›(6è»¸) - Dream Drive !!
whalebone 2012/12/12
excel

hack

tool

software

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

vba

game

hack
ãƒªãƒ³ã‚¯
http://www.acesekkei.com/programming/vba/index.htm
whalebone 2007/09/10
CAD

vba
ãƒªãƒ³ã‚¯
AutoCAD VBA
ã“ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§ã¯ã€SeaGateãŒåŸ·ç†ã—ã€CAD&CGãƒžã‚¬ã‚¸ãƒ³2004å¹´8æœˆå·ã‹ã‚‰2005å¹´9æœˆå·ã¾ã§è¨ˆ14å›žã«æ¸¡ã£ã¦é€£è¼‰ã•ã‚ŒãŸåˆå¿ƒè€…å‘ã‘ã®AutoCAD VBAãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¬›åº§ã€ŒVBAã§è¡Œã“ã†!ã€ã‚’æ”¹é¡Œã—ã€ã‚ªãƒªã‚¸ãƒŠãƒ«åŽŸç¨¿ã«ä¸€éƒ¨åŠ ç†ãƒ»ä¿®æ£ãŸã‚‚ã®ã‚’CAD&CGãƒžã‚¬ã‚¸ãƒ³ç·¨é›†éƒ¨ã®åŒæ„ã‚’å¾—ã¦æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ CAD&CGãƒžã‚¬ã‚¸ãƒ³é€£è¼‰å½“æ™‚ã¯AutoCAD 2004ã‚’ãƒ™ãƒ¼ã‚¹ã«åŸ·ç†ã—ã¦ã„ãŸãŸã‚ã€ã“ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§ä½¿ç”¨ã—ã¦ã„ã‚‹å›³ç‰ˆãªã©ã‚‚AutoCAD 2004ã®ã‚‚ã®ã¨ãªã£ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€VBAã«ã‚ˆã‚‹åŸºæœ¬çš„ãªã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã®æ–¹æ³•ã¯2005ä»¥é™ã®AutoCADã§ã‚‚ãã‚Œã»ã©å¤‰ã‚ã£ã¦ã„ã¾ã›ã‚“ã€‚ AutoCAD 2006ã‹ã‚‰ã¯.NET APIã«ã‚ˆã‚‹ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã‚‚å¯èƒ½ã¨ãªã‚Šã€VBAã¯ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºç’°å¢ƒã®ä¸»æµã‹ã‚‰ã¯ä¸€æ©å¾Œé€€ã—ãŸæ„ŸãŒã‚ã‚Šã¾ã™ãŒã€VBAã®é–‹ç™ºç’°å¢ƒã¯AutoCADã«å«ã¾ã‚Œã¦ãŠã‚Šã€AutoCADå˜ä½“ã§ãƒ—
whalebone 2007/09/10
CAD

vba

excel
ãƒªãƒ³ã‚¯
ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆforExcel (å·¥ç¨‹ç®¡ç†ãƒžã‚¯ãƒ)
ã“ã®ãƒšãƒ¼ã‚¸ã¯Microsoft Excel97/2000/XP(2002)ã®ãƒžã‚¯ãƒæ©Ÿèƒ½ã‚’ä½¿ç”¨ã—ã¦ã€å·¥ç¨‹ãƒ»ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ç®¡ç†ç”¨ã®ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆãƒžã‚¯ãƒã‚’ä½œã‚‹æ‰‹é †ã‚’ç¤ºã—ã€Excel VBAã®æ©Ÿèƒ½ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚Webã§å…¬é–‹ã—ã¦ã„ã‚‹ç°¡æ˜“ç‰ˆã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆã®ä½œã‚Šæ–¹ã‚’æœ¬ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ã‚‚ã—ã€ã€ŒWebã‚ˆã‚Šæœ¬ãŒè‰¯ã„ã€ã¨è€ƒãˆã¦ã„ã‚‹æ–¹ãŒãŠã‚‰ã‚Œã¾ã—ãŸã‚‰è¦‹ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆãƒžã‚¯ãƒã‚’ä½œã£ã¦å¦ã¶Excel VBA ã¾ãŸã€è‡ªåˆ†ã§å°åˆ·ã—ã¦ä½¿ã†ï¼ã¨ã„ã†äººãŒã„ã‚Œã°PDFç‰ˆã‚‚ä½œã‚Šã¾ã—ãŸã€‚ã“ã¡ã‚‰ã¯æ¿€å®‰ã§ã™ã€‚ã“ã¡ã‚‰ã‚‚åˆã‚ã›ã¦å‚ç…§ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆãƒžã‚¯ãƒã‚’ä½œã£ã¦å¦ã¶Excel VBA(PDFç‰ˆ) OpenOffice.orgã®ãƒžã‚¯ãƒã‚’ä½¿ã£ã¦ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆã‚’ä½œã£ã¦ã„ã¾ã™ãŒã€Excelç‰ˆã¨åŒæ§˜ã«OOoBasicã§ã®ä½œã‚Šæ–¹ã‚’å…¬é–‹ã™ã‚‹ã‚µã‚¤ãƒˆã‚’ä½œã‚Šã¾ã—ãŸã€‚ã“ã¡ã‚‰ã¨ã¯é•ã£ã¦Blogã‚’ä½¿ã£ã¦ä½œæˆã—ã¦ã„ã¾ã™ã®ã§ã€é€æ¬¡æ›´æ–°
whalebone 2007/02/02
excel

vba
ãƒªãƒ³ã‚¯
http://homepage.mac.com/sunagoh/
The account you requested doesn't exist or is currently inactive. Please make sure the URL is spelled and capitalized correctly, and try again.
whalebone 2006/09/18
vba
ãƒªãƒ³ã‚¯
1