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

Abotan id:Abotan

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

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

http://www.mothprog.com/prog/exceldb/exceldb2-2.html
Abotan 2005/10/12
VBAã§ã¯ã€Objectåž‹ã‚’ä¸Šæ‰‹ãæ´»ç”¨ã™ã‚‹ã“ã¨ã§ã€ç¶™æ‰¿ã‚’æ“¬ä¼¼çš„ã«è¡¨ç¾ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚

software

MS

VBA

programming

oop
ãƒªãƒ³ã‚¯
http://homepage1.nifty.com/MADIA/vb/vb_bbs/index.html
Abotan 2005/10/12
software

MS

VBA

programming

faq
ãƒªãƒ³ã‚¯
Office VBAã®éƒ¨å±‹
Microsoft Officeã®VBAã‚’ã‹ã˜ã£ã¦ã„ã¾ã™ã€‚ä¸»ã«Excel VBAã«ã¤ã„ã¦æ›¸ã„ã¦ã„ã¾ã™ãŒWord, Outlookã«ã¤ã„ã¦ã‚‚æ›¸ã„ã¦ã„ã¾ã™ã€‚ã”æ„è¦‹ã€ã”æ„Ÿæƒ³ã€ã”è¦æœ›ã®ã‚ã‚‹æ–¹ã¯ã“ã¡ã‚‰ã¾ã§ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã«å«ã¾ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã€ãƒ•ã‚¡ã‚¤ãƒ«ç‰ã«ã¤ã„ã¦ã¯ã€ ä¸€å¿œã€è‘—ä½œæ¨©ã¯æ”¾æ£„ã—ã¦ã¾ã›ã‚“ã€‚è»¢è¼‰ç‰ã•ã‚Œã‚‹æ–¹ã¯ç§ã«ã”é€£çµ¡ãã ã•ã„ã€‚ å†…å®¹ã«ã¤ã„ã¦ã¯ä¸‡å…¨ã‚’æœŸã—ã¦ã„ã¾ã™ãŒã€åˆ©ç”¨ã«ã¤ã„ã¦ã¯è‡ªå·±è²¬ä»»ã§ãŠé¡˜ã„ã—ã¾ã™ã€‚ã„ã‹ãªã‚‹æå®³ã«ã‚‚è²¬ä»»ã‚’è² ã„ã¾ã›ã‚“ã€‚ å‹•ä½œç¢ºèªã¯ã€(1)Windows 98+Excel 2000; (2)Windows XP+Excel 2002ã§è¡Œã£ã¦ã„ã¾ã™ã€‚ ä»¥ä¸Šã®ç‚¹ã«ã”æ³¨æ„é¡˜ã„ã¾ã™ã€‚ ç›®æ¬¡ Officeä¸€èˆ¬ å®Ÿç”¨(?)ãƒžã‚¯ãƒé›† å®Ÿç”¨(?)ãƒ’ãƒ³ãƒˆé›† Class Moduleã«ã¤ã„ã¦ Excel å®Ÿç”¨(?)VBAãƒ•ã‚¡ã‚¤ãƒ«é›† å®Ÿç”¨(?)ãƒžã‚¯ãƒé›† å®Ÿç”¨(?)ãƒ’ãƒ³ãƒˆé›† Word å®Ÿç”¨(?)ãƒžã‚¯ãƒé›† O
Abotan 2005/10/12
Withã®ç½ ãªã©

software

MS

VBA

programming

tips
ãƒªãƒ³ã‚¯
- Excel VBA - Decorator ãƒ‘ã‚¿ãƒ¼ãƒ³ãƒ¢ãƒ‡ãƒ«
1999/08/27 æ›´æ–° çŸ³äº• å‹ æ¦‚è¦ ã“ã“ã§ã¯ï¼ŒDecorator ãƒ‘ã‚¿ãƒ¼ãƒ³ãƒ¢ãƒ‡ãƒ«ã¨ã„ã† Excel ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«é–¢ã™ã‚‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’è§£èª¬ã—ã¾ã™ï¼Žã“ã‚Œã¯ï¼ŒDecorator ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ¬ãƒ™ãƒ«ã«ã¾ã§æ‹¡å¼µã—ãŸãƒ¢ãƒ‡ãƒ«ã§ï¼Œç¶™æ‰¿ãŒä½¿ãˆãªã„ VB ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§å¨åŠ›ã‚’ç™ºæ®ã™ã‚‹ã¨æ€ã„ã¾ã™ï¼Žã¾ã å®Ÿé¨“æ®µéšŽãªã®ã§ï¼Œã“ã®ãƒ¢ãƒ‡ãƒ«ãŒå®Ÿç”¨åŒ–ã§ãã‚‹ã‹ã¯ä»Šå¾Œã®èª²é¡Œã§ã™ï¼Ž Excel ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¨ã¯ï¼Ÿ Excel ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’ä¸€è¨€ã§è¡¨ã™ã¨ï¼ŒVBA ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ Excel ã‚’æ‹¡å¼µã™ã‚‹ï¼Œã¨ã„ã†ã“ã¨ã§ã™ï¼Žã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã®ç«‹å ´ã§æ‹¡å¼µã¨ã„ãˆã°ï¼Œç¶™æ‰¿ã§ã™ãï¼Žã—ãŸãŒã£ã¦æ¬¡ã®ã‚ˆã†ã«ä»»æ„ã® ExcelObject ã‚¯ãƒ©ã‚¹ã‚’ç¶™æ‰¿ã—ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ãã‚Œã°ã„ã„ã§ã™ãï¼š ä¾‹ãˆã° Worksheet ã‚¯ãƒ©ã‚¹ã‹ã‚‰ MyWorksheet ã‚¯ãƒ©ã‚¹ã‚’ç¶™æ‰¿ã™ã‚Œã°ã„ã„ã‚ã‘ã§ã™ï¼Žãã†ã™ã‚‹ã¨æœ›ã¿ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã•ã‚ŒãŸãƒ¯
Abotan 2005/10/12
ã‚¯ãƒ©ã‚¹ã®æ‹¡å¼µ?

software

MS

VBA

programming

oop

è§£èª¬
ãƒªãƒ³ã‚¯
ãƒ—ãƒãƒ‘ãƒ†ã‚£
VB ã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹éš›ã€ä½•æ°—ãªãä½¿ã£ã¦ã„ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã€‚ ãƒ—ãƒãƒ‘ãƒ†ã‚£ã¨ã¯ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®çŠ¶æ…‹ã‚’è¡¨ã™å€¤ï¼ˆå¤‰æ•°ï¼‰ã§ã™ã€‚ ãŸã ã—ã€ãƒ—ãƒãƒ‘ãƒ†ã‚£ã¯å˜ãªã‚‹å¤‰æ•°ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãƒ—ãƒãƒ‘ãƒ†ã‚£ã«å€¤ã‚’è¨å®šã™ã‚‹ã“ã¨ã§ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®å¤–è¦‹ãŒå¤‰ã‚ã£ãŸã‚Šã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ï¼ˆãŸã¨ãˆã°ã€ãƒ•ã‚©ãƒ¼ãƒ ã® Caption ãƒ—ãƒãƒ‘ãƒ†ã‚£ã®æ–‡å—åˆ—ã‚’å¤‰æ›´ã™ã‚‹ã¨ã€ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚¿ã‚¤ãƒˆãƒ«ãŒå¤‰æ›´ã•ã‚Œã¾ã™ãã€‚ï¼‰ã¾ãŸã€å€¤ã®å–å¾—ï¼ˆå‚ç…§ï¼‰ã ã‘ã‚’è¨±ã—ã€æ›¸ãè¾¼ã¿ãŒã§ããªã„ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ã€ãã‚“ãªãƒ—ãƒãƒ‘ãƒ†ã‚£ã®æ€§è³ªã‚„å®Ÿè£…æ–¹æ³•ã‚’è¦‹ã¦ã‚†ãã¾ã™ã€‚ æ§‹é€ ä½“ã‚’ã‚¯ãƒ©ã‚¹ã«ç™ºå±•ã•ã›ã‚‹ å€¤ã®å–å¾—ã¨è¨å®š ã²ã¨ã™ã˜ãªã‚ã§ã¯ãªã„ãƒ—ãƒãƒ‘ãƒ†ã‚£ ãƒ—ãƒãƒ‘ãƒ†ã‚£ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ ãƒ—ãƒãƒ‘ãƒ†ã‚£å€¤ã®ä¿å˜ ãƒ—ãƒãƒ‘ãƒ†ã‚£å¤‰æ•°ã¨ãƒ—ãƒãƒ‘ãƒ†ã‚£ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ãƒªãƒ³ã‚¯ æ§‹é€ ä½“ã‚’ã‚¯ãƒ©ã‚¹ã«ç™ºå±•ã•ã›ã‚‹ æ§‹é€ ä½“ã‚’ã‚¯ãƒ©ã‚¹ã«ç™ºå±•ã•ã›ã‚‹å ´åˆã€æ§‹é€ ä½“ã®å„ãƒ‡ãƒ¼ã‚¿ãŒã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã«ãªã‚Šã¾ã™ã€‚ 'æ§‹é€ ä½“
Abotan 2005/10/12
ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ã€ãƒãƒªãƒ¢ãƒ¼ãƒ•ã‚£ã‚ºãƒ

software

MS

VBA

programming

oop

è§£èª¬
ãƒªãƒ³ã‚¯
ï¼¥ï½˜ï½ƒï½…ï½Œå…¨é–‹ï¼¶ï¼¢ï¼¡
With Selection.Borders(ç½«ç·šã®ä½ç½®) .LineStyle = ç½«ç·šã®ç¨®é¡žã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ãƒ»ãƒ»ãƒ»ã“ã“ã«å…¥ã‚‹æ–‡å—ã¯ä¸‹è¨˜ã®é€šã‚Šã§ã™ã€‚ .Weight = ç½«ç·šã®å¤ªã• .ColorIndex = ç½«ç·šã®è‰²æŒ‡å®š End With
Abotan 2005/10/12
software

MS

VBA

programming
ãƒªãƒ³ã‚¯
Officeå‚è€ƒæ›¸
ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã‚„ãƒ¯ãƒ¼ãƒ‰åŸºç¤Žã‹ã‚‰ã€ã‚ªãƒ¼ãƒˆã‚·ã‚§ã‚¤ãƒ—ç”»åŸºæœ¬è¬›åº§ã¾ã§ã€ å¤šæ•°ã®ç”»åƒã¨ç´°ã‹ãªæ‰‹é †èª¬æ˜Žã€ã‚µãƒ³ãƒ—ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã§å¦ç¿’ã§ãã‚‹ãƒ¢ãƒ¼ã‚°å¦ç¿’å®¤ã€‚ å®Ÿéš›ã«æ“ä½œã‚’è¡Œã„ãªãŒã‚‰ç¢ºå®Ÿã«ç†è§£ã—ã¦ã„ãã“ã¨ãŒã§ãã¾ã™ï¼ * è¬›åº§ã‚„ç´¹ä»‹ã™ã‚‹æ©Ÿèƒ½ã«ã‚ˆã‚Šã‚µãƒ³ãƒ—ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ãŒãªã„å ´åˆã‚‚ã‚ã‚Šã¾ã™ Excel åŸºç¤Ž 1ãƒ¬ãƒƒã‚¹ãƒ³ãŒçŸæ™‚é–“ã§çµ‚äº†ã™ã‚‹ã®ã§ã€æ™‚é–“ãŒãªã„æ™‚ã«å°‘ã—ãšã¤ã§ã‚‚å‹‰å¼·ã§ãã¾ã™ã€‚ è‡ªåˆ†ã®äºˆå®šã«ã‚ã‚ã›ã¦å¦ç¿’ã—ã¦ã¿ã¾ã—ã‚‡ã†ï¼ï¼ˆå…¨9å›ž 64ãƒ¬ãƒƒã‚¹ãƒ³æŽ²è¼‰ ï¼‰ Word åŸºç¤Ž 1ãƒ¬ãƒƒã‚¹ãƒ³ãŒçŸæ™‚é–“ã§çµ‚äº†ã™ã‚‹ã®ã§ã€æ™‚é–“ãŒãªã„æ™‚ã«å°‘ã—ãšã¤ã§ã‚‚å‹‰å¼·ã§ãã¾ã™ã€‚ è‡ªåˆ†ã®äºˆå®šã«ã‚ã‚ã›ã¦å¦ç¿’ã—ã¦ã¿ã¾ã—ã‚‡ã†ï¼ï¼ˆå…¨7å›ž 67ãƒ¬ãƒƒã‚¹ãƒ³æŽ²è¼‰ï¼‰ Excel é–¢æ•° Excelã«ã¯ä¾¿åˆ©ãªé–¢æ•°ãŒå¤šæ•°ç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ é–¢æ•°ã®ä¾¿åˆ©ãªä½¿ã„æ–¹ã‚’è§£èª¬ã—ã¾ã™ï¼ ï¼ˆå…¨11å›žï¼‰ ä»•äº‹ã«å½¹ç«‹ã¤ Excel é–¢æ•° æ™®æ®µä½¿ç”¨ã—ã¦ã„ã‚‹é–¢æ•°ãŒåˆ¥ã®ä½¿ã„æ–¹ã‚‚ã§ãã‚‹ï¼Ÿï¼ ã€Žä»•äº‹ã«å½¹ç«‹ã¤ Ex
Abotan 2005/10/12
ã‚¯ãƒ©ã‚¹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ãŸï½ž

software

MS

VBA

programming

è§£èª¬
ãƒªãƒ³ã‚¯
ï¼¥ï½˜ï½ƒï½…ï½Œå…¨é–‹ï¼¶ï¼¢ï¼¡
Abotan 2005/10/12
software

MS

VBA

programming
ãƒªãƒ³ã‚¯
ExcelVBAãƒ¡ãƒ‹ãƒ¥ãƒ¼
ãƒ‰ãƒ©ã‚¤ãƒ–ãƒ»ãƒ•ã‚©ãƒ«ãƒ€ã®æ“ä½œã€ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–°è¦ä½œæˆãƒ»å±•é–‹ãƒ»æ¤œç´¢ã€å±žæ€§ã®å–å¾—ãƒ»è¨å®šã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿å˜ãƒ»é–‰ã˜ã‚‹ã€ãƒ•ã‚¡ã‚¤ãƒ«ã®å¤‰æ›´ãƒ»è¤‡å†™ãƒ»ç§»å‹•ãƒ»ä¿è·ãƒ»å‰Šé™¤
Abotan 2005/10/12
Excel VBA Parts Collection

software

MS

VBA

programming

excel
ãƒªãƒ³ã‚¯
Excelã§ãŠä»•äº‹ï¼ã€ŒVBAåŸºæœ¬ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼
Abotan 2005/10/12
software

MS

VBA

programming

excel
ãƒªãƒ³ã‚¯
MSDN ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸
Abotan 2005/10/12
æ–‡å—åˆ—ã¨æ—¥ä»˜ã®æ“ä½œï¼šVBA ã®ãƒ’ãƒ³ãƒˆã¨ã‚³ãƒ„

software

MS

VBA

programming

tips
ãƒªãƒ³ã‚¯
http://www1.plala.or.jp/happyday/
Abotan 2005/10/12
ãƒ‘ã‚½ã‚³ãƒ³ã¨Excelã®åˆå¿ƒè€…ãŒã‚³ãƒ„ã‚³ãƒ„ã¨è¦šãˆãŸVBAã‚’ã”ç´¹ä»‹ã™ã‚‹ã‚µã‚¤ãƒˆ

software

MS

VBA

programming

excel
ãƒªãƒ³ã‚¯
å¤ªå…¬æœ›ã®Excel ï¼¶ï¼¢ï¼¡é›†
Excelã®ãƒžã‚¯ãƒé›†ã§ã™ã€‚ã™ã¹ã¦ç”Ÿã®ãƒžã‚¯ãƒã§ã€åˆå¿ƒè€…ã«æœ€é©ã€‚300å‰å¾Œã®æ±Žç”¨æ€§ã®ã‚ã‚‹ãƒžã‚¯ãƒã€‚ä¸å¹´ã®æ‚²å“€ã‚‚
Abotan 2005/10/12
VBA

software

MS

VBA

programming

excel
ãƒªãƒ³ã‚¯
1