
VBAã»GASã»Pythonã§æ¥åãèªååããŸãïœãä»äºåéã®ãç¥ãã
ã¯ããã«
ããã«ã¡ã¯ããããã§ãã
ãããªãã§ããããã®åºŠãæ¥åèªååã®ãä»äºãåéããŸãã
ãããnoteã§ãä»äºåéïŒããšæã£ãæ¹ããããããããŸããã
ã§ããèããŠã¿ããšãnoteã§æ¥ã
çºä¿¡ããŠããå
容ãšãåãä»äºã§ãã£ãŠããããšã¯åããªãã§ãã
Exceläœæ¥ã®èªååãGoogleã¹ãã¬ããã·ãŒããšã®é£æºãæ¥ã
ã®æ¥åãå°ãã§ã楜ã«ããããŒã«äœãã
ãããŸã§noteã§ã¯ãèªåã®ãã£ãªã¢ãAI掻çšã«ã€ããŠæžããŠããŸããã
仿¥ã¯ããããäžæ©é²ãã§ããåã«äœãã§ããã®ãããå
·äœçã«ãäŒãããèšäºã§ãã
åã¯äœè ã
æåã«èªå·±ç޹ä»ããããŠãã ããã
åã®ãã£ãªã¢ã¯ãããŒã¿å ¥åããå§ãŸããŸããã
2015幎ãç¹ã«ã¹ãã«ããªããããœã³ã³ãå°ãã ã䜿ãããããã®ç¶æ
ã§ãããŒã¿å
¥åã®ä»äºã«å°±ããŸããã
æ¯æ¥ãçŽã®æžé¡ãèŠãªããExcelã«ã²ãããæã¡èŸŒãäœæ¥ã
æ£çŽãæåã¯ãèªåã«ã¯ãããããããã§ããªãããšæã£ãŠããŸããã
ã§ããããæ¥æ°ã¥ãããã§ãã
ããã®äœæ¥ãæ¯ååãããšãã£ãŠããªãã£ãŠã
åããã©ãŒãããã®æžé¡ããåãExcelã·ãŒãã«ãåãæé ã§å
¥åããã
ãããèªååã§ããããããªããã
ããããVBAãç¬åŠã§èŠããŸããã
VBAãšã®åºäŒãã人çãå€ãã
VBAãèŠããŠãããäžçãå€ãããŸããã
ãããŸã§1æéããã£ãŠããäœæ¥ãããã¿ã³1ã€ã§5åã§çµããã
ååãæäœæ¥ã§èŠããã§ããäœæ¥ãããã¯ãã§äžç¬ã§çã¥ããã
ãããããããããã©ããã£ãŠãã®ïŒããšèãããã®ãå¬ããã£ãã
人ã®åœ¹ã«ç«ãŠãŠãã宿ããã¯ãããŠãã£ãã
ãããããVBAã ããããªããGoogle Apps ScriptïŒGASïŒãèŠããŸããã
Excelã®äžçããGoogleã¹ãã¬ããã·ãŒãã®äžçã«åºãã£ãã
ããã«Pythonãç¬åŠã§ç¿åŸã
æ¥åèªååã®å¹
ãäžæ°ã«åºãããŸããã
åŠçæä»£ãããããã€çç¶ãšãéããªãããä»ã¯ãã«ã¿ã€ã ã®ãšã³ãžãã¢ãšããŠåãããšã«ãªããŸããã
ããŒã¿å
¥åããã¹ã¿ãŒãããŠãçŽ10幎ã
é åãã ã£ããããããªããã©ãæ¯ãè¿ã£ãŠã¿ããšãã¹ãŠãã€ãªãã£ãŠããã
ãªããä»äºãåéããã®ã
çç±ã¯ã·ã³ãã«ã§ãã
ãèªåã®ã¹ãã«ã§ããã£ãšå€ãã®äººã®åœ¹ã«ç«ã¡ããããšæã£ãããã
å®ã¯å æ¥ãAIãšäººççžè«ãããŠããæã«ããããªããšãèšãããŸããã
ãããããã«ã¯ä»ã®åºåè ã«ãªãæŠåšãããã
ããã¯ãéãšã³ãžãã¢ã®çŸå Žã§åããŠãå®åçµéšãã
åã¯ãã£ãšããšã³ãžãã¢ãããªã人ãã¡ãšäžç·ã«åããŠããã
ããŒã¿å
¥åã®ããŒã ãããã¯ãªãã£ã¹ã®äºåäœæ¥ãExcelããŒã¹ã®æ¥å管çã
ã ãããããšã³ãžãã¢ãããªã人ããäœã«å°ã£ãŠãããããæèŠã§ããããã§ãã
æè¡ã ãã匷ããšã³ãžãã¢ã¯ãããããããŸãã
ã§ããéãšã³ãžãã¢ã®çŸå Žãç¥ã£ãŠãã人ã¯ãæå€ãšå°ãªãã
ãèªååããããã©ãäœãã©ãããã°ãããããããªãã
ããšã³ãžãã¢ã«çžè«ããããã©ãäœãäŒããã°ãããããããªãã
ããããæ¹ã®åã«ãªãããšæã£ãŠããŸãã
ã§ããããš
åãæäŸã§ãããµãŒãã¹ãããªãã¹ãå°éçšèªã䜿ããã«ãäŒãããŸãã
1. Excel / VBA ã®èªåå
ãExcelã®æäœæ¥ãããéçâŠããšããæ¹ãžã
æ¯æãã£ãŠããéèšäœæ¥ãããã¿ã³1ã€ã§å®äºãããã¯ãã®äœæ
è€æ°ã®Excelãã¡ã€ã«ããããŒã¿ãèªåã§åã蟌ãä»çµã¿
å ¥åãã©ãŒã ã®äœæïŒæå ¥åã®ãã¹ãæžããããæ¹ã«ïŒ
å ±åæžãã¬ããŒãã®èªåçæ
AccessïŒããŒã¿ããŒã¹ïŒãšã®é£æº
ããã¯åãäžçªé·ããã£ãŠããåéã§ãã
ä»ã®ä»äºã§ãæ¯æ¥VBAãæžããŠããŸãã
å®çžŸäŸ:
åšåº«ç®¡çããŒã«ïŒExcelããŒã¹ããã¿ã³1ã€ã§éèšïŒã¬ããŒãåºåïŒ
å·¥æ°ç®¡çããŒã«ïŒããŒã å šå¡ã®äœæ¥æéãèªåéèšïŒ
ã·ãã衚èªåäœæããŒã«
2. Google Apps ScriptïŒGASïŒÃ Google Workspace 飿º
ãGoogleã¹ãã¬ããã·ãŒãããã£ãšäŸ¿å©ã«ãããããšããæ¹ãžã
ã¹ãã¬ããã·ãŒãã®èªåéèšã»èªåæŽåœ¢
Googleãã©ãŒã ã®åçãèªåã§ã¹ãã¬ããã·ãŒãã«éçŽïŒéç¥
GmailãGoogleã«ã¬ã³ããŒãGoogleãã©ã€ããšã®èªå飿º
æ¯æ¥ã»æ¯é±ã®å®æåŠçïŒèªåã¬ããŒãéä¿¡ãªã©ïŒ
Slackããã£ããããŒã«ãžã®èªåéç¥
GASã¯ãGoogleã®ãµãŒãã¹ããã€ãªãããã®ãåŸæãªããŒã«ã§ãã
ãæ¯åæåã§ãã£ãŠããGoogleã¹ãã¬ããã·ãŒãã®äœæ¥ããããã°ãã»ãŒèªååã§ããŸãã
å®çžŸäŸ:
Slackãžã®èªåéç¥ã·ã¹ãã ïŒæ å ±ã宿ã§èªåé ä¿¡ïŒ
RSSãã£ãŒãã®èªååéïŒSlackãžã®é ä¿¡
ãã«ã¹ã±ã¢ããŒã¿ã®èªåèšé²ã·ã¹ãã
3. Python ã§ã®æ¥åå¹çå
ãExcel ã Google ã ãã§ã¯éçãæããŠããããšããæ¹ãžã
ããŒã¿ã®åéã»å å·¥ã»åæã®èªåå
Webãµã€ãããã®æ å ±åéïŒã¹ã¯ã¬ã€ãã³ã°ïŒ
è€éãªããŒã¿åŠçã»å€æ
宿çãªã¬ããŒãèªåçæ
ãã¡ã€ã«ã®äžæ¬åŠçïŒãªããŒã ãå€æãæŽçãªã©ïŒ
Pythonã¯ãVBAãGASã§ã¯é£ãããã¡ãã£ãšè€éãªããšããã§ããããŒã«ã§ãã
ãã ããããªãPythonãå§ããããšã¯ããŸããã
VBAãGASã§ååãªãããã¡ãã§å¯Ÿå¿ããŸãã
䜿ãåŽã«ãšã£ãŠäžçªã·ã³ãã«ãªæ¹æ³ãææ¡ããŸãã
4. AI掻çšã®çžè«ã»ææ¡
ãAIãæ¥åã«åãå ¥ããããã©ãäœããå§ããã°ãããããããªãããšããæ¹ãžã
ChatGPTãClaudeãæ¥åã«æŽ»çšããæ¹æ³ã®ææ¡
AIãçµã¿èŸŒãã èªååããŒã«ã®æ§ç¯
ãAIã«äœãã§ããŠãäœã¯ã§ããªãããã®æŽç
åèªèº«ãæ¯æ¥AIã䜿ã£ãŠä»äºãããŠããŸãã
AIã®å¯èœæ§ãšéçã宿ããŠãããããããçŸå®çãªææ¡ãã§ãããšæããŸãã
ãããªæ©ã¿ã¯ãããŸãããïŒ
ããã²ãšã€ã§ãåœãŠã¯ãŸã£ãããåããæäŒãã§ãããããããŸããã
â¡ æ¯æã®éèšäœæ¥ã«äœæéããããŠãã
â ãã¿ã³1ã€ã§çµããä»çµã¿ãäœããŸãã
⡠瀟å
ã«ãšã³ãžãã¢ãããªããŠãçžè«ã§ãã人ãããªã
â åãçžè«çžæã«ãªããŸããå°ããªããšããã§OKã§ãã
â¡ èªååããããã©ãäœããæãã€ããŠãããããããªã
â ãŸãã¯ä»ãã£ãŠããäœæ¥ãèãããŠãã ãããäžç·ã«æŽçããŸãããã
⡠以åãã¯ããäœã£ãŠããã£ããã©ãã¡ã³ããã³ã¹ã§ãã人ãããªã
â æ¢åã®ãã¯ãã®ä¿®æ£ã»æ¹è¯ããåãããŸãã
â¡ ã¯ã©ãŠããœãŒã·ã³ã°ã«æ¡ä»¶ãåºãããã©ã誰ã«é Œãã°ãããããããªã
â ããããããšãèšèªåãããšãããããäžç·ã«ãããŸãããã
â¡ ããããªç°¡åãªããšã§äŸé ŒããŠããã®ããªããšæã£ãŠãã
â 倧äžå€«ã§ããå°ããªäœæ¥ãããèªååã®å¹æã倧ããã§ãã
ãªãåã«é Œã䟡å€ãããã®ã
æ¥åèªååãã§ãããšã³ãžãã¢ã¯ãããããããŸãã
æè¡åã ãã§èšãã°ãåããåªãã人ãããããããã§ãããã
ã§ããåã«ã¯åã«ãããªã匷ã¿ããããšæã£ãŠããŸãã
1. éãšã³ãžãã¢ã ã£ãéå»ããã
åã¯ããšããšãšã³ãžãã¢ãããããŸããã
ããŒã¿å
¥åããã¹ã¿ãŒãããŠãç¬åŠã§å°ããã€ã¹ãã«ã身ã«ã€ããŠããã
ãªããªããä»ã§ããšã³ãžãã¢ãšæã£ãŠããŸããã
ã ããããããã°ã©ãã³ã°ã®ç¥èããªã人ãã©ãã§ã€ãŸããããããããã
ãAPIã£ãŠäœïŒããç°å¢æ§ç¯ã£ãŠäœïŒãããªãããšã©ãŒã£ãŠåºãŠããã ãã©âŠã
ããããçåã«ãå°éçšèªã䜿ããã«çããããŸãã
2. ãäœãããããèšèªåã§ããªããããäžç·ã«æŽçãã
ãããçµæ§å€ããã§ãã
ããªããå¹çåããããã ãã©ãå ·äœçã«ã©ãããããããŸã説æã§ããªãã
倧äžå€«ã§ãã
åãæåã¯ããã§ããã
ãäœãèªååããããããããªããŠããä»ã©ããªäœæ¥ãããŠããããæããŠããããã°ååã§ãã
ä»ãã£ãŠããäœæ¥ã®æµããèããŠãããããèªååã§ããŸããããšææ¡ããã®ãåã®åœ¹ç®ã§ãã
3. ããã¹ãäžå¿ã®ãããšãã§å®çµã§ãã
å®ã¯åãåé³ïŒãã€ããïŒããããŸãã
é»è©±ã察é¢ã ãšãèšèãããŸãåºãªãããšãããã
ã ãããããããã¹ãã§ã®ã³ãã¥ãã±ãŒã·ã§ã³ã倧åã«ããŠããŸãã
ãã£ãããã¡ãŒã«ãDMã
ããã¹ãã®ãããšãã®æ¹ããèœã¡çããŠæ£ç¢ºã«äŒããããã
ãé»è©±ãããªããŠãã£ããã§ãããšããããããšããæ¹ã倧æè¿ã§ãã
ãããåããã®ã»ããå©ãããŸãã
4. å€§äŒæ¥åããããªããå人ã»å°èŠæš¡ããŒã åã
åãåŸæãªã®ã¯ãæ°äººãæ°åäººèŠæš¡ã®ããŒã ãæ±ãããã¡ãã£ãšããå°ãããšãã§ãã
å€§äŒæ¥ã®ã·ã¹ãã éçºã§ã¯ãªãã
ããã¡ã®ã¹ãã¬ããã·ãŒããããã¡ãã£ãšãªããšããªããªãïŒã
ããã®æ¯æã®äœæ¥ãèªåã§ã§ããªãïŒã
ãããããã¡ãã£ãšãããããã©ãããããè§£æ¶ããã®ããåã®ä»äºã§ãã
æéã®ç®å®
æ¥åèªååã®çžè«ïŒ30åïŒïŒ 3,000åã
ããŒã«éçºïŒGAS/VBA/PythonïŒïŒ 15,000åã
AI掻çšã³ã³ãµã«ïŒ 5,000åã
â»å 容ã»èŠæš¡ã«ãã£ãŠå€åããŸãããŸãã¯ãæ°è»œã«ãçžè«ãã ããã
â æ³šæäºé
éé¡ã¯ãããŸã§ç®å®ã§ããå®éã®æéã¯ããã¢ãªã³ã°åŸã«ãèŠç©ããããŸã
ãäºç®ãéãããŠãããå Žåããã§ããç¯å²ã§å¯Ÿå¿ããŸãããŸãã¯ãçžè«ãã ãã
ãçžè«ã»ãèŠç©ãããŸã§ã¯ç¡æã§ã
競銬ã®äºæ³AIãªã©ã®ã£ã³ãã«ã«ãŸã€ãããã®ãè»¢å£²ã«æŽ»çšããããŒã«ãªã©ã¯äœæããããŸããã®ã§äºããäºæ¿ãã ããã
ãä»äºã®é²ãæ¹
ãäŸé Œããããã©ãããæµãã§é²ãã®ïŒããšããæ¹ã«åããŠã
Step 1: ãçžè«ïŒç¡æïŒ
ãŸãã¯æ°è»œã«ãé£çµ¡ãã ããã
ããããªããšã§å°ã£ãŠããã ãã©âŠããããã®çžè«ã§å€§äžå€«ã§ãã
ãã®æ®µéã§ã¯ããéã¯ããããŸããã
Step 2: ãã¢ãªã³ã°
ä»ãã£ãŠããäœæ¥ãå°ã£ãŠããããšãçæ³ã®ç¶æ
ããèãããŸãã
ããã¹ãïŒãã£ãã or ã¡ãŒã«ïŒã§é²ããŸãã
ãäœãèªååããããããããªããå Žåããäžç·ã«æŽçããã®ã§å¿é ãããŸããã
Step 3: ãææ¡ã»ãèŠç©ãã
ãã¢ãªã³ã°ã®å 容ãããšã«ã
äœãäœãã
ã©ããããã®æéããããã
æéã¯ãããã
ãããããããããäŒãããŸãã
ãã®æ®µéã§ããã£ã±ããããŠããããã§ãå šç¶OKã§ãã
Step 4: éçº
OKãããã ããããéçºã«å
¥ããŸãã
éäžçµéãå
±æããªããé²ããã®ã§ããæã£ãŠãã®ãšéãããé²ããŸãã
Step 5: çŽåã»ãµããŒã
宿ããããŒã«ãçŽåããŸãã
äœ¿ãæ¹ã®èª¬æãã»ããã§ãã
ãçŽåããŠçµãããã§ã¯ãªãã䜿ã£ãŠã¿ãŠããããªãããšãããã°ãã©ããŒããŸãã
çŽååŸ1ã¶æéã¯ãç°¡åãªä¿®æ£ã質åã«ç¡æã§å¯Ÿå¿ããŸãã
ãããã質å
Q. ããã°ã©ãã³ã°ã®ç¥èããªããŠãäŸé Œã§ããŸããïŒ
A. ãã¡ããã§ããããããç¥èããªãæ¹ã«ããé Œã£ãŠã»ãããšæã£ãŠããŸãã
å°éçšèªã¯äœ¿ããã«ãããšãããŸãã
Q. ãªã¢ãŒãã ãã§å®çµããŸããïŒ
A. ã¯ããããã¹ãïŒãã£ããã»ã¡ãŒã«ïŒäžå¿ã§é²ããŸãã
察é¢ããããªé話ããªããŠãåé¡ãããŸããã
Q. åäººäºæ¥äž»ã§ãäŸé Œã§ããŸããïŒ
A. 倧æè¿ã§ããåäººã®æ¹ãããªãŒã©ã³ã¹ã®æ¹ãå°ããªäŒç€Ÿã®æ¹ã
èŠæš¡ã«é¢ããã察å¿ããŸãã
Q. çŽååŸã®ã¡ã³ããã³ã¹ã¯ããŠããããŸããïŒ
A. çŽååŸ1ã¶æéã¯ç¡æã§ãµããŒãããŸãã
ãã以éã¯ãå
容ã«å¿ããŠå¥éãçžè«ãã ããã
Q. éäžã§ãã£ã³ã»ã«ã§ããŸããïŒ
A. éçºã«çæããåã§ããã°ããã£ã³ã»ã«å¯èœã§ãã
çæåŸã®ãã£ã³ã»ã«ã«ã€ããŠã¯ã鲿ã«å¿ããŠãçžè«ãããŠãã ããã
æåŸã«
ãããŸã§èªãã§ãããŠãããããšãããããŸãã
åã¯ããããã·ã¹ãã ãäœããã¹ãŒããŒãšã³ãžãã¢ã§ã¯ãããŸããã
ã§ãããéãšã³ãžãã¢ã®äººãæ±ããŠããå°ããªå°ãããšãããæè¡ã§è§£æ±ºããããšã¯ã§ããŸãã
ããŒã¿å
¥åããå§ãŸã£ãåã®ãã£ãªã¢ã¯ããã£ãšãããã©ãããããªãããããã®é£ç¶ã§ããã
èªåã®ãããã©ããããããªããããšããå§ããŠãååã®ãããã©ããããããªãããŠãä»åºŠã¯ãã£ãšå€ãã®äººã®ãããã©ããããããªããããã
ããããªå°ããªããšã§é Œãã§ããã®ããªã
ããæã£ãŠããæ¹ã倧äžå€«ã§ãã
å°ããããšã»ã©ãèªååã®å¹æã¯å€§ããã£ããããŸãã
ãŸãã¯æ°è»œã«ããããªããšã§å°ã£ãŠãŸãããšæããŠãã ããã
äžç·ã«ãããªãã®ãããã©ããããããªãããŸãããã
ãé£çµ¡æ¹æ³
ãä»äºã®ãäŸé Œã»ãçžè«ã¯ã以äžã®ãããããããæ°è»œã«ã©ããã
XïŒæ§TwitterïŒDMïŒ @yuyaainocode
noteã®DM
ã³ã³ãã©ïŒ
ãã¡ãã£ãšè©±ãèããŠã¿ããããããã§ã倧äžå€«ã§ãã
ãæ°è»œã«ãé£çµ¡ãã ããã
ãã®èšäºããä»äºã®ãäŸé Œãæ€èšãããŠããæ¹ã®åèã«ãªãã°ãã¹ããæŒããŠããã ãããšå¬ããã§ããâšð»