³ô¡¡´°Á´¼«Æ°ÇäÇã¡¢¥·¥¹¥Æ¥à¥È¥ì¡¼¥É¤ò VBA¤Ç¼Â¸½¤¹¤ëÊýË¡
¡¡¡¡
³ô¼è°ú¤ò¤·¤Æ¤¤¤Æ¡¢°Ê²¼¤ËÅö¤Æ¤Ï¤Þ¤ë¿Í¤¤¤Þ¤»¤ó¤«¡©
¡¦¥ê¥¹¥¯¤ò¸º¤é¤¹¤¿¤á¤Ë¥Ç¥¤¥È¥ì¡¼¥É¤ò¤·¤¿¤¤¤¬¡¢
»Å»ö¤ò¤·¤Æ¤¤¤ë¤¿¤á½ÐÍè¤Ê¤¤¿Í
¡¦¤¤¤Ä¤â´óÉÕ¤¤ÇÇã¤Ã¤Æ¤·¤Þ¤¤¡¢
¹âÃͤò¤Ä¤«¤Þ¤µ¤ì¤ë¤³¤È¤¬Â¿¤¤¿Í
¡¦¥Ñ¥½¥³¥ó¤Ë¼«Æ°¤ÇÇäÇ㤵¤»¤Æ¡¢
ͪͪ¼«Å¬¤ÎÀ¸³è¤òÌ´¸«¤Æ¤¤¤ë¿Í
¤³¤ó¤ÊËܤ¬¤¢¤ê¤Þ¤¹¡£
¥Ç¥¤¥È¥ì¡¼¥À¡¼ÆÁ»³½¨¼ù¼°·î100Ëü±ß¤¬¼«Á³¤È²Ô¤²¤ë!
³ô¤Î´°Á´¼«Æ°ÇäÇã
¤³¤ÎËܤòÆÉ¤ó¤Ç´°Á´¼«Æ°ÇäÇã¤ò¤·¤è¤¦¤È»×¤Ã¤¿Êý¤Ï¿¤¤¤È»×¤¤¤Þ¤¹¡£
¤¿¤À¤·¡¢¤³¤ÎËܤϰìÈÖÂç»ö¤À¤È»×¤ï¤ì¤ë¼ÂºÝ
¤Ë¤É¤Î¤è¤¦¤Ë¼«Æ°¤ÇÃíʸ¤ò½Ð¤¹¤Î¤«¤Ë´Ø¤·¤Æ¤Ï½ñ¤«¤ì¤Æ¤¤¤Þ¤»¤ó¡£
Ëܲ°¤Ë¹Ô¤Ã¤Æ¤â¤½¤ó¤ÊËܤʤ¤¤·¡¢¥Í¥Ã¥È¤Çõ¤·¤Æ¤â¤É¤¦¤¹¤ì¤Ð¤¤¤¤¤Î¤«½ñ¤¤¤Æ¤¢¤ë¥µ¥¤¥È¤Ï¸«¤Ä¤«¤é¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£
¿ʬ
¤ß¤ó¤Ê¤ÇÆâ½ï¤Ë¤·¤Æ¤¤¤ë¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
ɬÍפʾðÊó¤ò¤ªÇä¤ê¤¤¤¿¤·¤Þ¤¹¡£
VBA¤Ë¤è¤Ã¤Æ
¼«Æ°ÇäÇã¤ò¤¹¤ë°Ù¤ÎɬÍ׺ÇÄã¸Â¤Î¾ðÊ󤹤٤Ƥò¤ªÇä¤ê¤·¤Þ¤¹¡£
¤³¤³¤Ç¤ªÅÁ¤¨¤¹¤ë¾ðÊó¤ò»È¤¨¤Ð¡Ö¤³¤Î¤ä¤êÊý¤¬È½¤é¤Ê¤¤¡×¡Ö¤³¤ÎÊýË¡¤Î¾ðÊ󤬤ʤ¤¡×¤È¤¤¤¦¤³¤È¤Ï¤Ê¤¯¤Ê¤ë¤Ï¤º¤Ç¤¹¡£
ÆÃ¤Ë
»ÔÈΤÎVBA¤Î¶µÂ§ËܤˤϽñ¤«¤ì¤Æ¤¤¤Ê¤¤ÆâÍÆ¤Ë¤Ä¤¤¤ÆÀâÌÀ¤·¤Þ¤¹¡£
»ÔÈΤΥƥ¥¹¥È¤Ë¤«¤«¤ì¤Æ¤¤¤ë¤è¤¦¤ÊVBA¤Ë´Ø¤¹¤ë´ðÁÃŪ¤Ê¤³¤È¤ÏÀâÌÀ¤·¤Æ¤¤¤Þ¤»¤ó¡£
¤³¤Î¾ðÊó¤È»ÔÈΤÎVBA¤Î¥Æ¥¥¹¥È¤¬°ìºý¤¢¤ì¤Ð¼«Æ°ÇäÇ㤬¼Â¸½¤¹¤ë¾ðÊ󤬤¹¤Ù¤Æ¤½¤í¤¦¤Ï¤º¤Ç¤¹¡£
¤³¤³¤Ç¾Ò²ð¤¹¤ëÊýË¡¤Î´°Á´¼«Æ°ÇäÇã¤Ï¥Þ¥¤¥¯¥í¥½¥Õ¥È¤Î
Excel¤Ë¤Ä¤¤¤Æ¤¯¤ëVBA¤È
³ÚÅ·¾Ú·ô¤Î¥Þ¡¼¥±¥Ã¥È¥¹¥Ô¡¼¥É¤È¥ê¥¢¥ë¥¿¥¤¥à¥¹¥×¥ì¥Ã¥É¥·¡¼¥È(RSS)¤ò»ÈÍѤ·¤Þ¤¹¡£
¤³¤³¤Ç¾Ò²ð¤¹¤ëÊýË¡¤Ç¼«Æ°ÇäÇã¤ò¼Â¸½¤¹¤ë¤Ë¤Ï
Excel¤¬¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤ë¥Ñ¥½¥³¥ó¤È
³ÚÅ·¾Ú·ô¤Î¸ýºÂ¤ò³«¤¤¤Æ¤¤¤ë¤³¤È¤¬ºÇÄã¸ÂɬÍפǤ¹¡£
¤³¤Î¾ðÊó¤Ï¡¢¥Þ¥¯¥í¤Îºî¤êÊý¤Ë¤Ä¤¤¤Æ¤Î¼ê½ç¤Î¤ò°ì¤«¤é¶µ¤¨¤ë¤â¤Î¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¤¢¤¯¤Þ¤Ç°ìÈ̤Υƥ¥¹¥È¤Ë½ñ¤¤¤Æ¤¤¤Ê¤¤´°Á´¼«Æ°ÇäÇã¼Â¸½¤Î¤¿¤á¤ËɬÍפʾðÊó¤ò¤Þ¤È¤á¤¿¤â¤Î¤Ç¤¹¡£
¥Þ¥¯¥í¤ò½ñ¤¤¤¿¤³¤È¤Ê¤¤¿Í¤Ï»ÔÈΤΥƥ¥¹¥È¤Ê¤É¤Î½õ¤±¤¬É¬¤ºÉ¬ÍפǤ¹¡£
¥×¥í¥°¥é¥à¤ò¤Þ¤Ã¤¿¤¯½ñ¤¤¤¿¤³¤È¤¬¤Ê¤¤¿Í¤Ï¡¢»ÔÈΤν鿴¼ÔÍÑVBA¤ÎËܤò¤ß¤Æ¡¢¾ò·ïʬ»Þ¤È¥ë¡¼¥×¤ò»È¤Ã¤¿¥Þ¥¯¥í¤ò½ñ¤¤¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
¤½¤Î¸å¡¢»ÔÈΤÎËܤ˽ñ¤¤¤Æ¤¢¤ëIE¤òµ¯Æ°¤µ¤»¤ë¥Þ¥¯¥í¤ò½ñ¤¤¤ÆÆ°¤«¤·¤Æ¤ß¤Æ¡¢»ä¤¬¾Ò²ð¤¹¤ë¾Ú·ô²ñ¼Ò¤Ë¥í¥°¥¤¥ó¤¹¤ëÊýË¡¤Ê¤É¤òÄɲ䷤Ƥ¤¤¯¤ä¤êÊý¤¬¤¤¤¤¤È»×¤¤¤Þ¤¹¡£
¥×¥í¥°¥é¥à¤ò¤Þ¤Ã¤¿¤¯½ñ¤¤¤¿¤³¤È¤Ê¤¤¿Í¤Ï¤È¤Ë¤«¤¯½ñ¤¤¤ÆÆ°¤«¤·¤Æ³Ð¤¨¤Æ¤¯¤À¤µ¤¤¡£
¥Æ¥¥¹¥È¤ò½ÏÆÉ¤¹¤ë¤è¤ê¤âư¤«¤·¤Æ¤ß¤ì¤Ð¡¢ÌÌÇò¤¤¤Ç¤¹¤·³Ð¤¨¤âÁᤤ¤Ç¤¹¡£
³ô¡¡´°Á´¼«Æ°ÇäÇã¡¢¥·¥¹¥Æ¥à¥È¥ì¡¼¥É¤ò VBA¤Ç¼Â¸½¤¹¤ëÊýË¡
ÆâÍÆ¤Ï°Ê²¼¤Ë¤Ê¤ê¤Þ¤¹¡£
¡¦¼«Æ°Åª¤ËIE¤ÇÆþÎÏ¥Õ¥©¡¼¥à¤ËÃͤòÆþÎϤ·¤ÆÁ÷¿®¤¹¤ëÊýË¡
¡¦ÆþÎÏ¥Õ¥©¡¼¥à¤ä¥Ü¥¿¥ó¤Î̾Á°¤¬ÆÃ¼ì¤Ê¤¿¤á¤Ë¥¢¥¯¥»¥¹½ÐÍè¤Ê¤¤»þ¤ÎÂнèÊýË¡
¡¦¥Õ¥©¡¼¥à¤Çʬ¤«¤ì¤Æ¤¤¤ë¥Û¡¼¥à¥Ú¡¼¥¸¤ËÆþÎϤ¹¤ëÊýË¡
¡¦ÆþÎÏ¥Õ¥©¡¼¥à¤ä¥Ü¥¿¥ó¤Î̾Á°¤ò¸«¤Ä¤±¤ëÊýË¡
¡¦¥¢¥¤¥Ç¥¢¡£ÌÃÊÁ¥³¡¼¥É¤Î¡É.T¡É¤ä¡É.OX¡É¤ò¼«Æ°¤Ç¼èÆÀ¤¹¤ëÊýË¡
¡¦¥¨¥é¡¼¤¬µ¯¤³¤Ã¤Æ¤â³¹Ô¤¹¤ëÊýË¡
¡¦°ìÄê»þ´Ö¥Þ¥¯¥í¤òÄä»ß¤¹¤ëÊýË¡
¡¦°ìÄê»þ´Ö¤´¤È¤Ë¥Þ¥¯¥í¤òµ¯Æ°¤¹¤ëÊýË¡
¡¦Á°¾ì¤¬½ª¤ï¤Ã¤Æ¤«¤é¡¢¸å¾ì¤¬¥¹¥¿¡¼¥È¤·¤¿»þ¤ËRSS¤ÎÃÍÆ°¤¤¬¥¹¥È¥Ã¥×¤¹¤ë¤Î¤òËɤ°ÊýË¡
¡¦·è¤Þ¤Ã¤¿»þ´Ö¤Ë¼«Æ°¤Ç¥Þ¡¼¥±¥Ã¥È¥¹¥Ô¡¼¥É¡¢RSS¡¢¥Þ¥¯¥í¤ò¥¹¥¿¡¼¥È¤¹¤ëÊýË¡
¡¦Excell¾å¤Ç»þ´Ö¤òÈæ³Ó¤¹¤ëÊýË¡
¡¦¼«Æ°¤Ç¥Ñ¥½¥³¥ó¤òºÆµ¯Æ°¤µ¤»¤ëÊýË¡
¡¦¼«Æ°¤Ç¥Ñ¥½¥³¥ó¤òµ¯Æ°¤µ¤»¤ëÊýË¡
¡¦WindowsXP¤ÎÀßÄêÃí°Õ»ö¹à
¡¦¥¢¥¤¥Ç¥¢¡£Èó¾ï»öÂ֤ΤȤ¤Ë·ÈÂÓÅÅÏäǼ«Æ°ÇäÇã¤ò¥¹¥È¥Ã¥×¤¹¤ëÊýË¡
¡¦¥¢¥¤¥Ç¥¢¡£ÌÃÊÁÁª¤Ó¤Î¼«Æ°²½
¢£¤½¤Î¾
¥µ¥ó¥×¥ë¥×¥í¥°¥é¥à¤ò¤ªÅϤ·¤·¤Þ¤¹¤¬¡¢Æ°ºîÊݾã¤Ï¤Ç¤¤Þ¤»¤ó¡£
´Ä¶¤Ë°Í¸¤·¤Æ¤¤¤ë¤Î¤Çư¤«¤Ê¤¤¤â¤Î¤È¹Í¤¨¤Æ¤ª¤¤¤Æ¤¯¤À¤µ¤¤¡£
¤¢¤¯¤Þ¤Ç
¼«Ê¬¤Çºî¤í¤¦¤È¤¹¤ë¿Í°Ê³°¤ÏÆþ»¥¤µ¤ì¤Ê¤¤¤Û¤¦¤¬¤¤¤¤¤È»×¤¤¤Þ¤¹¡£
¤´¹ØÆþ¸å¡¢»þ´Ö¤Îµö¤¹¸Â¤ê¤Ê¤é¼ÁÌäÅù¤Ë¤ªÅú¤¨¤·¤Þ¤¹¤¬¡¢¤³¤¦¤¤¤¦¥×¥í¥°¥é¥à¤òºî¤Ã¤Æ¤¯¤À¤µ¤¤¤È¤¤¤¦Í×˾¤Ë¤Ï¤ªÅú¤¨¤Ç¤¤Þ¤»¤ó¡£
¾Ü¤·¤¯¤Ï¤³¤Á¤é¤«¤é¢
¤¢¤Ê¤¿¤â¥¤¥ó¥Õ¥©¥«¡¼¥È¤Î¥¢¥Õ¥£¥ê¥¨¥¤¥È¤Ë»²²Ã¤Ç¤¤Þ¤¹¡£¢
£Ó£Ï£È£Ï¡¦µ¯¶È²È¤òÀ®¸ù¤ËƳ¤¯ÅŻҽñÀÒÈÎÇä¥Ä¡¼¥ë¤òÄó¶¡¡¦¡¦¥¤¥ó¥Õ¥©¥«¡¼¥È