ææ°ã®AIæè¡ãChatGPTããšããªãã£ã¹ã§åºãå©çšããããVBAããã°ã©ãã³ã°ãã®çµã¿åããã«ãããæ¥åå¹çåã®æ°ããªæãéãããšããŠããŸããããžãã¹ããŒãœã³ã®çæ§ãæ±ããããŒã¿åŠçãæ¥åžžæ¥åã®èªååã«ããã£ãããããæè¡ã圹ç«ãŠãããšãã§ããã®ã§ããæ¬ã³ã³ãã³ãã§ã¯ãChatGPTã®åºæ¬ããVBAãšã®é£æºæ¹æ³ããããŠå®è·µçãªå¿çšäŸãŸã§ãå ·äœçãã€æ®µéçã«ã玹ä»ããŸããåå¿è ã§ãå®å¿ã®éçºç°å¢èšå®ãããäžçŽè ã®ããã®ãã¥ãŒããªã¢ã«ãŸã§ãããžãã¹ã«ãããChatGPT VBAããã°ã©ãã³ã°ã®é åã«è¿«ããŸãã
1. ChatGPTãšVBAã®åºæ¬
1.1 ChatGPTãšã¯äœãïŒ
ChatGPTã¯ãèªç¶èšèªåŠçãè¡ã人工ç¥èœã«åºã¥ããã¢ãã«ã§ããOpenAIã«ãã£ãŠéçºããã人éã®èšèã«è¿ãã¬ãã«ã§ã®ææžçæãå¯èœãªæè¡ã§ããäŒè©±åã®ã€ã³ã¿ã©ã¯ã·ã§ã³ãæå³ããŠããããŠãŒã¶ãŒããã®å ¥åã«å¯ŸããŠæè²çãã€æ å ±çãªå¿çãè¡ããŸãã
ãã®æè¡ã¯ããŠãŒã¶ãŒãäœæããæ瀺ã«åºã¥ããããã°ã©ãã³ã°ã³ãŒãã®äŸãäœæãããããã¯ãã«ã«ã©ã€ãã£ã³ã°ãå©ãããããããšãã§ãããããéçºè ã³ãã¥ããã£ã§æ³šç®ãéããŠããŸããç¹ã«VBAããã®ä»ã®ããã°ã©ãã³ã°èšèªã®åŠç¿è ã«ãšã£ãŠã¯ãã³ãŒãã®çæãããžãã¯ã®æ§ç¯ãªã©ã«å€§ãã«åœ¹ç«ã€ããŒã«ãšãªã£ãŠããŸãã
ChatGPTã¯ããã®å¿çæ§ãšé©å¿æ§ã«ããããœãããŠã§ã¢éçºè ããšã³ããŠãŒã¶ãŒéã§ã®ã³ãã¥ãã±ãŒã·ã§ã³ã容æã«ããããšãã§ãããã®ãããããã°ã©ã ã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°ããŠãŒã¶ãŒãµããŒããæè²çãªã¬ã€ãäœæãªã©ãå€æ¹é¢ã§å©çšãå¯èœã§ãã
1.2 VBAããã°ã©ãã³ã°ã®åºç€
Visual Basic for ApplicationsïŒVBAïŒã¯ãäž»ã«Microsoft Office補åããªãŒãã¡ãŒã·ã§ã³ããããã«äœ¿çšãããããã°ã©ãã³ã°èšèªã§ããExcelãAccessãWordãªã©ã®ã¢ããªã±ãŒã·ã§ã³å ã§ã«ã¹ã¿ã ãã¯ãã®äœæãæ©èœã®æ¡åŒµãè¡ãããããæ¥åã®å¹çåã«å€§ããå¯äžããŸãã
VBAã¯ã€ãã³ãé§ååèšèªã§ãããç¹å®ã®ã¢ã¯ã·ã§ã³ïŒäŸãã°ãã¿ã³ã¯ãªãã¯ãã·ãŒãã®å€æŽïŒã«å¿ããŠã³ãŒããå®è¡ãããŸãããŸãããªããžã§ã¯ãæåã®ç¹æ§ãæã€ãããæäœå¯Ÿè±¡ã®ãªããžã§ã¯ãïŒã»ã«ãç¯å²ãã·ãŒããªã©ïŒã«çŽæ¥åœä»€ãäžããããšãã§ããã®ã§ãã
åºæ¬ã®æ§æãåŠã¶ããšã¯æ¯èŒçç°¡åã§ãããã°ã©ãã³ã°åå¿è ã«ãã¢ã¯ã»ã¹ããããèšèªãšèšããŸããããããªãããè€éãªããŒã¿åŠçããŠãŒã¶ãŒå®çŸ©é¢æ°ã®äœæãªã©ããããã§ãã·ã§ãã«ãªã¹ãã«ãæ±ããããå Žé¢ãå°ãªããããŸããã
1.3 ChatGPTãVBAã§æŽ»çšããã¡ãªãã
VBAãçšãããã¯ããã¢ããªã±ãŒã·ã§ã³ã®éçºæã«ChatGPTã掻çšããããšã§ãããã€ãã®ã¡ãªããããããŸããæã倧ããªã¡ãªããã¯ãããã°ã©ãã³ã°ã®å¹çåã§ããããChatGPTã¯ããã°ã©ãã³ã°ã®ãµã³ãã«ãæ瀺ããããéçºéäžã®ã³ãŒãã®ãããã°ãæå©ãããŠãããå¯èœæ§ããããŸãã
ãŸããèªç¶èšèªåŠçã®æ©èœãå©çšããŠããŠãŒã¶ãŒãç°¡åãªèšèã§èŠæ±ãè¡šçŸããã ãã§ãChatGPTãé©åãªVBAã³ãŒããçæãããšãã£ãã€ã³ã¿ã©ã¯ãã£ããªéçºäœéšãæäŸããŸããããã«ãããéçºã«å¿ èŠãªæéãå€§å¹ ã«ççž®ããããã«ã¯ãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ãåäžãããŸãã
ããã«ãChatGPTã䜿çšããŠVBAã®ææ³ãããžãã¯ã®åŠç¿ãé²ããããšãã§ããŸããããã¯ç¹ã«ååŠè ãéæè¡çãªããã¯ã°ã©ãŠã³ãã®ãããŠãŒã¶ãŒã«ãšã£ãŠãããå®è·µçã§çŽæçãªåŠç¿ç°å¢ãæäŸããããšãã§ããŸãã
1.4 VBAã®éçºç°å¢ã®èšå®
VBAãå©çšããããã«ã¯ããŸãã¯éçºç°å¢ã®èšå®ãè¡ãå¿ èŠããããŸããMicrosoft Office補åã«ã¯ãæšæºã§VBAãšãã£ã¿ãå«ãŸããŠãããããç¹å¥ãªããŒã«ãã€ã³ã¹ããŒã«ããããšãªãéçºãéå§ããããšãã§ããŸãã
ç°å¢ãèšå®ããéã«ã¯ãã»ãã¥ãªãã£èšå®ã確èªãããã¯ããæå¹ã«ããããšãéèŠã§ããMicrosoft Excelã§èšããšããéçºãã¿ãã®ããã¯ãã®ã»ãã¥ãªãã£ãããèšå®ãè¡ãããšãå€ãã§ãããã ããäžçšæã«ã»ãã¥ãªãã£ã¬ãã«ãäžããããšã¯å±éºã䌎ããããä¿¡é Œã§ãããœãŒã¹ããã®ãã¯ãã®ã¿ãå®è¡ããããã«ããŸãããã
ãŸãããããã°ããŒã«ããªããžã§ã¯ããã©ãŠã¶ãªã©ãVBAãšãã£ã¿ã«ã¯éçºããµããŒãããããã®æ©èœãå€æ°çšæãããŠããŸããããããé©åã«æŽ»çšããããšã§ãVBAã®ããã°ã©ãã³ã°ãããã¹ã ãŒãºã«ãªããå¹çã®è¯ãéçºãå¯èœãšãªããŸãã
2. ChatGPTãšVBAã®é£æº
ChatGPTãšVBAã®é£æºã¯ãä»æ¥ã®èªååãå¿ èŠãªãªãã£ã¹äœæ¥ãå€ãããããããŸãããMicrosoft Office補åã«å èµãããããã°ã©ãã³ã°èšèªã§ããVisual Basic for ApplicationsïŒVBAïŒã掻çšããããšã«ãããChatGPTãšé£æºãããããšãã§ããŸãã
ãã®èšäºã§ã¯ãChatGPTãVBAã¹ã¯ãªããã«çµ±åããããšã§ãåçŽãªäœæ¥ããè€éãªããŒã¿åæãŸã§ãå€å²ã«ãããããã»ã¹ãèªååããæ¹æ³ã«ã€ããŠæ¢ç©¶ããŸããVBAã§ã®APIã®äœ¿çšãããšã©ãŒãã³ããªã³ã°ãŸã§ãå¿ èŠãªåºæ¬ãæŒãããŠãããŸãããã
ããã°ã©ãã³ã°çµéšãæµ ãæ¹ã§ãç解ããããããã«ãå®çšçãã€å®è·µçãªææ³ãåãäžããããªãã®ã¯ãŒã¯ãããŒãåäžãããããã®æåŒããšãªãããšãç®æããŸãã
2.1 VBAã䜿ã£ãŠChatGPTã«ã¢ã¯ã»ã¹ããæ¹æ³
ChatGPTãžã®ã¢ã¯ã»ã¹ãå¯èœã«ããããããŸãã¯Microsoft Officeã¢ããªã±ãŒã·ã§ã³äžã§VBAãå©çšããããã®åºç€ãç¯ãããšãå¿ èŠã§ããVBAãšãã£ã¿ãéããé©åãªåç §ã®èšå®ãè¡ãããšããå§ããŸããããã§ã¯ãå€éšã®ãµãŒãã¹ãšéä¿¡ããããã«å¿ èŠãªãªããžã§ã¯ãã©ã€ãã©ãªãèšå®ããæé ã«ã€ããŠçŽ¹ä»ããŸãã
次ã«ãChatGPTã®APIãå©çšããããã®HTTPãªã¯ãšã¹ãã®äœææ¹æ³ãåŠã³ãŸããããã§ã¯ãMicrosoft XMLãHTTP ãªããžã§ã¯ãã䜿ããChatGPTãµãŒããŒãžãªã¯ãšã¹ããéä¿¡ããæ¹æ³ãæ確ã«ããŸãã
æåŸã«ãVBAããChatGPTãžãªã¯ãšã¹ããéããå¿çãåãåãéçšã説æããŸãããã®ã¹ãããã§ã¯ãAPIããã®å¿çãé©åã«ããŒã¹ãããã®ããŒã¿ãExcelã·ãŒããWordææžãªã©ã«çµã¿èŸŒãæ¹æ³ã«è§ŠããŸãã
2.2 ChatGPT APIã®åºæ¬
ChatGPTã®APIãå©çšããããã«ã¯ãåºæ¬çãªAPIã®æŠå¿µãç解ããããšãäžå¯æ¬ ã§ããAPIãšã¯Application Programming Interfaceã®ç¥ã§ãç°ãªããœãããŠã§ã¢éã§ããŒã¿ã®ããåããããããã®èŠçŽã§ããChatGPTã®APIã¯ããã€ã§ãææ°ã®åºææ©èœãžã¢ã¯ã»ã¹ãæäŸãããã®å©çšã«ã¯APIããŒãå¿ èŠã«ãªããŸãã
APIä»æ§ãèªã¿è§£ããã©ã®ãšã³ããã€ã³ããå¿ èŠãªæ å ±ãæäŸããã®ããèå¥ããèœåãæ±ããããŸãããŸãããªã¯ãšã¹ããéä¿¡ããéã«ã¯ãã¯ãšãªãã©ã¡ãŒã¿ãããããŒæ å ±ãé©åã«èšå®ããå¿ èŠããããŸãã
ããã«ãAPIã³ãŒã«ã«ã€ãåãããŠæ±ãããã¬ãŒããªãããããå¿çã®ã¹ããŒã¿ã¹ã³ãŒããªã©ã®è©³çŽ°ãåŠã³ãŸãããããã®æ å ±ãé ã«å ¥ããããšã§ãå®å®ããŠChatGPTã®APIãVBAã¹ã¯ãªãããšé£æºãããåºç€ãç¯ãããšãã§ããŸãã
2.3 APIãšVBAéã®ããŒã¿ããåã
APIãšVBAãåæ»ã«ããŒã¿ãããåãããããã«ã¯ãJSON圢åŒã§ã®ããŒã¿åŠçãå¿ èŠã§ããJSONïŒJavaScript Object NotationïŒã¯ãããŒã¿ã軜éãªåœ¢åŒã§ããåãããããã®æšæºãã©ãŒãããã§ããVBAã«ã¯æšæºã§JSONã解æããæ©èœããªããããå€éšã©ã€ãã©ãªãå°å ¥ããããç¬èªã®ããŒãµãæžãæ¹æ³ããããŸãã
ããã§ã¯ãJSONããŒã¿ã®éãæ¹ãåãåãæ¹ããããŠãã®èªã¿èŸŒã¿æ¹ã«ã€ããŠè§£èª¬ããŸããAPIããåãåã£ãJSONããŒã¿ãExcelã®ã»ã«ãWordã®ããã¹ããšããŠå±éããæ¹æ³ãå«ãŸããŸãã
ãŸããããã©ãŒãã³ã¹ãæé©åããããã«ããããåŠçãéåæåŠçãªã©ã®æŠå¿µã玹ä»ããŸããããããå©çšããããšã§ã倧éã®ããŒã¿ãå¹ççã«åŠçããAPIãšã®éä¿¡ãã¹ã ãŒãºã«è¡ããããã«ãªããŸãã
2.4 ãšã©ãŒãã³ããªã³ã°ãšãããã°
APIãšã®éä¿¡ã§ã¯äºæãã¬ãšã©ãŒãçºçããå ŽåããããŸããVBAã§ã®å ç¢ãªã¢ããªã±ãŒã·ã§ã³ãäœæããããã«ã¯ããšã©ãŒãã³ããªã³ã°ãæ¬ ãããŸãããããã§ã¯ããšã©ãŒãçºçããå Žåã®åŠçæ¹æ³ããåé¡ã蚺æããããã®æé ã«çŠç¹ãåœãŠãŸãã
ãšã©ãŒã³ãŒãããšã©ãŒã¡ãã»ãŒãžãã©ã®ããã«æ±ããVBAå ã§ã©ã®ããã«é©åãªãã³ããªã³ã°ãè¡ãã®ããåŠã³ãŸãããŸãããšã©ãŒãçããéã«ãŠãŒã¶ãŒãžã®éç¥æ¹æ³ã«ã€ããŠã觊ããŸãã
æåŸã«ãVBAã®ãããã°æ©èœãçšããŠãã³ãŒãã®åé¡ç¹ãç¹å®ããä¿®æ£ããæ¹æ³ã«ã€ããŠèª¬æããŸãããã¬ãŒã¯ãã€ã³ãã®èšå®ãã¹ãããå®è¡ãå€æ°ãŠã©ãããªã©ããšã©ãŒãç¹å®ããããããããã®æçšãªãã¯ããã¯ãæãäžããŸãã
3. VBAã«ããChatGPTã®å¿çšäŸ
Visual Basic for ApplicationsïŒVBAïŒã¯ãMicrosoft Office補åã«çµã¿èŸŒãŸããŠããããã°ã©ãã³ã°èšèªã§ããå€ãã®ãªãã£ã¹ã¯ãŒã«ãŒãExcelãAccessãªã©ã®ã¢ããªã±ãŒã·ã§ã³ãå¹çåããããã®ã¹ã¯ãªãããäœæããéã«äœ¿çšããŠããŸããäžæ¹ãChatGPTã¯äŒè©±åAIã«ç¹åããããã°ã©ã ã§ãããŸããŸãªã·ããªãªã§å¿çšãããŠããŸãããã®äºã€ãçµã¿åãããããšã§ãæ¥åã®èªååãããŒã¿åŠçã®ç²ŸåºŠåäžãç®æãããšãã§ããŸãã
ç¹ã«ãVBAã§ã¯GUIïŒã°ã©ãã£ã«ã«ãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹ïŒã®ã«ã¹ã¿ãã€ãºãããŒã¿æäœããããŠå€éšAPIãšã®é£æºãå¯èœã§ããChatGPTãšã®é£æºã¯ãäž»ã«ãã®å€éšAPIãå©çšããããšã§å®çŸãããŸããVBAãéããŠChatGPTã®APIã«ãªã¯ãšã¹ããéãããšã§ã人éã®ãããªèªç¶èšèªã§æžãããããã¹ãããæçãªæ å ±ãæœåºããããšãå¯èœã«ãªããŸãã
ãã®èšäºã§ã¯ãVBAãšChatGPTãçšããããã€ãã®å¿çšäŸã«ã€ããŠè©³ããã玹ä»ããŸããããã§ã¯ãå®éã®å¿çšäºäŸãèŠãŠãããŸãããã
3.1 èªåã¬ããŒãçæ
èªåã¬ããŒãçæã¯ãããžãã¹ã®äžçã§æéã®ç¯çŽãšãšã©ãŒã®äœæžãå®çŸããäžã§éèŠãªåœ¹å²ãæãããŸããVBAã䜿ãã°ã倧éã®ããŒã¿ãåŠçããããããçµ±åããŠã¬ããŒããäœæããããã»ã¹ãèªååããããšãå¯èœã§ããäžæ¹ã§ãChatGPTã¯èªç¶èšèªã§ã®ã¬ããŒãã®èŠçŽããæ瀺ã«åŸã£ãæç« ã®çæãåŸæãšããŠããŸãã
ããšãã°ãExcelå ã®VBAã䜿çšããŠãå®æçãªã»ãŒã«ã¹ã¬ããŒããçæããæ©èœãçµã¿èŸŒãããšãã§ããŸãããã®ããŒã¿ãChatGPTã«éä¿¡ããåãããããã¬ããŒãã®èŠçŽãçæããŠãããããšãäžã€ã®æ¹æ³ã§ããããã«ãããæéããããã«æ å ±ãäŒãããçžæã«å¯ŸããŠãèªã¿ããã圢åŒã§ã¬ããŒããæäŸã§ããŸãã
ããã«ãChatGPTãçæããããã¹ãã¯ãVBAã¹ã¯ãªããã䜿ã£ãŠWordãPowerPointã«èªåçã«è»¢èšãããããšãã§ãããããåçš®ããã¥ã¡ã³ãã®äœæãå€§å¹ ã«å éããããšãã§ããŸãã
3.2 ããŒã¿åæãšå¯èŠå
ããŒã¿ãç解ãããã圢ã«ããããšã¯ãææ決å®ã«ãããŠæ¥µããŠéèŠã§ãããã®ãããããŒã¿åæãšãã®çµæã®å¯èŠåã¯ãå€ãã®ããžãã¹ã§æ±ããããã¹ãã«ãšãªã£ãŠããŸããVBAã¯Excelãªã©ã§ããŒã¿ã®åæãšå¯èŠåãèªååããããã«åºãçšããããããŒã«ã§ãã
å®éã«ãVBAãã¯ããå©çšããŠéèšãèšç®ãè¡ãããã®åŸã®çµæãã°ã©ãããã£ãŒãã«åæ ãããããšã¯äžè¬çãªäœ¿çšäŸã§ããããã«ãChatGPTã掻çšããããšã§ããããã®çµæã«åºã¥ãã解説ãèŠçŽãçæããå ±åæžããã¬ãŒã³ããŒã·ã§ã³ã«ä»å 䟡å€ãäžããããšãã§ããŸãã
ããšãã°ã売äžã®æšç§»ããŒã¿ãå ã«ããŠãç¹å®ã®åŸåãç°åžžå€ãVBAã§èªåæ€åºãããã®åæçµæãChatGPTã«æž¡ãããšã§ããã詳现ã§äººéå³ã®ãã解説ãå ããããšãå¯èœã«ãªããŸãã
3.3 ã¡ãŒã«èªåéä¿¡ã·ã¹ãã
æ¥ã ã®ã³ãã¥ãã±ãŒã·ã§ã³ã«ãããŠãã¡ãŒã«ã¯äŸç¶ãšããŠåºç€çãªããŒã«ã§ãããããã管çããããšã¯æã«æéãããããŸããVBAã䜿çšããŠOutlookå ã§ã¡ãŒã«ã®éä¿¡ãèªååãããã¯ããäœæããããšãã§ããŸãããChatGPTã®å°å ¥ã«ããããã®å 容ããããã«é«åºŠã«ã«ã¹ã¿ãã€ãºããããšãå¯èœã§ãã
äžäŸãšããŠã顧客ããã®æ§ã ãªåãåããã«å¯ŸããŠãChatGPTãèªç¶èšèªã§é©åãªåçãçæããVBAãã¯ãã䜿ã£ãŠãã®å 容ãã¡ãŒã«ã§èªåéä¿¡ãããšããã·ã¹ãã ãèããããŸããããã«ãããæäœæ¥ã«ããåçæéãåæžãã€ã€ã顧客æºè¶³åºŠãé«ããããšãã§ããŸãã
ãŸããå®æçãªãã¥ãŒã¹ã¬ã¿ãŒã倧éã®å®åæã¡ãŒã«ãéãå Žåã«ããChatGPTã®èšèªçæèœåãšVBAã®èªååŠçãæå¹ã«æ©èœããŸããããã«ãããäžè²«æ§ãããã€ã€ãåå¥ã®åä¿¡è ã«åãããã«ã¹ã¿ãã€ãºãå¯èœãªã¡ãŒã«ãäœæã§ããã®ã§ãã
3.4 ãŠãŒã¶ãŒå ¥åã®èªç¶èšèªåŠç
ãŠãŒã¶ãŒããã®ãã£ãŒãããã¯ãèŠä»¶ã®åéã¯ãããžãã¹ã§ã®æåã«äžå¯æ¬ ãªããã»ã¹ã§ããVBAãå©çšããããšã§ããã©ãŒã ããã®ãŠãŒã¶ãŒå ¥åãåéãããããæŽçããèªååããŒã«ãäœããŸããChatGPTã®èªç¶èšèªåŠçèœåãçµã¿åãããã°ãããè€éãªããã¹ãæ å ±ã®åæãå¯èœã«ãªããŸãã
äŸãã°ã顧客ããã®ãã£ãŒãããã¯ãExcelãã©ãŒã ã«å ¥åãããVBAã§ãã®å ¥åããŒã¿ãåŠçããChatGPTãçšããŠææ åæãè¡ããšããã·ã¹ãã ãèããããŸããããã«ããã顧客æºè¶³åºŠã®ã¢ãã¿ãªã³ã°ãæ¹åç¹ã®ææ¡ãå¹ççã«è¡ãããŸãã
VBAãšChatGPTãçµã¿åãããããšã§ãåçŽãªããŒã¿ã®åéã ãã§ãªãããã®æå³ãæèãç解ããããã®åŒ·åãªã¢ãããŒããåãããšãã§ããããã«ãªããŸããããã«ãããäŒæ¥ã¯é¡§å®¢ã®å£°ãçã«ç解ããããã«åºã¥ããè¡åããšãããšãå¯èœã«ãªãã®ã§ãã
4. ChatGPT VBAããã°ã©ãã³ã°ã®äžçŽãã¯ããã¯
4.1 VBAãã¯ãã®æé©å
VBAãã¯ãã®ããã©ãŒãã³ã¹ãåäžãããããã®æé©åã¯ãé«åºŠãªããã°ã©ãã³ã°ã¹ãã«ã®èšŒãã§ããã³ãŒãã®å®è¡é床ãåäžããããããäžèŠãªã«ãŒãã®åé€ãå€æ°ã®å¹ççãªå©çšãéèŠã§ãã
èšç®ãè¡ãéã«ã¯ãWorksheeté¢æ°ãçŽæ¥ã³ãŒã«ããã®ã§ã¯ãªããVBAå éšã§åŠçããããšãæå¹ã§ãããŸããScreenUpdatingãCalculationãé©åã«å¶åŸ¡ããããšã§ãå®è¡æã®å¿çæ§ãé«ããããšãã§ããŸãã
æé©åã«ã¯ã³ãŒãã®ãããã¡ã€ãªã³ã°ãæå¹ã§ãããå®è¡æéãé·ãã³ãŒãã®éšåãç¹å®ããã¢ã«ãŽãªãºã ã®æ¹åãå³ãããšãéèŠã§ãããããã®ææ³ãé©çšããããšã§ãVBAãã¯ãã¯ããã¹ã ãŒãºã«åäœããããã«ãªããŸãã
4.2 è€éãªãããŒã®èªåå
VBAã¯Excelã®ããŒã¿æäœãèªååãã匷åãªããŒã«ã§ãããç¹ã«è€éãªãããŒã®èªååã§ã¯ãã®ããã³ã·ã£ã«ãçºæ®ããŸããæ¡ä»¶åå²ãã«ãŒããªã©ã䜿ã£ãŠããŠãŒã¶ãŒãæäœæ¥ã§è¡ã£ãŠããäœæ¥ãå¹ççã«åŠçããããšãå¯èœã§ãã
ãšã©ãŒåŠçã¯è€éãªãããŒãèªååããéã®éèŠãªãã€ã³ãã§ãããé©åãªãšã©ãŒãã³ããªã³ã°ãçšããããšã§ãããã°ã©ã ã®å®å®æ§ãåäžãããããšãã§ããŸãããŸããã€ãã³ãé§ååã®ããã°ã©ãã³ã°ãçšããŠãŠãŒã¶ãŒã®ã¢ã¯ã·ã§ã³ã«å³åº§ã«åå¿ãããããªãã¯ããäœæã§ããŸãã
å€æ®µéã«ãããããã»ã¹ãèªååããå Žåããµãããã·ãŒãžã£ãé©åã«å©çšããããšã§ãã³ãŒãã®åå©çšæ§ãä¿å®æ§ãåäžããŸããå¹ççãªé¢æ°ã®åå²ãšåŒã³åºãã«ãã£ãŠãè€éãªã¿ã¹ã¯ãèŠéãè¯ãããã°ã©ãã³ã°ã§ããŸãã
4.3 ã»ãã¥ãªãã£ãšãã©ã€ãã·ãŒã®ä¿è·
ããã°ã©ã ã«ãããã»ãã¥ãªãã£ãšãã©ã€ãã·ãŒã®ä¿è·ã¯éåžžã«éèŠã§ããVBAããã°ã©ã ãäœæããéã«ãããŠãŒã¶ãŒã®ããŒã¿ãå®ãããã«é©åãªå¯Ÿçãæœãå¿ èŠããããŸãã
ãã¯ãã®ã»ãã¥ãªãã£èšå®ã¯åºæ¬ã§ãããVBAãããžã§ã¯ãèªäœã®ãã¹ã¯ãŒãä¿è·ãããžã¿ã«çœ²åãè¡ãããšã§ãäžæ£ãªæ¹å€ãé²ãããšãã§ããŸãããŸããæ©å¯ããŒã¿ãæ±ãå Žåã«ã¯ãããŒã¿ã®æå·åãã¢ã¯ã»ã¹ç®¡çã®å®è£ ãæ€èšãã¹ãã§ãã
ãŠãŒã¶ãŒããä¿¡é ŒãåŸãããã«ã¯ãããã°ã©ã ãã©ã®ããã«ããŒã¿ãåãæ±ãããéæã«ããå¿ èŠãªæ å ±ã®ã¿ãåŠçããããã«å¿ãããããšãèèŠã§ããã»ãã¥ãªãã£ãšãã©ã€ãã·ãŒã®ä¿è·ã培åºããããšã¯ãããã°ã©ã ãå©çšããäžã§ã®ä¿¡é Œæ§ãé«ããããã«äžå¯æ¬ ã§ãã
4.4 ãŠãŒã¶ãŒå®çŸ©é¢æ°(UDF)ã®äœæ
Excelã®æšæºæ©èœãè¶ ããã«ã¹ã¿ã æ©èœãæäŸãããéã«ã¯ããŠãŒã¶ãŒå®çŸ©é¢æ°(UDF)ã®äœæã圹ç«ã¡ãŸããããã¯ç¹å®ã®èšç®ãããŒã¿åŠçãå®è£ ããããã«çšããããã»ã«ã«çŽæ¥ãã©ãŒãã¥ã©ãå ¥åããããã«å©çšã§ããŸãã
UDFã¯ãç¹å®ã®æ¥åã«ç¹åããèšç®ã«ãŒã«ãåæ ãããããšãå¯èœã§ãVBAã®æè»æ§ã掻ãããŠå©çšãŠãŒã¶ãŒã«åãããç¬èªã®æ©èœãæäŸã§ããã®ãã¡ãªããã§ããè¯ã䜿ãããè€éãªèšç®ãUDFã«ãŸãšããããšã«ãã£ãŠãäœæ¥ã®å¹çåã«å€§ããè²¢ç®ããŸãã
UDFã®äœæã«ã¯ãé¢æ°ã®åŒæ°ãšæ»ãå€ãé©åã«èšèšããããšãéèŠã§ããé©åã«èšèšãããUDFã¯ãã·ãŒãäžã§ã®äœ¿ãåæãããããšã³ããŠãŒã¶ãŒã«ãšã£ãŠãç解ãããããã®ãšãªããŸããVBAãçšããŠå¹æçãªUDFãéçºããããšã¯ãé«åºŠãªããã°ã©ãã³ã°èœåã®èšŒæãšãªãã§ãããã
5. ChatGPTãšVBAã®åå
è¿å¹Žãããã°ã©ãã³ã°ã®äžçã¯ç®èŠãŸããé©æ°ãéããŠãããç¹ã«èªååã人工ç¥èœã®åéã§ã®é²æ©ã¯ç®ç«ã£ãŠããŸãããã®èšäºã§ã¯ãç¹ã«Microsoft Officeã®èªååã«åœ¹ç«ã€VBAïŒVisual Basic for ApplicationsïŒãšãææ°AIæè¡ã§ããChatGPTã®çµã¿åããã«çŠç¹ãåœãŠãŸãã
VBAã¯ãMicrosoft Office補å矀ãé«åºŠã«ã«ã¹ã¿ãã€ãºããæ©èœãèªååããããšãå¯èœãªããã°ã©ãã³ã°èšèªã§ããäžæ¹ã§ãChatGPTã¯èªç¶èšèªåŠçãçæã«åªããAIã¢ãã«ã§ããããã®äœ¿çšç¯å²ã¯æ¥ã åºãããèŠããŠããŸãã
ãã®äºã€ã®æè¡ãã©ã®ããã«åããŠããã®ãããããŠããããã®ææ°ã®ã¢ããããŒãã«ã¯ã©ã®ãããªãã®ãããã®ãããŸããVBAã¹ãã«ãåžå Žã§ã©ãã»ã©éèŠãªã®ããæ¢ããŸãã
5.1 ææ°ã®VBAã¢ããããŒã
VBAã¯ãé·å¹Žã«ãããOffice補åã®èªååããã³ã«ã¹ã¿ãã€ãºã®äžæ žãæ ã£ãŠããŸãããæè¿ã§ã¯ã»ãã¥ãªãã£ã®åŒ·åãäºææ§ã®åäžãªã©ãç®çãšããã¢ããããŒããè¡ããç¶ããŠããŸãã
ãããã®ã¢ããããŒãã¯ãéçºè ãããå®å šã«å¹ççãªãã¯ããã¢ããªã±ãŒã·ã§ã³ãäœæã§ããããã«ããããšãç®æããŠããŸããèŠæš¡ã®å€§å°ã«é¢ãããããŠãŒã¶ãŒãçŽé¢ããæ§ã ãªèª²é¡ã«å¯ŸåŠããäžã§ãVBAã®åœ¹å²ã¯éåžžã«éèŠã§ãã
VBAã®äœ¿ãããããã¢ã¯ã»ã¹ã®ããããã¯ä»ã§ãå€ãã®ããžãã¹ãŠãŒã¶ãŒããé«ãè©äŸ¡ãããŠãããææ°ã¢ããããŒãã¯ãã®èšèªãä»åŸãé·ãå©çšããç¶ããããšãä¿èšŒãããã®ãšãããã§ãããã
5.2 ChatGPTã®é²åãšä»åŸã®å±æ
ChatGPTã¯ããªã¢ã«ã¿ã€ã ã§ã®äŒè©±åã€ã³ã¿ãŒãã§ã€ã¹ãæäŸããAIæè¡ã§ãããŠãŒã¶ãŒãšã®å¯Ÿè©±ãéããŠè³ªåã«çããããããã¹ããçæãããããèœåã¯ãå€ãã®ã·ããªãªã§å¿çšãå¯èœã§ãã
è¿å¹Žã®é²åã§ã¯ãããè€éãªå¯Ÿè©±ã粟巧ãªæã®çæãå¯èœãšãªã£ãŠããŠããããœãããŠã§ã¢éçºè ãã³ã³ãã³ãã¯ãªãšãŒã¿ãŒã«æ°ããå¯èœæ§ãæäŸããŠããŸãããŸããChatGPTã¯æ°ããªããã°ã©ãã³ã°ã®æè²ããŒã«ãšããŠã泚ç®ãéããŠãããããå¹æçãªåŠç¿äœéšãæäŸããããšãæåŸ ãããŠããŸãã
å°æ¥ã®å±æãšããŠã¯ãChatGPTã®èšèªã¢ãã«ãããã«æŽç·Žãããç¹å®åéã§å°éçãªç¥èããã£ãAIã¢ã·ã¹ã¿ã³ããšããŠã®æ©èœã匷åãããããšãèããããŸããããã¯ãããžãã¹ã«ãããææ決å®ã®å©ããšãªãã ãã§ãªããæè²ãç 究ã®åéã§ã倧ãã«åœ¹ç«ã€ã§ãããã
5.3 VBAãšä»ã®ããã°ã©ãã³ã°èšèªã®é£æº
VBAãç¹å®ã®ããŒãºã«å¿ããããŒã«ã§ããããšã¯ç¢ºãã§ãããçŸä»£ã®å€æ§ãªããžãã¹èŠæ±ã«å¿ããŠãVBAã¯ä»ã®ããã°ã©ãã³ã°èšèªããã¯ãããžãšã®é£æºãæ±ããããããšãå¢ããŠããŸããPythonãJavaScriptãšã®çµã¿åããã¯ãããŒã¿åæãWebããŒã¹ã®ã¢ããªã±ãŒã·ã§ã³éçºã«ãããŠåŒ·åãªã·ããžãŒãçºæ®ããŸãã
ãã®ãããªé£æºã¯ããŠãŒã¶ãŒã«å¯ŸããŠããã€ã³ã¿ã©ã¯ãã£ãã§ãã¯ãã«ãªãœãªã¥ãŒã·ã§ã³ãæäŸããããšãå¯èœã«ããVBAã®æ©èœãæ¡åŒµããéèŠãªæ段ã§ãããŸããæ¢åã®ã·ã¹ãã ãææ°ã®ãã¯ãããžãšçµ±åããããšã§ãã·ã¹ãã å šäœã®å¹çãåäžããŸãã
ããŒã ãç°ãªãã¹ãã«ã»ãããçµã¿åãããããšã§ãVBAã®éçãè¶ ããé©æ°çãªãœãªã¥ãŒã·ã§ã³ãçã¿åºãããšãã§ããåžå Žã§ã®ç«¶äºåãåµåºããåååãšãªãåŸãŸãã
5.4 åžå Žã§ã®éèŠãšVBAã¹ãã«ã®éèŠæ§
ããžãã¹ã«ãããŠèªååã¯ãå¹çæ§ãé«ããéçšã³ã¹ããåæžãã決å®çãªèŠçŽ ã§ããVBAã¯ããªãã£ã¹ã®äœæ¥ãèªååãã匷åãªããŒã«ãšããŠããã®éèŠã¯äŸç¶ãšããŠç¶ç¶ããŠããŸãã
ãšã³ããŠãŒã¶ãŒãçŽé¢ããŠããåé¡ãè¿ éã«è§£æ±ºããããã«ã¯ãVBAã¹ãã«ãæã£ãå°é家ã®ååšãäžå¯æ¬ ã§ãã圌ãã¯ããžãã¹ããã»ã¹ã®å¹çåãã«ã¹ã¿ãã€ãºãè¡ããäŒæ¥ã®æé·ãæ¯æŽããŸãã
ãŸããVBAã¹ãã«ã¯ããã£ãªã¢ãç©ãããã§å¹ åºãåéã§ã®å°±è·ãæé²ã«ãããŠéèŠãªè³æ ŒãšãªãåŸãŸããæ å ±æè¡ã®å°é家ã ãã§ãªããäŒèšå£«ãã¢ããªã¹ããªã©ãå€ãã®ããžãã¹ãããã§ãã·ã§ãã«ã«ãšã£ãŠããVBAã®ç¥èã¯é«ãè©äŸ¡ãããã¹ãã«ã§ãã
6. ChatGPT VBAããã°ã©ãã³ã°ãã¥ãŒããªã¢ã«
Microsoft Officeã®èªååãã«ã¹ã¿ãã€ãºãè¡ããVisual Basic for ApplicationsïŒVBAïŒã¯ãããã°ã©ãã³ã°ã®å¯èœæ§ãåºããããã®åŒ·åãªããŒã«ã§ããç¹ã«Excelãæ±ãéã«ãã®ç䟡ãçºæ®ããŸãããã®èšäºã§ã¯ãChatGPTãšçµã¿åãããVBAããã°ã©ãã³ã°ã身ã«ä»ããããã®æ å ±ãæäŸããŸãã
ChatGPTã¯ãèªç¶èšèªåŠçã«åªãããªãŒãã³AIã®GPTïŒGenerative Pretrained TransformerïŒã¢ãã«ã®äžçš®ã§ãäŒè©±åœ¢åŒã®ããã¹ãçæãå¯èœã§ããVBAã§ChatGPTãæäœããããšã§ããšã¯ã»ã«ããŒã¿ã®èªååã ãã§ãªãããã®è§£æãã¬ããŒãçæãå¹ççã«è¡ããããã«ãªããŸãã
ãã®ãã¥ãŒããªã¢ã«ãéããŠãVBAã§ã®ããã°ã©ãã³ã°ã¹ãã«ãåå¿è ãããšãã¹ããŒãã¬ãã«ãŸã§æ®µéçã«é«ããŠãããŸããããèªååäœæ¥ãåŠã¶ããšã¯ãæ¥åã®å¹çåãæéã®ç¯çŽã«çŽçµããŸãã
6.1 åå¿è åãã¹ããããã€ã¹ãããã¬ã€ã
åå¿è ã«ãšã£ãŠVBAã¯æåã¯é£è§£ã«æãããããããŸããããåºç€ããäžå¯§ã«åŠã¹ã°å€§ããªå£ã§ã¯ãããŸããããŸãã¯Editorã®éãæ¹ããã¯ãã®èšé²ã»å®è¡ããã¹ã¿ãŒããããã®åŸåºæ¬çãªã³ãŒãã£ã³ã°ã®ååãç解ããŸãããã
ãã¯ãã®èšé²æ©èœã䜿çšãããšãè¡ã£ãæäœãVBAã³ãŒããšããŠèªåçæã§ããŸããããã解æããããšã§ãVBAã®åºç€æ§æãèªç¶ãšèº«ã«ä»ããŸãããã®åŸã¯ãå€æ°å®£èšãã«ãŒãåŠçãæ¡ä»¶åå²ãªã©ã®åºæ¬çãªããã°ã©ãã³ã°ã®æŠå¿µãåŠã³ãŸãã
æåŸã«ãç°¡åãªãŠãŒã¶ãŒå®çŸ©é¢æ°ããã¯ããèªãæžããŠãå®éã®ãããžã§ã¯ãã«å¿çšããŠã¿ãŸãããããšã¯ã»ã«ãã¡ã€ã«ã®ããŒã¿æäœããã©ãŒãããã®å€æŽãªã©ãå®çšçãªã¹ã¯ãªããã®äœæãéããŠãåŠãã ç¥èã確å®ã«äœåŸããŸãã
6.2 äžçŽè åãã®ãã£ã¬ã³ãžèª²é¡
äžçŽè ã®ã¹ããŒãžã§ã¯ãVBAã®ç解ãããã«æ·±ããã¹ããããè€éãªããŒã¿æ§é ã®åŠçããšã©ãŒãã³ããªã³ã°ã«ææŠããŸãããªããžã§ã¯ãæåã®æŠå¿µããã®æ®µéã§åŠã¶ããšãéèŠã§ãã
äžçŽè ã®èª²é¡ãšããŠã¯ãå€éšããŒã¿ããŒã¹ãžã®æ¥ç¶ãä»ã®ã¢ããªã±ãŒã·ã§ã³ãšã®é£æºãå³ãAPIã®å©çšãæããããŸããChatGPTãå©çšããããã¹ãçæã«ãããŠããVBAã§ã®HTTPãªã¯ãšã¹ãã®éä¿¡æ¹æ³ãç解ããå¿çãé©åã«åŠçããèœåãæ±ããããŸãã
å ·äœçãªãã£ã¬ã³ãžãšããŠãèªåã¬ããŒãçæã·ã¹ãã ã®éçºããããã€ã³ã¿ã©ã¯ãã£ããªUIãæã€VBAã¢ããªã±ãŒã·ã§ã³ã®æ§ç¯ã«åãçµã¿ãŸããè€éãªåé¡ã解決ããããšã§ãVBAã¹ãã«ã次ã®ã¬ãã«ã«åŒãäžããŸãããã
6.3 ãšãã¹ããŒãã®ã¢ããã€ã¹ãšãã¯ããã¯
ãšãã¹ããŒããšããŠã®ã¢ããã€ã¹ã¯ãVBAã§ã¯ãªãããŒã å šäœã®å¹çãèæ ®ããã¹ã¯ãªããäœæã«ã·ããããããšã§ããåå©çšå¯èœãªã³ãŒãã®ã©ã€ãã©ãªãŒãæ§ç¯ããä¿å®æ§ãšå¯èªæ§ã®é«ãã³ãŒããå¿ãããŸãããã
ããã©ãŒãã³ã¹æé©åãéèŠãªãã€ã³ãã§ããäžèŠãªã¹ã¯ãªãŒã³æŽæ°ã®æå¶ããå¹ççãªã«ãŒãåŠçã®èšèšãªã©ãå®è¡é床ãæ¹åãããã¯ããã¯ãåŠãã§ãã ããããŸããã»ãã¥ãªãã£ãŒé¢ã§ã¯ãã³ãŒãå ã§ã®ã»ã³ã·ãã£ãããŒã¿ã®åãæ±ãã«æ³šæãããã¯ãã®å®å šæ§ã確ä¿ããããšãäžå¯æ¬ ã§ãã
é«åºŠãªãã¯ããã¯ãšããŠã¯ãCOMïŒComponent Object ModelïŒã¢ãã€ã³ã®äœæãããªãã¬ã¯ã·ã§ã³ã䜿çšããåçãªããã°ã©ãã³ã°çãææŠã®äŸ¡å€ãããããŒãã§ãããããã®ã¹ãã«ã身ã«ä»ããã°ãVBAã®æ ãè¶ ããåºç¯ã§æè»ãªèªååãœãªã¥ãŒã·ã§ã³ã®éçºãå¯èœã«ãªããŸãã
6.4 æçšãªãªãœãŒã¹ãšã³ãã¥ããã£
ç¬åŠã¯æã«å€ç¬ã§ãããå€ãã®ãªã³ã©ã€ã³ãªãœãŒã¹ãã³ãã¥ããã£ãå©çšå¯èœã§ããå ¬åŒããã¥ã¡ã³ãããã©ãŒã©ã ãQ&Aãµã€ãããªã³ã©ã€ã³ã³ãŒã¹ãªã©ããåŠç¿ããµããŒãããŸãã
ãŸããGitHubã®ãããªã³ãŒãå ±æãµã€ãã掻çšããããšã§ãä»ã®éçºè ãäœæããVBAã¹ã¯ãªãããèŠãããšãã§ããæ°ããªã¢ã€ãã£ã¢ãåŸãããèªèº«ã®ã³ãŒããæ¹åãããã£ããã«ãªããŸãããªãŒãã³ãœãŒã¹ãããžã§ã¯ããžã®è²¢ç®ãç¥èã®å®çã«åœ¹ç«ã¡ãŸãã
æåŸã«ãå°åã®ãŠãŒã¶ãŒã°ã«ãŒãããªã³ã©ã€ã³ã³ãã¥ããã£ã«åå ããããšã§ãåãèå³ãæã€äººã ãšåºäŒããçµéšãå ±æããããšãã§ããŸããã€ãã³ããããŒãã¢ããã¯ãæ°ããçºèŠãæ欲çãªåŠç¿ãä¿ããŠãããã¯ãã§ãã
7. ãŸãšã
ChatGPTãšVBAããã°ã©ãã³ã°ã®å¹æçãªçµã¿åããã«ãã£ãŠãããžãã¹ããŒãœã³ã¯ä»äºã®å¹çãé£èºçã«åäžãããããšãã§ããŸããChatGPTã®AIèœåãšVBAã®èªååæ©èœã䜿ããããŒã¿è§£æãã¬ããŒãäœæãã¡ãŒã«éä¿¡ãªã©ã®æ¥ã ã®ã¿ã¹ã¯ãç°¡åã«åŠçãå®å®ããéçºç°å¢ãæŽããAPIçµç±ã§ChatGPTã«ã¢ã¯ã»ã¹ããç¬èªã®ã·ã¹ãã ãããŒã«ãéçºããããšãå¯èœã§ããäžçŽãã¯ããã¯ãé§äœ¿ããã°ããã©ã€ãã·ãŒä¿è·ããŠãŒã¶ãŒå®çŸ©é¢æ°ãã«ã¹ã¿ãã€ãºã§ããŸãããã®é åã¯åžžã«æŽæ°ãããŠãããããææ°ã®ååãæŒãããããšãéèŠã§ããåå¿è ããäžçŽè ãŸã§ãé©ãããã¥ãŒããªã¢ã«ãè³æºãè±å¯ã«ãããåŠç¿ãšå¿çšã容æã«ãªã£ãŠããŸãã