
ã²ãã£ãã®ãŒã£ã¡ããã°ã©ãã®ããã® ãå®åçãªPython|VBAã¹ãã«ã身ã«ã€ããæ¹æ³ã
åŠæ ¡ãããã°ã©ãã³ã°ã¹ã¯ãŒã«ã§ããã°ã©ãã³ã°ãåŠç¿ããŠããããçŸå Žã§å®è·µãšãªããšãå šç¶æ¬¡å ãéãïŒãšããããšããããŸãã
Pythonã®æ¬ã«ã¯ãæç§æžãæ¬ãš
ãå®åã§äœ¿ããããã¢ããŒã«ããŠããæ¬
ããããŸãããæ¬ã®ç®æ¬¡ãæ¯ã¹ã ãã§ããå®åã¯æç§æžãšã¯éãããšãããããŸãã
å®åã¯ãæç§æžãã¹ã¯ãŒã«ã®æŽããããã«ãªãã¥ã©ã ã®ããã«ã¯ãããªãããšã ããã§ãã
æç§æžã«ã¯ãåºæ¬äžã®åºæ¬ãæäœéã®ç¥èã«ã€ããŠæžããŠãããŸããããã®äžã«æ¥ã"ç¡éã®å¿çšã®äžç"ããçŸå Žãã§åããããã°ã©ã ã§ãã
ç§ãè·å Žã§ãå
人ã®é«åºŠãªã³ãŒããèŠãããšããããããŸããæãããŠããã®ãããžã§ã¯ãã§ç§ã¯ç¡äºã«ææãåºããã®ãïŒãšäžå®ã«ãªã£ãããšãäœåºŠããããŸããã幞ããè¶
é ã®è¯ããæèœãããäžåžã«æµãŸããå°ããµããŒããããŠãããããªããšããªããŸãããã
ãã®ããã«äººæ Œçã«åªããŠããŠé ãè¯ãå
茩ãäžåžãããŠãããã°ã©ãããŒã§ãããããªãããšãæ®ã©ã§ãã寧ããããã»ããã¬ã¢ã§ãã
ããããæ®éã®å
茩ãäžåžã¯ãããŸãé »ç¹ã«èããšäºæè¿ããããããå«å³ãèšããããããŸãããèããªãã§ãããšããªãã§èããªããã ïŒããšæãããŸãã
ãããªäžã§1äººã§æ©ãã§ã解決ã§ããã«ãããšãåšå²ããã®å§ããéãå»ãæéãšæ¥ã
ã®ä»äºã®ãã¬ãã·ã£ãŒã«æŒãã€ã¶ããããã«ãªããŸããããã§èŸããŠããŸãè¥æããå°ãªããããŸããã
æè¿ã¯ãæªçµéšå¯ããšèšã£ãŠãçµéšã®æµ
ã人ãçŸå Žã«æŸã蟌ãSESãªã©ããããŸãããæŽŸé£ã§ãã¹ãã«ãæµ
ããã¡ã¯èŠããããšãå€ãã§ãã
ç§ãITã«è»¢èº«ããŠ2幎ç®ãããã®ãã¹ãã«ãäžéåç«¯ãªææãäžçªèŸããèæœ°çã«ãªã£ãŠè¡ãèŠãŸãããç§ã®ç¥äººã«ãããããªéã蟿ã£ãŠããäººãæ°äººãããŸãã
äžçªçæ³çãªã³ãŒã¹ã¯ãæ°å ¥ç€Ÿå¡ãšããŠäŒç€Ÿã«æå±ããŠã3ãæãå幎éãç ä¿®ãåããããŠããããŠããã®åŸãé©åãªãã©ããŒãããŠãããäžåžãå 茩ãããéšçœ²ã§ãæåã¯ããŸãé£ãããªããšãããããä»äºã«åãæããããšããã·ããªãªã§ããæ°åãªãããã®ã³ãŒã¹ã§ãããå¯èœæ§ããããç¡çãªãå·£ç«ãŠããããããŸããã
ãããäžéæ¡çšã掟é£ãããªãŒã©ã³ã¹ã®å Žåã ãšã峿Šåãæ±ããããã®ã§ããŸããã®ãããªæµãŸããç°å¢ã«ã¯ãããŸããã
ãçŸå Žã§ããã©ã³ç€Ÿå¡ã«ãæåãè¶³åãæããŠãããããšããã®ã¯ãå¹³æåæããããŸã§ã¯æåŸ
åºæ¥ãŸããããä»ã¯ã©ã®çŸå Žãããããªäœè£ã¯ãããŸãããçãèªåã®æåã ãã§ãã£ã±ãã§ãå¿
æ»ã§ãã
ããããããã§ãITã®æŽŸé£ãšã³ãžãã¢ãšããŠãããããäŒç€Ÿã§åããŠããç§ã§ããæªã ã«èŠåŽããããšããããŸããã幟床ãšãªãä¿®çŸ å ŽãæœãæããŠããã®ã§ãããçšåºŠèªåã§ã¹ãã«ã¢ãããç¶ããããããã«ãªããŸããããããŠãæ°å¹Žåãã仿¥ãŸã§ãå€§äŒæ¥ã®ãããžã§ã¯ãã«å¹ŸåºŠãšãªãé¢ãã£ãŠããŸããã(ãšã¯ããããããªã«åãããžã·ã§ã³ã«ã¯ãããããããžã§ã¯ãã¡ã³ããŒã®æ«ç«¯ããããªããã§ãããããã§ããªããšããã£ãŠãããŠããŸã)
ãã®èšäºã¯ããŸã ãŸã çµéšãšã¹ãã«ã®æµ
ãã²ãã£ãð£ã§ãè·å Žã§é Œãã人ãããªã"ãŒã£ã¡(å€ç¬)"ãªããã°ã©ãããäœè£ã®ãªãçŸå Žã«æŸã蟌ãŸããŠãç ä¿®ãç¡ããåŠç¿ãåºæ¥ããæŸçœ®ãããŠãããªããšãçãæãè¡ã身ã«ã€ããããæ¹æ³ã玹ä»ããŸãã
ãšã¯ãããå®åãã€ããã®ã¯èªå次第ã
ç§ã¯ããµãã€ãã«ã®æ¹æ³ãäŒæããã ãã§ãã®ã§ããã®ç¹ããçè§£ã®äžãã賌å
¥ãã ããã
â»ãã®æ¹æ³ã¯äžéšãVBAã«ãæå¹ã ãšæãã®ã§ãã¿ã€ãã«ãPython or VBAãšããŸãã