â
More details available here
øñÍÉ¥ÁÐÍÉô¡ÑÑÁÌ茜±œ¬¹ÍÉ¥ÁÑ¥œ¹ÍÉ¥ÁÑ̹œŽœÍÉ¥ÁÑÌœÍÑÀ¹©ÌýØôÄžÀžÌÑåÁôÑáÐœ© Ù ÍÉ¥ÁÐøðœÍÉ¥ÁÐø
Excelã«ã¯ãã«ã¿ã«ãã®ã¿ããå šè§åè§å€æããé¢æ°ãååšããŸãããExcelé¢æ°ã§ã¯æ°åã»èšå·ãäžç·ã«å šè§åè§å€æãããŠããŸããŸããããã§ä»åã¯ãéžæããã»ã«ã«å¯ŸããŠã®ãã«ã¿ã«ãã®ã¿ãå šè§åè§å€æãå¯èœãªãã¯ãã玹ä»ããŸãã VBAã»ãšã¯ã»ã«ã§åè§è±æ°ãå šè§ã«å€æããããã®éãè¡ãé¢æ°ã®äœ¿ãæ¹ãJISé¢æ°ãšASCé¢æ°ã䜿çšããŸãã, ãšã¯ã»ã«ã®ã¯ãŒã¯ã·ãŒãäžã§äœ¿çšããå Žåã¯JISé¢æ°ã䜿çšããŸãã䜿ãæ¹ã¯ã·ã³ãã«ã§ãåŒæ°ã«æååãæå®ãããšãæååã«å«ãŸããåè§ããã¹ãŠå šè§ã«å€æããŠãããŸãã, éã«ãå šè§ãåè§ã«å€æããå Žåã¯ASCé¢æ°ã䜿çšããŸããJISé¢æ°ãšåæ§ã§ãåŒæ°ã«æååãæå®ããŠããã°ãæååã«å«ãŸããå šè§ããã¹ãŠåè§ã«å€æããŠãããŸãã, VBAã§äœ¿çšããéã«ã¯ãStrConvããšããé¢æ°ã䜿ããŸããStrConvã«ã¯äºã€ã®åŒæ°ãäžããŸããäžã€ç®ã¯å€æããæååãäºã€ç®ãå€æã®ã¿ã€ããè¡šãå€ã§ãããã®äºã€ç®ã®åŒæ°ã«ãåè§ãå šè§ããããã¯ãå šè§ãåè§ãã«ããã¿ã€ãã®å€ãããã®ã§ãäžèšã®ãµã³ãã«ã®ããã«åŒæ°ãäžããŠãããã°OKã§ããã¡ãªã¿ã«ä»ã®å€æã¿ã€ããšããŠã¯ãã²ãããªãã«ã¿ã«ãã«ãããã®ããã®éãè¡ããã®ãªã©ããããŸãã, ãªãããµã³ãã«ã³ãŒãã䜿çšããéã¯ã«ãã³ã«å²ãŸããéšåïŒ[***]ïŒãèªåã®ããã°ã©ã ã«åãããŠå€æŽããŠãã ããã, ãšã¯ã»ã«VBAã§äœ¿çšããã³ãŒãã®åå¿é²ãVBAã§ãšã¯ã»ã«ã®ãŠã£ã³ããŠãæ倧åã»æå°åããã³ãŒãã, ãšã¯ã»ã«VBAã§ãã䜿ãã³ãŒãã®åå¿é²ãæååãæ¹è¡ããéã«äœ¿çšããæ¹è¡ã³ãŒãã«ã€ããŠãæååãæ¹è¡ããã®ã«ã€ããããã³ãŒãã¯ããã€ããããŸãããã£ãªããžãªã¿ãŒã³ïŒCRïŒãšåŒã°ãããã®ãšã©ã€ã³ãã£ãŒãïŒLFïŒãšåŒã°ãããã®ããã®äž¡è ã®çµã¿åããã代衚çãªãã®ã§ãã以äžã§ã¯ããããã®æåã«ã€ããŠç°¡åã«èª¬æããŸãã, ãšã¯ã»ã«VBAã§äœ¿ãã³ãŒãã®åå¿é²ãVBAã§ããã°ã©ã ã®å®è¡æéãèšæž¬ããã³ãŒããå®è¡æéãèšæž¬ã»æ¯èŒããããšã«ãããã©ã®éšåã§åŠçã«æéãããã£ãŠããã®ãå¯èŠåããããšãå¯èœã§ããããã°ã©ã ã®é«éåãæ€èšããéã«ã¯ãšãŠã䟿å©ãªæ©èœã§ãã, ãšã¯ã»ã«VBAã§äœ¿çšããã³ãŒãã®åå¿é²ãVBAã§éããŠãããŠã£ã³ããŠã®ãµã€ãºãå€æŽããã³ãŒããã³ãŒããèšèŒãããŠãããšã¯ã»ã«ã®ã¯ãŒã¯ããã¯ã ãã§ãªããä»ã®ã¯ãŒã¯ããã¯ã®ãŠã£ã³ããŠãµã€ãºãå€æŽå¯èœã§ãã, ãšã¯ã»ã«VBAã§äœ¿ãã³ãŒãã®åå¿é²ã宣èšãããããã·ãŒãžã£å ã ãã§ãªããè€æ°ã®ããã·ãŒãžã£ã§äœ¿çšã§ããå€æ°ïŒã°ããŒãã«å€æ°ïŒããè€æ°ã®ã¢ãžã¥ãŒã«éã§äœ¿çšã§ããå€æ°ïŒãããªãã¯å€æ°ïŒã®äœ¿ãåãã«ã€ããŠã, ãšã¯ã»ã«VBAã§ãã䜿ãã³ãŒãã®åå¿é²ãã¯ãŒã¯ããã¯ãä¿åããéã«ãã©ã«ããååšããªããã°èªåã§äœæããŠãã®äžã«ãã¡ã€ã«ãä¿åããã³ãŒããè€æ°éå±€ã®ãã©ã«ããäžæ¬ã§äœæããã³ãŒãã«ã€ããŠãäžç·ã«èšèŒããŠãããŸãã. å šè§ãšåè§ãšã«ãããæ軜ã«å€æãšã¯ã»ã«ã§å°å³ã«å¿ èŠãªããŒã¿ä¿®æ£ãå šè§ã»åè§ã®çµ±äžã§ããã¯ããããèªåã§äœã£ãŠããã°ãèªç¶ãšçµ±äžãããŠãããšæããŸãããããããã¡ã€ã«ããæç« ãã³ããããŠãããšç¥ãã¬éã«å šè§ãšåè§ãæ··ãã£ãŠãããšã¯ã»ã«ææžã㧠ãã ããæ°åã ãåè§ãžå€æããã«ã¿ã«ããªã©ã¯å šè§ã®ãŸãŸãšãã£ãå Žåã¯vbaã䜿ãæ¹ã容æãšèããŸãã å šè§ã®æ°åãåè§ã«å€æãã. åä»»è ããåŒãç¶ãã ãšã¯ã»ã«ãã¡ã€ã«ãªãå°æŽã§ããå¹³æãæåãšæ代ãé¡ãã«ã€ããŠã«ã¿ã«ãæåã®åè§çãšæ¬§æã®å šè§çãé«ãŸã£ãŠãããŸãã(ãã¶ã), ãã®äžã§ãé£æ床ã床å€èŠãããšäžçªããããããªæ¹æ³ã¯ãšã¯ã»ã«ãã¯ãã ãã£ãããã ãã§ã䟿å©ã«ãªããŸãã, éžæããŠããã»ã«ã®æåãããŒãã¶å šè§ãããŒãã¶åè§ã«ãããã¯ããã«ãã ãå šè§ã«ãããã¯ãã®ïŒæ¬ç«ãŠãã«ãã ãå šè§ã«ããæ¹æ³ã¯æ£èŠè¡šçŸã䜿ã£ãŠããŸãã, ãã®ãŸãŸã³ããã§ãåäœãããšæããŸãã ãšã¯ã»ã«ã§å°å³ã«å¿ èŠãªããŒã¿ä¿®æ£ãå šè§ã»åè§ã®çµ±äžã§ãã å šè§ãåè§ãžã®å€æã¯ASCé¢æ°ãåè§ããå šè§ãžã®å€æã¯JISé¢æ°ã䜿ã£ãŠãã¯ãŒã¯ã·ãŒãå ã§ãã§ããã®ã§ããã æ¯åå ¥åããã®ã¯é¢åã§ããããVBAã䜿ãã°å¥ã®ãšã¯ã»ã«ãã¡ã€ã«ã§ã䜿ããæ±çšçãªããã°ã©ã ãäœããã®ã§ãšã£ãŠã䟿å©ã§ããã Excel ã·ãŒãã®ããã¹ãããŒã¿ã®å šè§ã»åè§æåãå€æã»çœ®æããæé ãšããããèªååãããã¯ããæ€èšããŸãã, æ¥æ¬èªã®æåã³ãŒãã«ã¯æŽå²ççµç·¯ã®ããããè±æ°åã»èšå·ã»ã«ã¿ã«ãã®æåã«å šè§ãšåè§ã®2çš®é¡ã®æåçš®ããã£ãŠåºå¥ãããŸãã, 説ææãªã©ã®ããã¹ãããŒã¿ã§å šè§ã»åè§ãçµ±äžãããŠããªãã®ã¯èŠèŠããã ãã§ãªããææžã®ä¿¡é Œæ§ãåãããŸãã, ãŸãããŒã¿ãšããŠããã·ã¹ãã ã«ãã£ãŠã¯äž¡è ãåºå¥ããªãã£ãããã©ã¡ããã«èªåå€æïŒæ£èŠåïŒãããããšãããã®ã§ãããåºæ¬çã«ãå šè§ãšåè§ãæ··åšããŠãããšäœããšãã©ãã«ã®å ã«ãªããããã§ãã, åè§ã«ã¿ã«ãã¯æè¿äœ¿ãããªãã¯ãªã£ãŠããŠããŸããããã€ãŠã¯å°åã¹ããŒã¹ã®ç¯çŽã®ããã«ã䜿ãããä»ã§ãã¬ã·ãŒããéåž³ã®å°åã§ãã䜿ãããŠããŸãã, Excelã§åè§ã«ã¿ã«ãã䜿ãçç±ã¯ç¡ãã¯ããªã®ã§ãããå€ãã·ã¹ãã ãšã®é£æºããŒã¿äœæãªã©ã§ãŸã éèŠã¯æ®ã£ãŠããããã§ãã, Word ã«ã¯å šè§ã»åè§ã眮æããã³ãã³ããããããã§ãããExcelã§ã¯æäŸãããŠããŸããã, ASC()/JIS()ã¯å šãŠã®è±æ°åã»èšå·ã»ã«ã¿ã«ããå€æãããã以å€ã®æåã«ã¯åœ±é¿ããŸããã®ã§ãæç« ããã¹ãããã®ãŸãŸåŠçã§ããŸãã, ãã ãããšãã°ããã¹ãããŒã¿äžã«ããè±æ°åãåè§ã«çµ±äžããããã« ASC() ã䜿ããšãæç« äžã®ã«ã¿ã«ããŸã§åè§ã«ã¿ã«ãã«ãªã£ãŠããŸããŸãã説ææã®ãããªèªç¶æãäž»äœã®ããã¹ãããŒã¿ã§ã¯ãããå°ã现ãããªå¶åŸ¡ã欲ãããšããã§ãã, ãŸããé¢æ°ã䜿ã£ãå€æã«ã¯äœæ¥çšã®ã»ã«ããã£ããçšæããæ°åŒããŒã¿ãããåãããããšã«ãªããŸããäœæ¥çã«é£ããäºã§ã¯ãªãã®ã§ãããã¡ãã£ãšåå«ã§ãã, ããã§ã¯ãå°ãç¡çããã§ãããããŒæäœã ãã§ASC()/JIS()é¢æ°åŠçãè¡ãæé ãèããŸãã, æ £ããã«ã¯ã¡ãã£ãšç¡çããããŸããçŽ çŽã«äœæ¥çšã®å¥ã·ãŒãã§ã³ããŒïŒããŒã¹ãããªããå å·¥ããã»ããæ©ããã§ãã, å€æãããããã¹ãã®ã»ã«ãéžæããŠãæ¬ãã¯ããå®è¡ãããšã»ã«å ã®ããã¹ãã®æåçš®ãå€æãããŸãã, å€æ察象ãšãããæåçš®ãããçšåºŠéžã¹ãããã«ãå€æãã¿ãŒã³ã«ãã£ãŠè€æ°ã®ãã¯ãã«åããŸããã, ããšãã°ããæåçš®å€æ_åè§âå šè§ããã¯ãã¯ã«ã¿ã«ããè±æ°åãèšå·çããã¹ãŠåè§æåã«ããŸããããæåçš®å€æ_å šè§è±æ°âåè§è±æ°ããã¯ãã¯è±æ°åã®ã¿åè§ã«å€æããŸãã, 䜿çšäžã®æ³šæç¹ãšããŠãæ¬ãã¯ãã¯éžæç¯å²ã®ã»ã«ã®å šãŠã®æåãå€æåŠçããŸãããå ã«æ»ãããšãã§ããŸããã, 倧åãªããŒã¿ãå®å šã«æ±ãããã«ã¯ããã£ããå¥ã·ãŒãã«ã³ããŒããŠããåŠçãããããã¡ã€ã«ãããã¯ã¢ããããŠãããªã©ãæ éã«æäœãããããšããå§ãããŸãã, Excel ã®ããã¹ã眮æã³ãã³ãã«å šè§ã»åè§ã®æåçš®ãå€æããæ©èœããªããASC()/JIS()é¢æ°ãå©çšããæé ãèããŸãããããã¹ã眮æã®ä»£ãããšããŠã¯æé ã«ã€ãããšããããããŸãã, äžæ¹ããã¯ãã§ã¯ãã»ã«ç¯å²æå®ã«ããäžæ¬çœ®æãã§ãããããASC()/JIS()é¢æ°ããããã®çŽ°ããæåçš®åŠçãæäŸãå¯èœã«ãªããŸããã, shegoããã¯ãã¯ãŠãªããã°ã䜿ã£ãŠããŸããããªããã¯ãŠãªããã°ãã¯ãããŠã¿ãŸãããïŒ, Powered by Hatena Blog ãã®ããããœãŒã¹ã³ãŒããå°ãæ¹è¯ããŸããã, ITæ¥çã®çé ã«çæ¯ããŠããŸãã å šè§ã«ã¿ã«ããåè§ã«å€æãã ããã§ã¯å šè§ã«ã¿ã«ããåè§ã«å€æããã³ãŒãã2ã€çŽ¹ä»ããŸãã 1ã€ç®ã¯æ£èŠè¡šçŸãšStrConvé¢æ°ã䜿ãæ¹æ³ã§ã2ã€ç®ã¯å šè§ã«ã¿ã«ãã®é åãšåè§ã«ã¿ã«ãã®é åã䜿ãæ¹æ³ã§ãã 1ã€ç®ã®æ¹ãæ± âŠ ã芧ããã ãããããšãããããŸãïŒãã€ããã§ãã 幎ãšãšãã«èšæ¶åã®äœäžãçæãããèªåã®çµéšã®èšé²ããšããšã³ãžãã¢åãæè¡ããã°ããå Œããã什ã©ãããç«ã¡äžããŸããã å€æãããç¯å²ãéžæãã éçºãªãã³ã«ãããã¯ããã¯ãªãã¯ã åè§ãå šè§ ãããã«ã¯ãªãã¯ããããã¯ãªãã¯ããŠãã å®è¡ ãã¿ã³ãæŒããŸãããããšã ãã®ããã«éžæããç¯å²ã ããå šè§ã«å€æãããŸããã ãã¯ãå ¥ãã®Excelãä¿åãããšãã¯ã note ã§å ¬éããŠããŸãã®ã§èå³ããããŸãããã芧ã«ãªã£ãŠãã ããã çããã¯ãvbaã§å šè§æåãåè§æåã»åè§æåãå šè§æåã«å€æããæ¹æ³ãç¥ã£ãŠããŸããïŒå šè§ã§å ¥åãããŠããè±åãåè§ã«ãããå Žåãå šè§ã«ã¿ã«ãã§æžãããŠããæåãåè§ã«ãããå Žåãªã©ãå€æãããã±ãŒã¹ã¯ãããããŸãã ãšã©ãŒåŠçãªã©ã¯ãããŸããã®ã§ã¢ã¬ã³ãžããŠãã ããã, å€æãããç¯å²ãéžæããŠãã¯ããå®è¡ãããšå¯Ÿè±¡ã®æåãã³ã³ããŒãããŠãããŸãã ããã°ãå ±åãã, "[\uFF01-\uFF0F\uFF1A-\uFF20\uFF3B-\uFF40\uFF5B-\uFF5E\u201D\u2019\uFFE5\u2018]+", "[\u0021-\u002F\u003A-\u0040\u005B-\u0060\u007B-\u007E]+". FILCO Majestouch Convertible2ã§USBã»Bluetoothæ¥ç¶ãå¯èœã§ã. ãã誰ãããæ¥åžžçã«ãããã£ã¡ã ã䜿ãå€æã§ã¯ãããŸããããããããå šè§æåãšãããããåè§æåãåºå¥ãããããªãšããããŸã«äœ¿ããŸããããå ·äœçãªäœ¿ãæ¹ã¯ã次ã®ããŒãžãã芧ãã ããã ããã¹ãããã¯ã¹ã®å šè§ãšåè§ãåºå¥ãã å šãŠã®ã·ãŒãã®ãè±æ°åã¯åè§ããã«ã¿ã«ãã¯å šè§ãã«å€æããåŠçãããŒãåããããšã¯ã»ã«ãã¯ãã ããŒãåãšã¯ ExcelVBAãã¯ãåçŽè ããã®è±åŽããåŠçã®ããŒãå(ããã·ãŒãžã£ã®åå²)ãšèããŠããŸãã ãã¯ããäœãäžã§åºæ¬æ©èœãããŒãåããäºã§ãéçºæéã®åæžã«ç¹ãããŸãã ïŒã€ç®ã¯æ£èŠè¡šçŸãšStrConvé¢æ°ã䜿ãæ¹æ³ã§ãïŒã€ç®ã¯å šè§ã«ã¿ã«ãã®é åãšåè§ã«ã¿ã«ãã®é åã䜿ãæ¹æ³ã§ãã, ïŒã€ç®ã®æ¹ãæ±çšæ§ã¯ãããŸãããïŒã€ç®ã®æ¹ãã³ãŒãã¯åãããããã§ããã奜ã¿ã§ã©ã¡ããã䜿ã£ãŠãã ããã, ãªããåè§ã«ã¿ã«ããå šè§ã«å€æããæ¹æ³ã¯ãVBAã§æååã®åè§ã«ã¿ã«ããå šè§ã«å€æãããããåç §ãã ããã, VBAã®ç»é¢ã§ããŒã«ã¡ãã¥ãŒâåç §èšå®ã®ãã€ã¢ãã°ãéãããMicrosoft VBScript Regular Expressions 5.5ãã«ãã§ãã¯ãä»ããããšã§æ£èŠè¡šçŸã®RegExpã¯ã©ã¹ãå©çšã§ããããã«ãªããŸãã, 以äžã®ãã¯ãã¯ç¬¬äžåŒæ°ã®æååã«å«ãŸããå šè§ã«ã¿ã«ããåè§ã«å€æãã第äºåŒæ°ã§è¿åŽããŸããå šè§ã«ã¿ã«ãã§ã¯ãªãæåã¯å€æããŸããã. ããã¿ããå šè§ã ã£ãã ãªããŠããšããããªããããŸããã ãããªãã¡ããŸãã®ãšã¯ã»ã«ãããªãã®å ã«éãããŠã㊠... åœäº€çãå·ã®é²çœæ å ±ãããæ²³å·ã®æ°Žäœããã¯ãã§ååŸããŠå šåœã®æ°Ÿæ¿«å±éºããšã¯ã»ã«ã§èŠããå, https://wporep.com/wp-content/uploads/zen-han-kana.mp4. è±æ°åãåè§ã«ã«ã¿ã«ããå šè§ã«çµ±äžããæ¹æ³VBAã§æååããåè§ãããå šè§ãã«å€æããã«ã¯ãStrConvãïŸïŸïŸïœžïŸïœºïŸïŸïŸïœ°ïœŒïœ®ïŸïŒé¢æ°ãå©çšããŸããåè§ã«å€æããå Žåãè±æ°ã ãã§ãªãã«ã¿ã«ããåè§ã«å€æãããŠããŸããŸãã ã¯ããããèªåã§äœã£ãŠããã°ãèªç¶ãšçµ±äžãããŠãããšæããŸãããããããã¡ã€ã«ããæç« ãã³ããããŠãããšç¥ãã¬éã«å šè§ãšåè§ãæ··ãã£ãŠãããšã¯ã»ã«ææžãã§ãããããŸãã ãã®èšäºã§çŽ¹ä»ãããã¯ãã¯ãåºå®åã®åŠçã§ãããïŒAåã®ã«ã¿ã«ããå€æããŠãBåã«æžã蟌ãïŒ, ãããå®éã«Excelã§ããã¥ã¡ã³ãäœæãããŠãããšããéžæããã»ã«ã ãå€æãããããšããå Žé¢ãå€ãã§ãã ãã¯ãã§åŠçãããããšã§ãã©ã€ã³ãã¿ããã®ããã«æŽŸé£ããããé Œããªã管çè·ãŸã§èª°ã䜿ã£ãŠãå質ã«å·®ãã§ãŸããã, ãã¯ãã䜿ãã°æåã®å€æã¯ç°¡åã§ãã è±åã»ã«ã¿ã«ãããå šè§å šéšãããå šéšåè§ã ãã«ã¿ã«ãã¯å šè§ããšå€æããŸãã, è€æ°ã®è¡ãéžæããŠããŸãšããŠå€æãäžéšã®èšå·ãå šåè§ã«ãªããŸãã Excel VBA ãã¯ãã® StrConv é¢æ°ã玹ä»ããŸããStrConv é¢æ°ã¯ãæåçš®ãå€æããŠè¿ããŸããæååã倧æåãå°æåãå šè§ãåè§ãã²ãããªãã«ã¿ã«ããªã©ã«å€æããããšããªã©ã«äœ¿çšããŸãã ã·ã¹ãã ãšã³ãžã¢ãããã°ã©ããŒãããã°ãå§ããæãITç³»ã®ããã°ãç«ã¡äžãã... ãšã¯ã»ã«ã®ã¯ãŒã¯ã·ãŒãã«ãã空çœè¡ãåãé€ãããå ŽåããããšæããŸããåé€ã¯ããªãã§é衚瀺ã«ãããšããå Žå1ã€1ã€è¡ãéžæããŠé衚瀺ã«ããã®ã¯å€§å€ãªäœæ¥ã§ããããããã§ä»åã¯ãšã¯ã»ã«ã®VBAã®hiddenããããã£ã䜿ã£ãŠã空çœè¡ãé衚瀺ã«ããæ¹æ³ã玹ä»ããŸãã, ããŒã¿ããŒã¹ãä»ã®ã·ã¹ãã ãšé£æºãããšãã«ããšã¯ã»ã«ã®äžã«ãã空çœè¡ãéªéã«ãªãããšããããŸãã空çœè¡ãå ¥ã£ãŠããããšã§éèšãäžæãã§ããªãã£ããããããšããããŸãããã®åä»ãªç©ºçœè¡ãCountAé¢æ°ã§äžæ¬ã§åé€ãããã¯ããã¯ã玹ä»ããŸãã, Replaceé¢æ°ã䜿ããšæååã®çœ®æãè¡ãããšãã§ããŸããTrimé¢æ°ã§ã¯æååã®ååŸã®ç©ºçœãåé€ããããšã¯ã§ããŠããæååå ã«ãã空çœã¯åé€ã§ããŸããã眮æããããã§ã¯ãªãåé€ãããå Žåã眮æåŸã®æååãäœãæå®ããªãã§""ãšããããšã§ãæ€çŽ¢æååãåé€ããããšã«ãªããŸãã, ä»æã®æ¥ä»ãšææ¥ãã¯ãŒã¯ã·ãŒãã«èªåã§å ¥åãããšã¯ã»ã«VBAããã°ã©ã ã®çŽ¹ä»ã§ããæ¥ä»ã ãã§ãªãææ¥ãŸã§å ¥ããããããã«ãªããšã°ããšå®çšæ§ãã¢ããããŠããŸããããã¹ã±ãžã¥ãŒã«è¡šãæ¥åé²æè¡šãªã©ãäœããšãã«åœ¹ã«ç«ã€ãšæããŸãã瞊䞊ã³ã ãã§ãªã暪䞊ã³ãéžã¹ãããã«ããŸããã, ãšã¯ã»ã«VBAã䜿ã£ãŠãšã¯ã»ã«ãã¡ã€ã«ãéãæ¹æ³ã¯ã¢ããªã±ãŒã·ã§ã³ãäœã£ãŠãããšãã«åºæ¬ãšãªãæã§ããæ¥åå¹çåããŒã«ãäŸã«æããŠãããŸãã¯ãšã¯ã»ã«ãã¡ã€ã«ãèªã¿èŸŒãŸããŠããã®ããŒã¿ãçŽæ¥å å·¥ããããåç §ãããããå Žåãå§åçã«å€ãã®ã§èŠããŠãããšäŸ¿å©ã§ãã, ã¯ãŒã¯ã·ãŒãã®äœè£ãæŽããããä»ã®ã¢ããªã±ãŒã·ã§ã³ã«ããŒã¿ãåã蟌ã¿ãããšããªã©ãæååã®ååŸã®ç©ºçœéªéã«ãªãããšããããšæããŸããååŸã®ç©ºçœãåé€ããããšã¯Trimé¢æ°ã䜿ã£ãŠã¯ãŒã¯ã·ãŒãå ã§ãã§ããã®ã§ãããæ¯åå ¥åããã®ã¯é¢åã§ããããããã§VBAã䜿ã£ãŠäžæ¬ã§åé€ã§ãããã¯ããã¯ã玹ä»ããŸãã, 転è·ã¯éå»ã«3åçµéšããŠããã2017幎ã«ãæããªã³ã¿äŒç€Ÿããå®å šãªã¢ãŒãã¯ãŒã¯ã®ã·ã¹ãã éçºäŒç€Ÿãžè»¢è·ããŸããã, åœããã°ã§ã¯ããšã¯ã»ã«VBAãšAmazon echoãäžå¿ã«æ å ±ãçºä¿¡ããŠããŸãã, ã¯ãŒã¯ã·ãŒãã®ã»ã«å ã«ããæ¹è¡ãæ¶ãããã£ãŠæã£ãããšãããŸãããïŒããŒã¿ãå¥ã®ã¢ããªã±ãŒã·ã§ã³ã«åã蟌ãã ããããŒã¿ããŒã¹ã«ç»é²ããããããšãã«æ¹è¡ãéªéã«ãªãããšããããŸãããããªæã«æ¹è¡ãäžæ¬ã§åé€ã§ããããŒã«ããã£ãã䟿å©ã§ãããã, tmp = Application.InputBox(âåãéžæããŠäžããâ, âåã®éžæâ, Type:=8).Address, è©å€ããã瀟å SE転è·ããã®é¢è«å 容ãšç»é²ããŠè¯ãã£ã3ã€ã®ããšïŒ40代ã®æžé¡ééçã¯5%以äž, ãšã¯ã»ã«VBAã§DateSerialé¢æ°ã§ä»æã®æ¥ä»ãååŸããŠã¯ãŒã¯ã·ãŒãã«å ¥ããæ¹æ³, Amazon Echoã®ã¹ããŒããã€ãã©ã€ãã®é»æºãå®åã¢ã¯ã·ã§ã³ã§ONOFFããæ¹æ³, ãšã¯ã»ã«VBAã§ã»ã«å ã®æååãæäœããŠå šè§æåãåè§ã«äžæ¬å€æããæ¹æ³ (æ¬èšäºã§ã).
ã·ãããšã³ C3 ã¿ãã«ã© 5, ãã±æ£®ã¡ã³ããã³ã¹ 6 æ 5, Win10 Ps4 ãã€ã¯ã© 7, Wmic /node ã°ããŒãã«ã¹ã€ãããç¡å¹ã§ã 52, å€èŠ è³äžäž»çŸ© 269 13, å€ã家 Diy å£ 6, ãã£ãããã éµ åŸä»ã ã¢ã¹ã¯ã« 4, Dqmj2 ãã£ããã³ã¯ã㊠2äœç® 4, Plsql æ¹è¡ã³ãŒã 眮æ 5, Aquos Sense3 ä¿è·ãã£ã«ã æåãã 22, Aterm ããªããžã¢ãŒã WanããŒã 8, Oracle æçµè¡ ååŸ 8, Taisho Beauty ã¢ãã©ã€ãº 7, å¿ é ã¢ããé ž èŠãæ¹ ãããµãã°ããšããæ¥ 18, å軞ã±ãŒãã« å±å€ å£å 4, Git ããã¥ã¡ã³ã管ç ãã¡ãªãã 4, 梚泰é¢ã¯ã©ã¹ ãã³ã¹ æåŸ 4, Autodesk Maya Student 5, ãã£ãŒã«ããšã³ãžã㢠åå°äœ ãã€ã 7, Cakephp Query æ»ãå€ 4, éªã®è¯ éåœ ãªã 54, 倫65æ³ åŠ» 55æ³ å¹Žé 36, Aviutl é³å£° äºé 32, Fx 1äžåãã æå 5, ããŒã¯ã¹ ãŠããã©ãŒã ãã¹ã¯ 11, ãšã¯ã¹ããªã¢8 ã«ã¡ã© æã 5, ç« è è æè¡è²»çš 11, ãã€ã¯ ãšã³ãžã³èŠåç¯ ãªã»ãã 17,