1. VBAãšã¯äœã
ãŸãåãã«ãVBAã«ã€ããŠæ確ã«ç解ãæ·±ããŠãããŸããããããã§ã¯ãå ·äœçã«VBAãšã¯äœãªã®ãããŸããªããã®ååšãæ±ããããããã«ãªã£ãã®ãããã®ç¹åŸŽãŸã§èžã¿èŸŒãã§èª¬æãé²ããŠãããŸãã
1.1 VBAã®å®çŸ©
VBAãšã¯Visual Basic for Applicationsã®ç¥èªã§ããã€ã¯ããœãããæäŸããããã°ã©ãã³ã°èšèªã®ã²ãšã€ã§ããMicrosoft OfficeïŒã¯ãŒãããšã¯ã»ã«ãã¢ã¯ã»ã¹ãã¢ãŠãã«ãã¯ããã¯ãŒãã€ã³ããªã©ïŒå ã§åäœããã¢ããªã±ãŒã·ã§ã³ãäœæããããã«å©çšãããŠããŸãã
1.2 VBAãç»å Žããèæ¯
ã§ã¯ããªãVBAãšããããã°ã©ãã³ã°èšèªãçãŸããŠããã®ã§ãããããããã¯ãMicrosoft Officeãªã©ã®ãœãããŠã§ã¢ããŠãŒã¶ãŒãèªç±ã«ã«ã¹ã¿ãã€ãºããããå¹ççã«æ¥åã«æŽ»çšããããã§ãããšã¯ã»ã«ã§ããã°ãè€éãªäœæ¥ãèªåã§è¡ã£ãããç¹°ãè¿ãã®äœæ¥ãçååãããã§ããŸããã¯ãŒãã§ããã°ãææžã®æžåŒèšå®ãå°å·ãä¿åãèªååãããªã©ãæéããããã«æè»ã«æäœãå¯èœãšãªãã®ã§ãã
1.3 VBAã®ç¹åŸŽ
VBAã«ã¯ã以äžã®ãããªç¹åŸŽããããŸããäžã€ç®ã¯ããã¯ãæ©èœã§ãããã®ãã¯ãæ©èœã«ãã£ãŠãäžé£ã®æäœãèšé²ãããããåçããããšã§åãæäœãèªåçã«ç¹°ãè¿ãããšãã§ããããã«ãªããŸããäºã€ç®ã¯ãOffice補åãªã©ã«ãã«ãã€ã³ãããããã°ã©ãã³ã°ãšãã£ã¿ã§ããäºã§ããããã«ãããåOffice補åã«æé©åãããããã°ã©ãã³ã°ãå¯èœãšãªããŸããäžã€ç®ã¯ãVBAã®æã€åŒ·åãªããŒã¿åŠçèœåã§ããããã«ãããExcelã®ã»ã«ãAccessã®ããŒãã«ãªã©ãOffice補åãæã€æ§ã ãªããŒã¿ãèªç±ã«æäœããããšãã§ããŸãã
2. VBAã®æ©èœã«ã€ããŠ
ãŸãã¯ãVBAã®äžé£ã®æ©èœã«ã€ããŠèŠãŠãããŸããããVBAã«ã¯ãæ§ã ãªæ©èœãæã£ãŠãããããããäžæãçµã¿åãããŠäœ¿ãããšã§ãå¹ççã«äœæ¥ãé²ããããšãã§ããŸãã
2.1 ãã¯ãåŠç
ãã¯ãåŠçã¯ãVBAã®è±¡åŸŽçãªæ©èœã®1ã€ã§ããç¹°ãè¿ãè¡ãäœæ¥ãèªåçã«å®è¡ããããã®ããã°ã©ã ãæããVBAã䜿çšããã°ãExcelãWordã§ãã¯ããæ軜ã«äœæããããšãã§ããŸãããã®ãããç¹°ãè¿ãè¡ãäœæ¥ããã¯ãåŠçã«ãã£ãŠèªååããããšã§ãäœæ¥å¹çãå€§å¹ ã«æ¹åããããšãå¯èœã§ãã
2.2 èªååäœæ¥
VBAããã€ãã1ã€ã®å€§ããªç¹åŸŽãšããŠèªååäœæ¥ããããŸããäŸãã°ãExcelã®ã»ã«ã«å€ãåã蟌ãäœæ¥ããWordã®æç« ã®æžåŒèšå®ãªã©ãæäœæ¥ã§è¡ããšæéãããããããªäœæ¥ãVBAã§èªååããããšã§ããã®äœæ¥æéã倧ããåæžããããšãã§ããŸãã
2.3 ãŠãŒã¶ãŒãã©ãŒã ã®äœæ
VBAã䜿ãã°ãExcelãWordå ã§åããŠãŒã¶ãŒãã©ãŒã ãäœæããããšãå¯èœã§ããããã䜿ãã°ããŠãŒã¶ãŒãæäœããããã€ã³ã¿ãŒãã§ãŒã¹ãæäŸããããšãã§ããŸãããŸãããŠãŒã¶ãŒãã©ãŒã ã䜿ã£ãŠããŒã¿ã®å ¥åã䟿å©ã«ããã ãã§ãªãããããã®ããŒã¿ãåéããåæããããã®å·¥å€«ãæœãããšãå¯èœã§ãã
2.4 ã€ãã³ãé§åããã°ã©ãã³ã°
ãŸããVBAã§ã¯ã€ãã³ãé§åããã°ã©ãã³ã°ãšããã決ãŸã£ãã€ãã³ããèµ·ãã£ããšãã«ç¹å®ã®åŠçãè¡ããšããããã°ã©ãã³ã°ã¹ã¿ã€ã«ããµããŒããããŠããŸããã€ãŸããExcelã®ã»ã«ãç·šéãããããããã«å¿ããåŠçãèªåçã«è¡ã£ãããç¹å®ã®ãã¿ã³ãã¯ãªãã¯ããããæå®ã®ãã¯ããå®è¡ãããšãã£ãããšãå¯èœã«ãªããŸãã
2.5 ããŒã¿ç®¡çã»è§£æ
æåŸã«ãVBAã«ã¯ããŒã¿ã®ç®¡çã解æãå©ããæ©èœããããŸããExcelã®ã»ã«ã«å ¥åãããæ°å€ããŒã¿ãæååããŒã¿ããVBAã§ç®¡çãããããã®ããŒã¿ãåºã«å¿ èŠãªæ å ±ãæœåºã»åæããããšãã§ããŸããããã«ããã倧éã®ããŒã¿ããéèŠãªæ å ±ãèŠã€ãåºããããè€éãªããŒã¿ãæŽçã»éèšããäœæ¥ããVBAã䜿ã£ãŠå®¹æã«è¡ãããšãã§ããŸãã
3. VBAã䜿ã£ãŠã§ããããš
VBAãçšãããšãOfficeã®è€æ°ã®ã¢ããªã±ãŒã·ã§ã³ã«ãããŠãå€æ§ãªäœæ¥ãå¹çåããããšãå¯èœã«ãªããŸãããªãã§ãExcel, Word, Access, Outlook, PowerPointã®äž»èŠãª5ã€ã®ã¢ããªã±ãŒã·ã§ã³ã§ã®æŽ»çšäŸã玹ä»ããããŸãã
3.1 Excelã®èªååäœæ¥
Excelãã¯ãããšããã¹ãã¬ããã·ãŒãã¯ããžãã¹ã®çŸå Žã§é »ç¹ã«äœ¿çšãããããŒã«ã®äžã€ã§ãããVBAã䜿ããšãããã®ã¹ãã¬ããã·ãŒãã®äœæ¥ãæŽã«å¹çåããããšãå¯èœãšãªããŸããäŸãã°ãè€éãªèšç®åŠçãç¹°ãè¿ãã®ããŒã¿å ¥åäœæ¥ãè€æ°ã®ã·ãŒãéã§ã®ããŒã¿ã®ã³ããŒã»ããŒã¹ããªã©ããããŸã§æåã§è¡ã£ãŠããäœæ¥ãèªååããããšãã§ããŸãããŸããããŒã¿ã®éèšãåæãã°ã©ãäœæãVBAã䜿ãããšã§äžç¬ã«å®è¡ããããšãåºæ¥ãŸãã
3.2 Wordã®èªååäœæ¥
Wordã«ãããŠãåæ§ã«VBAã¯éåžžã«äŸ¿å©ã§ããç¹éãªææžäœæäœæ¥ãç¹å®æååã®äžæ¬çœ®æãè€éãªæžåŒèšå®ãªã©ãäžç¬ã§èªååããããšãå¯èœãšãªããŸããããã«ãããHeap,ã«ãŒãã£ã³ãªæ¥åã®èªååã«ããæéãæå¹ã«æŽ»çšã§ããŸãã
3.3 Accessã®ããŒã¿æäœ
Accessã¯ãããŒã¿ããŒã¹ç®¡çã·ã¹ãã ãšããŠãã䜿çšãããŸããVBAã䜿çšããããšã§ãè€éãªã¬ã³ãŒãã®æ€çŽ¢ãç·šéããã·ã³æ¯ã«ç°ãªãèšå®ãäžæ¬ã§å€æŽãããªã©ãè€éãªããŒã¿æäœãå®è£ ããããšãå¯èœã«ãªããŸãã
3.4 Outlookã®ã¡ãŒã«éä¿¡å¹çå
Outlookã§ã¯ãVBAã䜿çšããŠèªåã§ã¡ãŒã«ãéä¿¡ããã¹ã¯ãªãããäœæããããšãã§ããŸããããã«ããã倧éã®ã¡ãŒã«ãéä¿¡ããªããã°ãªããªãéã«ãã¯ã³ã¯ãªãã¯ã§äžæéä¿¡ããããšãå¯èœã«ãªããŸãããŸããã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ãšçµã¿åãããããšã§ãå®æçãªã¡ãŒã«éä¿¡ãèªååããããšãå¯èœã§ãã
3.5 PowerPointã®ãã¬ãŒã³ããŒã·ã§ã³å¹çå
PowerPointã«ãããŠã¯ãVBAã䜿çšããŠã¹ã©ã€ãäœæã®å¹çåãå¯èœã§ããäŸãã°ãç¹å®ã®ãã³ãã¬ãŒãã䜿çšããã¹ã©ã€ãäœæããExcelãªã©ä»ã®ã¢ããªã±ãŒã·ã§ã³ããã®ããŒã¿åã蟌ã¿ã«ããã°ã©ãäœæãªã©ãèªååããããšãã§ããŸãã
以äžã®ããã«ãVBAã®æŽ»çšäºäŸã¯å€å²ã«ããããŸããVBAã¯ãäžåºŠåŠã¹ã°ããã以éã©ããªäœæ¥ã§ãç¹°ãè¿ãå©çšããããšãã§ããå¹ççãªæ¥åéè¡ã«å€§ãã«è²¢ç®ããŸãã
4. VBAã®åºæ¬çãªæ§æ
VBAã®åºæ¬çãªæ§æãç¥ãããšã§ãèªåèªèº«ã§VBAãå©çšããé åãåºãããŸããããã§ã¯ããŸãæåã«ãå€æ°ã®å®£èšãšå©çšãã«ã€ããŠèŠãŠãããŸãããã
4.1 å€æ°ã®å®£èšãšå©çš
å€æ°ãšã¯ãå€ãäžæçã«æ ŒçŽããããã®ãç®±ãã®ãããªãã®ã§ããVBAã§ã¯ãå€æ°ãçšããåã«å¿ ã宣èšããããšãæ±ããããŸããäŸãã°ãæååãæ ŒçŽããå€æ°ã¯ä»¥äžã®ãããªåœ¢ã§å®£èšããŸãã
Dim str As String
ãã®ããã«ãDimã®åŸã«å€æ°åããã®åŸã«Asãšååãèšè¿°ããŸãããŸããå€æ°ã«å€ãä»£å ¥ããã«ã¯ä»¥äžã®ããã«è¡ããŸãã
str = "ããã«ã¡ã¯ãVBA!"
ããã§ãstrãå€æ°ã«ãããã«ã¡ã¯ãVBA!ããæ ŒçŽããã圢ã«ãªããŸãã
4.2 ãµãããã·ãŒãžã£ãšé¢æ°
次ã«ãVBAã§éèŠãªåœ¹å²ãæããããµãããã·ãŒãžã£ããšãé¢æ°ãã«ã€ããŠèª¬æããŸãã
ãµãããã·ãŒãžã£ã¯ãç¹å®ã®ã³ãŒããã°ã«ãŒãåããŠååãã€ãããã®ã§ããããã«ãããå¿ èŠãªãšãã«ãã®ã³ãŒããåŒã³åºãããšãå¯èœã«ãªããŸãã
äžæ¹ãé¢æ°ããµãããã·ãŒãžã£ãšåæ§ã«ã³ãŒããã°ã«ãŒãåããŸãããçµæã®å€ãè¿ããšããç¹æ§ããããŸããæ°å€ã®èšç®ãæååã®æäœãªã©ãäœããåŠçããŠçµæãåŸãããšãã«ããå©çšãããŸãã
4.3 å¶åŸ¡æïŒifãforãwhileãªã©ïŒ
ãããŠãVBAã«ã¯æ¡ä»¶ã«ãã£ãŠåŠçãåããããç¹°ãè¿ãåŠçãè¡ãããã®å¶åŸ¡æããããŸãã
Ifæã¯æ¡ä»¶ãçïŒTrueïŒã®å Žåã«ã ãåŠçãè¡ãå¶åŸ¡æã§ãã以äžã«å ·äœäŸã瀺ããŸãã
If score >= 60 Then grade = " pass" Else grade = " fail" End If
ãã®ã³ãŒãã¯ãscoreãã®å€ã60以äžã®å Žåãgradeãã«ãpassããããã以å€ã®å Žåã«ã¯ãfailããä»£å ¥ããŸãã
4.4 ãšã©ãŒãã³ããªã³ã°
æåŸã«ãVBAã«ããããšã©ãŒãã³ããªã³ã°ã«ã€ããŠè§£èª¬ããŸãããšã©ãŒãã³ããªã³ã°ãšã¯ãã³ãŒãã®å®è¡äžã«ãšã©ãŒãçºçãããšãã«äºãå®ããããåŠçãè¡ãããšãæããŸãã
ãšã©ãŒãã³ããªã³ã°ãå°å ¥ããããšã§ããšã©ãŒãçºçããŠãããã°ã©ã ãäžæãããããšãªããé©åãªåŠçãè¡ã£ãäžã§ããã°ã©ã ãç¶è¡ããããšãå¯èœã«ãªããŸããããã«ããã䜿çšè ã«å®å®ããåäœãæäŸããããšãã§ããŸãã
5. VBAã®æŽ»çšäŸ
VBAã¯ãæ¥åžžæ¥åãå¹çåããããã«å€é¢çã«æŽ»çšããããšãã§ããŸãã以äžã«ãå ·äœçãªæŽ»çšäŸãšãã®æ¹æ³ã説æããŸãã
5.1 Excelã§ã®åšåº«ç®¡ç
äžã€ç®ã®æŽ»çšäŸãšããŠã¯ãExcelã§ã®åšåº«ç®¡çãæããããŸããåšåº«ç®¡çã¯äžèŠåçŽãªäœæ¥ã®ããã«èŠããŸãããååã®çš®é¡ãå€å²ã«ããããã²ãšã€ã²ãšã€ã®æ°éã確èªãããšãªããšéåžžã«æéãããããŸããããããVBAã掻çšããã°ãåšåº«æ°ãèªåã§èšç®ããäžè¶³ããŠããååãäžèŠ§è¡šç€ºããããåšåº«ãäžå®æ°ãäžåã£ããè£å ãä¿ãéç¥ãåºãããªã©ãšãã£ãèªååãå¯èœãšãªããŸãã
5.2 Wordã§ã®æžåŒèšå®
次ã«ãWordã§ã®æžåŒèšå®ã«é¢ããŠã§ããå ±åæžãè«æã®äœææãäžã€äžã€ã®èŠåºããç®æ¡æžãã®æžåŒãæåã§èšå®ããã®ã¯éçšãé·ããªããŸããVBAãå©çšããã°ããããã®æžåŒèšå®ãäžæ¬ã§è¡ãããšãã§ããã®ã§ããäŸãã°ãå šãŠã®èŠåºããäžå®ã®ãã©ã³ãããµã€ãºã«ãªãããèšå®ããããç¹å®ã®ããŒã¯ãŒããå«ãŸããæç« ã®è²ãå€æŽãããªã©ã现ããèšå®ãå¹çããè¡ãããšãã§ããŸãã
5.3 Accessã§ã®ããŒã¿éèšãšè§£æ
Accessã§ã®ããŒã¿éèšãšè§£æãVBAã®åãåããããšã§åçã«æ¥œã«ãªããŸããããç¹å®ã®æ¡ä»¶ã«åèŽããããŒã¿ã ããæœåºããããããŒã¿ãç¹å®ã®åœ¢åŒã§è¡šç€ºããããéèšçµæãèªåã§ã°ã©ãåããããšãäžé£ã®äœæ¥ãç°¡åã«èªååããããšãå¯èœã§ãã
5.4 Outlookã®ã¡ãŒã«äžæéä¿¡
ãŸããã¡ãŒã«ã®äžæéä¿¡ãšããäœæ¥ãVBAã掻çšããã°å¹çãäžãããŸããè€æ°äººã«åãå 容ã®ã¡ãŒã«ãäžæéä¿¡ããéãOutlookã®VBAã䜿ãã°éä¿¡å ã®ã¢ãã¬ã¹ãäžæ¬ã§å ¥åããããæ¬æã®äžéšãå€æŽãããããããšãã§ããŸãã
5.5 PowerPointã§ã®å ±åæžäœæ
æåŸã«ãPowerPointã§ã®å ±åæžäœæãå¹çåã®å¯Ÿè±¡ãšãªããŸãããã³ãã¬ãŒããä»ããŠãã¬ãŒã³ããŒã·ã§ã³ãäœæããéãVBAã䜿ã£ãŠåãã¹ã©ã€ããè€æ°çæããããããã®ã¹ã©ã€ãã«ããŒã¿ãæ¿å ¥ãããšãã£ãäœæ¥ãã¯ã³ã¯ãªãã¯ã§å¯èœãšãªããŸãã
VBAã掻çšããã°ããããã®äžèŠç ©éãªäœæ¥ãã¹ã ãŒãºã«ãå¹çããè¡ãããšãå¯èœãšãªããŸããVBAã®åŠç¿ãéããŠãçããã®æ¥ã ã®æ¥åãå¹çåããæå©ãã«ãªãã°å¹žãã§ãã
6. VBAãåŠã¶äžã§ã®ã³ããšæ³šæç¹
VBAãåŠã¶ããã«ã¯ããã€ãã®ã³ãããããŸããããã§ã¯VBAãå¹ççã«åŠã¶ããã®ïŒã€ã®ãã€ã³ãã«ã€ããŠè§£èª¬ããŸãã
6.1 ç·Žç¿åé¡ã解ã
ãŸãç·Žç¿åé¡ã解ãããšããå§ããŸããããããã°ã©ãã³ã°ã«ãããŠã¯ç解ããå 容ãããã«å®è·µããããšãåŠç¿å¹çã®åäžã«ã€ãªãããŸããç·Žç¿åé¡ãå€å²ã«ããããVBAã®åºæ¬çãªæ§æããå¿çšãŸã§å¯Ÿå¿ãããã®ããããŸããåå¿è ããäžçŽè ãŸã§èªåã®ã¹ãã«ã¬ãã«ã«åãããåé¡ãéžã¶ããšãéèŠã§ãã
6.2 ãšã©ãŒã¡ãã»ãŒãžãç解ãã
次ã«ããšã©ãŒã¡ãã»ãŒãžãç解ããããšã倧åã§ããã³ãŒããããŸãåããªããšããå¿ ããšã©ãŒã¡ãã»ãŒãžã衚瀺ãããŸããåããŠèŠããšã©ãŒã¡ãã»ãŒãžã¯è§£èªãé£ãããããããŸããããããããã®ã¡ãã»ãŒãžãã©ã®ãããªãšã©ãŒã瀺ããŠããã®ãç解ããããšã§ãåé¡ã®è§£æ±ºã«æåŸ ãæãŠãŸãã
6.3 ãããã°ã®æ¹æ³
ãã®åŸã¯ããããã°ã®æ¹æ³ã身ã«ã€ããŸãããããããã°ã¯ã³ãŒãã®ãšã©ãŒãèŠã€ããŠä¿®æ£ããããšã§ããåå äžæã®ãšã©ãŒã«ééããéããããã°æ©èœã®äœ¿ãæ¹ãç解ããŠããã°è¿ éã«åé¡ã®åå ãç¹å®ããä¿®æ£ããããšãå¯èœãšãªããŸãã
6.4 å®æçã«ããŒãžã§ã³ã¢ãããè¡ã
æåŸã«ãå®æçã«VBAã®ããŒãžã§ã³ã¢ãããè¡ãããšãå¿ããªãã§ãã ãããæ°ããããŒãžã§ã³ã«ã¯ã»ãã¥ãªãã£ã®æ¹åãæ°æ©èœãå«ãŸããŠãããåžžã«ææ°ã®ç¶æ ãä¿ã€ããšã§æŽãªãå¹çåãæåŸ ããããšãã§ããŸãã
VBAã®åŠç¿ã¯äžåºŠã«ãã¹ãŠãç解ããããšãããåºæ¬çãªæ§æããå§ããŠåŸã ã«å¿çšãžãšé²ããŠããããšãéèŠã§ããä»è¿°ã¹ãïŒã€ã®ãã€ã³ãã掻çšããªãããèªåã®ããŒã¹ã§ç¡çãªãåŠãã§ã¿ãŠãã ããã
7. ãŸãšã
VBAãšã¯ãMicrosoft Officeã®ã¢ããªã±ãŒã·ã§ã³ãããå¹ççã«å©çšããããã®éèŠãªããŒã«ã§ããäžèšã§è¡šããšããã¯ããšããèªååæè¡ã§ãäœæ¥äžã«ç¹°ãè¿ãè¡ãæäœãèªåã§åŠçããããšãå¯èœã«ãªããŸãã
ä»åã®èšäºã§ã¯ãVBAã®åºæ¬çãªæ©èœããå ·äœçãªæŽ»çšäŸãŸã§ãå¹ åºãã玹ä»ããŸãããExcelã§ã®åšåº«ç®¡çãWordã§ã®æžåŒèšå®ãOutlookã§ã®äžæã¡ãŒã«éä¿¡ãªã©ãæ¥é ã®æ¥åã®äŸ¿å©ãªããŒã«ãšããŠãVBAã®äœ¿çšã«ããæéã®ç¯çŽãäœæ¥ã®å¹çåãå®çŸã§ããŸãã
ãŸããVBAã®åºæ¬çãªææ³ãæ§æã«ã€ããŠã觊ããŸãããå€æ°ã®å®£èšãå¶åŸ¡æããšã©ãŒãã³ããªã³ã°ãªã©ãããã°ã©ãã³ã°åå¿è ã«ãç解ããããå 容ã§è§£èª¬ããŸããããããã®åºæ¬çãªç¥èãç解ãã掻çšããããšã§ãèªåã ãã®ãªãªãžãã«ã®VBAããã°ã©ã ãäœæããæ©ã¿ãèžã¿åºãããšãã§ããŸãã
VBAã¯å匷ããã°ããã»ã©ããã®å¯èœæ§ãåºãã£ãŠãããŸãã ãã²æ¬èšäºããã£ããã«ãVBAã®åŠç¿ã«åãçµãã§ã¿ãŠã¯ãããã§ãããããããªãã®å¹ççãªæ¥åéè¡ãæ¯ããçŽ æŽãããããŒã«ãšãªãããšã§ãããã