ExcelVBA¥²¡¼¥à¥×¥í¥°¥é¥ß¥ó¥°¡©

½é¿´¼Ô¤Ç¤â¤­¤Ã¤È¤Ç¤­¤ë¡ª
£Å£ø£ã£å£ì¤µ¤¨»ý¤Ã¤Æ¤¤¤ì¤ÐÆÃÊ̤ʥ½¥Õ¥È¤ÏÉÔÍסª
¤¹¤°¤Ë¤Ç¤â»Ï¤á¤é¤ì¤ë´Êñ¥²¡¼¥à¥×¥í¥°¥é¥ß¥ó¥°¡ª
º£¤¹¤°»Ï¤á¤è¤¦¡ª

¥µ¥ó¥×¥ë¤ä¥²¡¼¥à¤Î¥À¥¦¥ó¥í¡¼¥É¤¬¤Ç¤­¤ëÊ̴ۤ⹥ɾ±¿±ÄÃæ¤Ç¤¹¡£
¤´°Õ¸«¤ä¤´¼ÁÌä¡¢¥²¡¼¥à¤Î´¶ÁÛÅù¤Ï·Ç¼¨ÈĤޤǤªµ¤·Ú¤Ë¡£À§Èó¡¢³§¤µ¤ó¤ÎÀ¼¤òʹ¤«¤»¤Æ¤¯¤À¤µ¤¤¡£±¿±Ä¡¢³«È¯¤ÎÎå¤ß¤Ë¤Ê¤ê¤Þ¤¹¡£



³Æ¼ï¥À¥¦¥ó¥í¡¼¥É¤Ï¥³¥Á¥é ¢­ °Õ¸«¡¦´¶ÁÛ¡¦¼ÁÌä¤Ï¥³¥Á¥é ¢­
±ÆÁÒ¸Ë Shadow warehouse ¥µ¥Ý¡¼¥È·Ç¼¨ÈÄ
¥Ö¥í¥°¤ÎÁ´ÂÎÁü¤Ï¥³¥Á¥é ¢­ ¥ê¥ó¥¯¤Î¥Ú¡¼¥¸¤Ï¥³¥Á¥é ¢­
¥µ¥¤¥È¥Þ¥Ã¥× ¼«Ê¬Ë̤ܰʥê¥ó¥¯


£Ã£è£á£ð£ô£å£ò.£³£³ [ Ʊ´ü½èÍý¤Î³µÇ° ]

¢£Æ±´ü½èÍý¤È¤Ï²¿¤«¡©

´ðÁùֺ£³¤Ç¤Ï¡¢¡ØWith¥¹¥Æ¡¼¥È¥á¥ó¥È¡Ù¤Ë»Ï¤Þ¤ê¡¢¡Ø²èÁüɽ¼¨¤Ë´Ø¤¹¤ë½èÍý¡Ù¡¢¡Ø·«¤êÊÖ¤·½èÍý¡Ù¡¢¡ØAPI¤Ë¤Ä¤¤¤Æ¡Ù¤È¡¢²òÀ⤷¤Æ¤­¤Þ¤·¤¿¤Í¡£
¤½¤·¤ÆÁ°²ó¤Î¥Æ¡¼¥Þ¤À¤Ã¤¿¡Ø¥á¥¤¥ó¥ë¡¼¥×¡Ù¡£¤³¤ì¤ÏÁ°²ó¡¢´°À®ÅÙ£¹£°¡ó¤È¤¤¤¦ÃæÅÓȾü¤Ê¾õÂ֤ǽª¤ï¤Ã¤Æ¤·¤Þ¤Ã¤Æ¤¤¤Þ¤¹¡£

Ĺ¡¹¤È´ðËܤˤĤ¤¤Æ²òÀ⤷¤Æ¤­¤¿¤Î¤Ë¤Ï¤Á¤ã¤ó¤ÈÍýͳ¤¬¤¢¤ê¤Þ¤¹¡£º£²ó¤Î¥Æ¡¼¥Þ¤Ç¤¢¤ë¡ØÆ±´ü½èÍý¡Ù¤òÍý²ò¤¹¤ë¤¿¤á¤Ë¡¢¤É¤¦¤·¤Æ¤â¤³¤ì¤é¤Î²òÀ⤬ɬÍפÀ¤Ã¤¿¤«¤é¤Ç¤¹¡£¤³¤³¤Þ¤Ç¡¢²æËý¶¯¤¯¿Ê¤á¤Æ¤­¤¿³§¤µ¤ó¡¢ËÜÅö¤Ë¤¬¤ó¤Ð¤Ã¤Æ¤¤¤ë¤È»×¤¤¤Þ¤¹¡£
³§¤µ¤ó¤Ï¤â¤¦½½Ê¬¤Ê´ðÁÃÎϤ¬¤Ä¤¤¤Æ¤¤¤Þ¤¹¡£º£²ó¤Î¹ÖºÂ¤â¤­¤Ã¤È¤Ä¤¤¤Æ¤³¤ì¤ë¤Ï¤º¤Ç¤¹¡£¤â¤¦¾¯¤·¤À¤±¡¢´ðËܤËÃé¼Â¤Ë¤¬¤ó¤Ð¤ê¤Þ¤·¤ç¤¦¡£

¤µ¤Æ¡¢º£²ó¤Î¥Æ¡¼¥Þ¡ØÆ±´ü½èÍý¡Ù¤Ç¤¹¤¬¡¢³§¤µ¤ó¤Ï¤Ê¤ó¤Î¤³¤È¤À¤«¤ï¤«¤ë¤Ç¤·¤ç¤¦¤«¡£

¥²¡¼¥à¤Î¥×¥í¥°¥é¥ß¥ó¥°¤ò¹Ô¤¦¤Ë¤¢¤¿¤Ã¤Æ¡¢Æ±´ü½èÍý¤È¤¤¤¦¤Î¤Ï¼Â¤Ï¤¹¤´¤¯½ÅÍפʽèÍý¤Ç¤¹¡£¤³¤ì¤ò¤·¤Ã¤«¤ê¤È¼ÂÁõ¤·¤Æ¤¤¤Ê¤¤¥²¡¼¥à¤Ï¡¢²¼¼ê¤ò¤¹¤ë¤È¥²¡¼¥à¤È¤·¤ÆÀ®¤êΩ¤¿¤Ê¤¤¤Û¤É¡¢¤Ò¤É¤¤¤â¤Î¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤³¤ì¤Ï¥¢¥¯¥·¥ç¥ó¥²¡¼¥à¤ä¡¢¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Ê¤É¡¢Æ°¤­¤Î·ã¤·¤¤¥²¡¼¥à¤Ç¤¢¤ì¤Ð¤¢¤ë¤Û¤É¸²Ãø¤Ëɽ¤ì¤Þ¤¹¡£

Ʊ´ü½èÍý¤È¤¤¤¦¤Î¤Ï¡¢¤É¤Î¤è¤¦¤Ê¥Ñ¥½¥³¥ó´Ä¶­¤Ç¤â¤Ç¤­¤ë¸Â¤êƱ¤¸¤è¤¦¤Ë½èÍý¤¬¹Ô¤ï¤ì¤ë¤è¤¦¤Ë¡¢¥²¡¼¥à¤Îư¤­¤òÄ´À°¤¹¤ë½èÍý¤Î¤³¤È¤Ç¤¹¡£
¤Á¤ç¤Ã¤È¤ï¤«¤ê¤Å¤é¤¤¤Ç¤¹¤Í¡£²òÀ⤷¤Þ¤¹¡£

Î㤨¤Ð¡¢À¤³¦ºÇ¶¯¤Î½èÍýǽÎϤò»ý¤Ä¡¢¥¹¡¼¥Ñ¡¼¥³¥ó¥Ô¥å¡¼¥¿¡¼¤¬¤¢¤Ã¤¿¤È¤·¤Þ¤¹¡£Excel¤ò£±£°£°¸ÄƱ»þ¤Ëµ¯Æ°¤·¤Æ¤â¤Ø¤Ã¤Á¤ã¤é¤Ê¤Û¤É¡¢¹â¤¤¥Ý¥Æ¥ó¥·¥ã¥ë¤ò¸Ø¤ê¤Þ¤¹¡£
°ìÊý¡¢¤½¤ÎÎ٤ˤϡ¢£±£°Ç¯¤Û¤ÉÁ°¤ËÀ½ºî¤µ¤ì¤¿¤Á¤ç¤Ã¤È¸Å¤¤¥Þ¥·¥ó¤¬¤¢¤ê¤Þ¤¹¡£¥³¥¤¥Ä¤Ï¤Á¤ç¤Ã¤È½Å¤¿¤¤¥½¥Õ¥È¤òµ¯Æ°¤·¤¿¤é¡¢¥Õ¥ê¡¼¥º¤·¤¿¤«¤È»×¤ï¤º´ª°ã¤¤¤·¤Æ¤·¤Þ¤¦¤Û¤É¡¢Ä㤤¥¹¥Ú¥Ã¥¯¤Î¥Þ¥·¥ó¤Ç¤¹¡£

ÅöÁ³¤Ç¤¹¤¬¡¢¤³¤Î£²¤Ä¤Î¥Þ¥·¥ó¤¬Æ±¤¸½èÍý¤ò¹Ô¤¦¾ì¹ç¡¢´°Î»¤¹¤ë¤Þ¤Ç¤Î»þ´Ö¤Ë¤Ïº¹¤¬½Ð¤Þ¤¹¡£´Êñ¤Ê½èÍý¤Ç¤¢¤ì¤Ð¡¢¸«¤¿ÌܤˤϤۤȤó¤É°ã¤¤¤¬¤Ê¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£¤·¤«¤·¿ôÀé²ó¡¢¿ôËü²ó¥ë¡¼¥×¤¹¤ë½èÍý¤Ê¤É¡¢Èó¾ï¤Ë½Å¤¿¤¤½èÍý¤ò¹Ô¤¦¾ì¹ç¤Ë¤Ï¡¢¤½¤ì¤Ê¤ê¤ËÂ礭¤Ê»þ´Ö¤Îº¹¤¬½Ð¤Æ¤¯¤ë¤Ç¤·¤ç¤¦¡£
¹Í¤¨¤Æ¤ß¤ë¤È¡¢¤³¤ì¤ÏÈó¾ï¤Ë¤ä¤Ã¤«¤¤¤Ç¤¹¡£

¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Î¾ì¹ç¡¢¥×¥ì¥¤¥ä¡¼¤¬Áàºî¤¹¤ë¼«µ¡¤äŨ¥­¥ã¥é¥¯¥¿¡¼¤Îư¤¯Â®¤µ¤Ï¤â¤Á¤í¤ó¡¢Å¨¤¬·â¤Ã¤Æ¤¯¤ëÅ¨ÃÆ¤Î®¤µ¡¢¤³¤ì¤¬¥Ñ¥½¥³¥ó¤ÎÀ­Ç½¤Ë¤è¤Ã¤ÆÊѤï¤Ã¤Æ¤·¤Þ¤¦¤È¤¤¤¦¤³¤È¤Ç¤¹¡£
¤«¤¿¤ä¡¢Ä¶¹â®¤Ç½±¤¤Íè¤ë¶²ÉݤÎÃÆËë¡£¤«¤¿¤ä¡¢¥²¡¼¥à¤Ë½¸Ãæ¤Ç¤­¤Ê¤¤¤Û¤É¤ÎĶÄãÂ®ÃÆ¡Ä¡Ä¡£¤³¤ì¤¸¤ã¤¤¤±¤Þ¤»¤ó¤Í¡£

¤³¤ì¤Ï¶Ëü¤ÊÎã¤Ç¤¹¤¬¡¢¤½¤ó¤Ê¤Ë¸½¼ÂÎ¥¤ì¤·¤¿ÏäǤ⤢¤ê¤Þ¤»¤ó¡£
¥Ñ¥½¥³¥ó¤Ê¤É¤Îµ¡´ï¤Ï¿Ê²½¤¬Èó¾ï¤ËÁᤤ¤Ç¤¹¤«¤é¡¢£²¡Á£³Ç¯Á°¤Î¥Ñ¥½¥³¥ó¤Ç¤â¡¢·ë¹½½èÍýǽÎϤ䥹¥Ú¥Ã¥¯¤Ëº¹¤¬¤¢¤ë¤â¤Î¤Ç¤¹¡£

»ä¤¿¤Á¤¬ºî¤Ã¤¿¥²¡¼¥à¤Ï¡¢¤É¤Î¤è¤¦¤Ê´Ä¶­¤Ç¥×¥ì¥¤¤µ¤ì¤ë¤«¤ï¤«¤ê¤Þ¤»¤ó¡£´Ä¶­¤Ë¤è¤Ã¤Æ¥²¡¼¥à¤Î½èÍý®ÅÙ¡¢¤Ä¤Þ¤êÆñ°×ÅÙ¤¬ÊѲ½¤¹¤ë¤³¤È¤¬¤¢¤ë¤Î¤Ï¹¥¤Þ¤·¤¯¤¢¤ê¤Þ¤»¤ó¡£»ä¤¿¤Á¥×¥í¥°¥é¥Þ¡¼¤¬¡¢Æ°ºî´Ä¶­¤Î°ã¤¤¤Ë¤è¤Ã¤Æ½èÍý¤¬ÊѲ½¤·¤Ê¤¤¤è¤¦¤Ë¡¢°Õ¿ÞŪ¤ËÄ´À°¤·¤Ê¤¯¤Æ¤Ï¤Ê¤é¤Ê¤¤¤Î¤Ç¤¹¡£
¤³¤ì¤³¤½¤¬¡ØÆ±´ü½èÍý¡Ù¤Ê¤Î¤Ç¤¹¡£


¢£¤Ç¤Ï¤É¤Î¤è¤¦¤Ë¼ÂÁõ¤µ¤»¤ë¤«

¤µ¤¡¡¢ÌäÂê¤Ï¤³¤ì¤Ç¤¹¡£¤¤¤«¤Ë¤·¤ÆÆ±´ü½èÍý¤ò¼Â¸½¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤·¤ç¤¦¤«¡£

¥Ý¥¤¥ó¥È¤È¤Ê¤ë¤Î¤Ï¡¢¥Ñ¥½¥³¥ó¤Î½èÍý®ÅÙ¤¬Â®¤¯¤Æ¤â¡¢ÃÙ¤¯¤Æ¤â¡¢Æ±¤¸¤è¤¦¤Ë½èÍý¤¬¿Ê¤à¤è¤¦¤Ë¤¹¤ë¤³¤È¤Ç¤¹¤è¤Í¡£¤³¤ì¤Ï¥«¥á¤È¥¦¥µ¥®¤ËÎ㤨¤Æ¹Í¤¨¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¥«¥á¤µ¤ó¤Ï¡¢¤È¤Ã¤Æ¤â¤æ¤Ã¤¯¤ê¤Ç¤¹¡£¤½¤ì¤ËÂФ·¤Æ¡¢¥¦¥µ¥®¤µ¤ó¤ÏÈó¾ï¤Ë®¤¤¡£
Ʊ»þ¤ËÁö¤ê½Ð¤·¤¿¤é¡¢¤¢¤Ã¤È¤¤¤¦´Ö¤Ë¥¦¥µ¥®¤µ¤ó¤¬Àè¤Ë¿Ê¤ó¤Ç¤·¤Þ¤¤¡¢¥«¥á¤µ¤ó¤ÏÃÖ¤¤¤Æ¤¤¤«¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤·¤«¤·¡¢¥¦¥µ¥®¤µ¤ó¤¬ÅÓÃæ¤ÇµÙ¤ó¤Ç¤·¤Þ¤Ã¤¿¤¬°Ù¤Ë¡¢¤æ¤Ã¤¯¤ê¥«¥á¤µ¤ó¤Ï¡¢·ë¶É¥¦¥µ¥®¤µ¤ó¤ËÄɤ¤¤Ä¤¯¤³¤È¤¬¤Ç¤­¤Þ¤·¤¿¡£


¤É¤¦¤Ç¤¹¤«¡¢¤Ê¤ó¤È¤Ê¤¯Æ±´ü½èÍý¤ÎÊýË¡¤¬ÁÛÁü¤Ç¤­¤Þ¤»¤ó¤«¡©

¸°¤ò°®¤Ã¤Æ¤¤¤ë¤Î¤Ï¡¢¡ØÂ®¤¹¤®¤¿¤È¤­¤Ë¤Ï½èÍý¤ò»ß¤á¤ÆÂԤġ٤Ȥ¤¤¦»ÅÁȤߤǤ¹¡£
½èÍý¤¬¹Ô¤ï¤ì¤Æ¤¤¤ëºÇÃæ¡¢¤¢¤ë°ìÄê¤Î»þÅÀ¤Ç®ÅÙ¤ò¥Á¥§¥Ã¥¯¤ò¤·¤Æ¡¢Â®¤¯¿Ê¤ß¤¹¤®¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢½èÍý¤¬»ß¤Þ¤ë¤è¤¦¤Ë¤¹¤ì¤Ð¤¤¤¤¤ï¤±¤Ç¤¹¡£

¤É¤¦¤Ç¤¹¤«¡©¡¡¤Ê¤ó¤È¤Ê¤¯¹Í¤¨Êý¤Ï¤ï¤«¤Ã¤¿¤Ç¤·¤ç¤¦¤«¡£
¤³¤Î¹Í¤¨Êý¤ò¼è¤êÆþ¤ì¤Ê¤¬¤é¡¢Á°²ó²òÀ⤷¤¿¥á¥¤¥ó¥ë¡¼¥×¤ËƱ´ü½èÍý¤òÁȤ߹þ¤ó¤Ç¤ß¤Þ¤·¤ç¤¦¡£Æ±´ü½èÍý¤¬ÁȤ߹þ¤á¤¿¤é¡¢À²¤ì¤Æ¥á¥¤¥ó¥ë¡¼¥×´°À®ÅÙ£±£°£°¡ó¤ËÅþã¤Ç¤¹¡£


¢£Æ±´ü½èÍý¤ËɬÍפÊAPI

Ʊ´ü½èÍý¤ò¹Ô¤¦¤¿¤á¤Ë¤Ï¡¢Sleep´Ø¿ô¤Ë³¤¯¡¢¿·¤¿¤ÊAPI¤ò¤Ò¤È¤Ä¾Ò²ð¤·¤Ê¤¯¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£
¤½¤ÎAPI¤Ï¡ØGetTickCount¡Ù¤È¤¤¤¦API´Ø¿ô¤Ç¤¹¡£
Àë¸Àʸ¤Ï°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

Declare Function GetTickCount lib "kernel32.dll" () As Long

¤³¤ÎGetTickCount´Ø¿ô¤Ï¡¢¥¦¥£¥ó¥É¥¦¥º¤¬µ¯Æ°¤µ¤ì¤Æ¤«¤é¡¢¤É¤Î¤¯¤é¤¤»þ´Ö¤¬·Ð¤Ã¤Æ¤¤¤ë¤Î¤«¤ò¶µ¤¨¤Æ¤¯¤ì¤ëµ¡Ç½¤ò»ý¤Ã¤Æ¤¤¤Þ¤¹¡£¤½¤Î»þ´Ö¤Îñ°Ì¤Ï¡¢Sleep´Ø¿ô¤ÈƱÍÍ¡¢¥ß¥êÉÃñ°Ì¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£

¤³¤ÎGetTickCount´Ø¿ô¤ò¤¦¤Þ¤¯¼è¤êÆþ¤ì¤ë¤³¤È¤Ë¤è¤Ã¤Æ¡¢Æ±´ü½èÍý¤¬¼Â¸½¤Ç¤­¤Þ¤¹¡£

¤Þ¤º¡¢Àë¸Àʸ¤ò¤è¤¯¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£
Sleep´Ø¿ô¤Î¤È¤­¤ÈƱÍÍ¡¢Declare¥¹¥Æ¡¼¥È¥á¥ó¥È¤ò»È¤Ã¤Æ¤¤¤Þ¤¹¤Í¡£¤³¤ì¤Ï¤É¤ó¤ÊAPI¤ò»È¤¦¤È¤­¤Ç¤âɬ¤ºÆ±¤¸¤Ç¤¹¡£¤½¤·¤ÆÃíÌܤ¹¤Ù¤­¤Ï³ç¸Ì¤ÎÉôʬ¤Ç¤¹¡£
Sleep´Ø¿ô¤Ï¡¢½èÍý¤òÃæÃǤ¹¤ë»þ´Ö¤ò¡¢À°¿ô¤Î¥Ç¡¼¥¿¤È¤·¤Æ°ú¿ô¤Ë»ØÄꤷ¤Æ¤¤¤Þ¤·¤¿¡£¤·¤«¤·¡¢GetTickCount´Ø¿ô¤Î³ç¸Ì¤ÎÃæ¤Ë¤Ï¡¢²¿¤â½ñ¤«¤ì¤Æ¤¤¤Þ¤»¤ó¤Í¡£¶õ¤Î³ç¸Ì¤¬¤Ä¤¤¤Æ¤¤¤ë¤À¤±¤Ç¤¹¡£
¤³¤Î¤³¤È¤«¤é¡¢GetTickCount´Ø¿ô¤Ï°ú¿ô¤òɬÍפȤ·¤Ê¤¤¤È¤¤¤¦¤³¤È¤¬¤ï¤«¤ê¤Þ¤¹¡£GetTickCount´Ø¿ô¤Ï¾ðÊó¤ò¼èÆÀ¤¹¤ë¤È¤¤¤¦ÌÜŪ¤Î¤¿¤á¤À¤±¤Î´Ø¿ô¤È¤¤¤¦¤³¤È¤Ç¤¹¤Í¡£

¼ÂºÝ¤Ë¡¢¤³¤Î´Ø¿ô¤Ï´Êñ¤Ë¥Æ¥¹¥È¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£¤¿¤á¤·¤Ë¡¢²¼µ­¤Î¥³¡¼¥É¤ò¼Â¹Ô¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£¤¹¤ë¤È¡¢²¿¤é¤«¤Î¿ôÃͤ¬¥á¥Ã¥»¡¼¥¸¤È¤·¤ÆÉ½¼¨¤µ¤ì¤ë¤Ï¤º¤Ç¤¹¡£

Declare Function GetTickCount Lib "kernel32.dll" () As Long

Sub Get_Time_Test()
    MsgBox GetTickCount
End Sub

¤Ê¤ó¤À¤«°ÛÍͤËÂ礭¤Ê¿ôÃͤ¬É½¼¨¤µ¤ì¤¿¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£¤³¤Î¿ôÃͤ¬¡¢¥ß¥êÉÃñ°Ì¤Çɽ¤·¤¿¡¢µ¯Æ°¤·¤Æ¤«¤é¸½ºß¤Þ¤Ç¤Î»þ´Ö¤Ê¤ó¤Ç¤¹¤Í¡£
Î㤨¤Ð¡Ø600000¡Ù¤Èɽ¼¨¤µ¤ì¤¿¾ì¹ç¤Ë¤Ï¡¢¤É¤ì¤¯¤é¤¤¤Î»þ´Ö¤¬·Ð¤Ã¤Æ¤¤¤ë¤«¤È¤¤¤¦¤È¡Ä¡Ä

£±É䬣±£°£°£°¥ß¥êÉäʤΤǡ¢
    600000 ¡à 1000 ¡á 600 ¡á £¶£°£°ÉÃ
£±Ê¬¤Ï£¶£°ÉäʤΤǡ¢
    600 ¡à 60 ¡á 10 ¡á £±£°Ê¬

¤½¤¦¡¢£±£°Ê¬·Ð¤Ã¤Æ¤¤¤ë¤Î¤Ç¤¹¡£
¤³¤Î¤è¤¦¤Ë¡¢GetTickCount´Ø¿ô¤Ï¡¢¥¦¥£¥ó¥É¥¦¥º¤òµ¯Æ°¤·¤Æ¤«¤é¸½ºß¤Þ¤Ç¤Î»þ´Ö¤ò¶µ¤¨¤Æ¤¯¤ì¤Þ¤¹¡£¤³¤Î»ÅÁȤߤò»È¤Ã¤Æ¡¢¥²¡¼¥à¤ÎƱ´ü½èÍý¤ò¹Ô¤¤¤Þ¤¹¡£


¢£´°À®ÅÙ£±£°£°¡ó¥á¥¤¥ó¥ë¡¼¥×

¥á¥¤¥ó¥ë¡¼¥×¤ËƱ´ü½èÍý¤òÁȤ߹þ¤à¤¿¤á¤Ë¡¢GetTickCount´Ø¿ô¤ò»È¤¤¤Þ¤¹¤¬¡¢¤½¤ì¤ÈƱ»þ¤Ë¡¢Long·¿¤ÎÊÑ¿ô¤ò¿·¤·¤¯Àë¸À¤·¤Þ¤¹¡£

¥²¡¼¥à¤Î·«¤êÊÖ¤·½èÍý¤¬¹Ô¤ï¤ì¤ë¤È¤­¡¢¤Þ¤º»Ï¤á¤Ë¡¢¤³¤Î¿·¤·¤¯Àë¸À¤·¤¿Long·¿¤ÎÊÑ¿ô¤ËGetTickCount´Ø¿ô¤¬¶µ¤¨¤Æ¤¯¤ì¤ë¿ôÃͤòÆþ¤ì¤Æ¤ª¤­¤Þ¤¹¡£
¤³¤¦¤¹¤ë¤³¤È¤Ç¡¢¤½¤Î¤È¤­¤Î¥ë¡¼¥×¤¬¤¤¤Ä»Ï¤Þ¤Ã¤¿¤Î¤«¡¢¤¢¤È¤ÇÃΤ뤳¤È¤¬¤Ç¤­¤Þ¤¹¤è¤Í¡£¥¦¥£¥ó¥É¥¦¥º¤òµ¯Æ°¤·¤Æ¤«¤é¡¢¤Á¤ç¤¦¤É£±£°Ê¬·Ð¤Ã¤Æ¤¤¤¿¤È¤·¤¿¤é¡¢¤³¤Î¤È¤­ÊÑ¿ô¤Ë¤Ï¡Ø600000¡Ù¤È¤¤¤¦¿ôÃͤ¬Æþ¤ë¤Ï¤º¤Ç¤¹¡£

¤½¤·¤Æ¡¢¥²¡¼¥à¤Î½èÍý¤¬Á´¤Æ½ª¤ï¤Ã¤Æ¡¢·«¤êÊÖ¤·½èÍý¤ÎºÇ¸å¤ÎÉôʬ¤Ëº¹¤·³Ý¤«¤Ã¤¿Ãʳ¬¤Ç¡¢¤â¤¦°ìÅÙGetTickCount´Ø¿ô¤ò¸Æ¤Ó½Ð¤·¤Þ¤¹¡£¤¹¤ë¤È¡¢¥²¡¼¥à¤Î½èÍý¤Ë¤«¤«¤Ã¤¿Ê¬¤À¤±¡¢»þ´Ö¤¬¿Ê¤ó¤Ç¤¤¤ë¤Ï¤º¤Ç¤¹¤è¤Í¡£Àè¤Û¤ÉÊÑ¿ô¤ËÆþ¤ì¤Æ¤ª¤¤¤¿¿ôÃͤÈÈæ³Ó¤¹¤ì¤Ð¡¢¤É¤Î¤¯¤é¤¤»þ´Ö¤¬³Ý¤«¤Ã¤¿¤Î¤«¤¬¤ï¤«¤ë¤Ï¤º¤Ç¤¹¡£
Î㤨¤ÐºÇ¸å¤Ë¤â¤¦°ìÅÙGetTickCount´Ø¿ô¤ò¸Æ¤Ó½Ð¤·¤¿»þ¤Ë¡¢¶µ¤¨¤Æ¤¯¤ì¤ë¿ôÃͤ¬¡Ø600500¡Ù¤Ë¤Ê¤Ã¤Æ¤¤¤¿¤È¤·¤¿¤é¡¢ÊÑ¿ô¤ËÆþ¤Ã¤Æ¤¤¤ë¿ôÃͤÈÈæ³Ó¤¹¤ë¤È¡Ø500¥ß¥êÉá٤Ĥޤꡢ£°.£µÉûþ´Ö¤¬·Ð¤Ã¤Æ¤¤¤ë¤È¤¤¤¦¤³¤È¤¬¤ï¤«¤ê¤Þ¤¹¡£

¤â¤·¡¢£±²ó¤Î¥ë¡¼¥×¤ò£±ÉÃñ°Ì¤Ç²ó¤·¤¿¤¤¤È¹Í¤¨¤Æ¤¤¤¿¾ì¹ç¤Ë¤Ï¡¢¤³¤ì¤Ç¤Ï½èÍý¤¬Â®¤¯½ª¤ï¤ê¤¹¤®¤Æ¤·¤Þ¤Ã¤Æ¤¤¤Þ¤¹¡£¤Ä¤Þ¤ê¥¦¥µ¥®¤µ¤ó¾õÂ֤Ǥ¹¤Í¡£
¤³¤ó¤Ê¤È¤­¤Ï¡¢¥¦¥µ¥®¤µ¤ó¤Ë¤Ï¾¯¤·ÂԤäƤâ¤é¤¤¤Þ¤·¤ç¤¦¡£¤½¤Î¤¿¤á¤Ë¡¢¤â¤¦¤Ò¤È¤ÄDo¡ÁLoop¤òÍѰդ·¤Æ¡¢¤½¤ÎÃæ¤Ç¤°¤ë¤°¤ë²ó¤Ã¤Æ¤â¤é¤¤¤Þ¤¹¡£

¤Ê¤«¤Ê¤«¥¤¥á¡¼¥¸¤·¤Å¤é¤¤¤È»×¤¤¤Þ¤¹¤Î¤Ç¡¢´°À®ÈǤΥᥤ¥ó¥ë¡¼¥×¤Î¥³¡¼¥É¤òºÜ¤»¤Á¤ã¤¤¤Þ¤¹¡£¤³¤ì¤ò¸«¤Ê¤¬¤é¡¢¤â¤¦¾¯¤·Æ§¤ß¹þ¤ó¤Ç¹Í¤¨¤Æ¤ß¤Þ¤·¤ç¤¦¡£¥³¡¼¥É¤Ï¼¡¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

Sub Main()
    Dim Flg As Boolean
    Dim Stm As Long                 'Long·¿¤ÎÊÑ¿ô¤ò¿·¤¿¤ËÀë¸À
    Flg = False
    Do Until Flg
        Stm = GetTickCount             '»Ï¤á¤Ë»þ´Ö¤ò¼èÆÀ¤·¤Æ¤ª¤¯
        '¥²¡¼¥à¤Î½èÍý
        Do
            Call Sleep(1)
        Loop Until GetTickCount - Stm > 1000     'Èæ³Ó¤ò¹Ô¤Ã¤ÆÂ®¤¹¤®¤¿¤é¥ë¡¼¥×¤¹¤ë
    Loop
End Sub

¤ï¤«¤ê¤ä¤¹¤¯¤¹¤ë¤¿¤á¤Ë¡¢¥³¥á¥ó¥È¤òÊ»¤»¤ÆÄɲ䷤Ƥߤޤ·¤¿¡£
¾¯¤·¥³¡¼¥É¤¬Ê£»¨¤Ê¤Î¤Ç¡¢¤Á¤ç¤Ã¤È¤ï¤«¤ê¤Å¤é¤¤¤Ç¤¹¤¬¡¢¤è¤¯¸«¤Æ¤¯¤À¤µ¤¤¡£

£²ÈÖÌܤËÅо줹¤ë¡¢Ãæ¤ËÆþ¤Ã¤Æ¤¤¤ë¤Û¤¦¤ÎDo¡ÁLoopʸ¤Ç¡¢½èÍý¤¬Â®¤¹¤®¤Æ¤¤¤Ê¤¤¤«¥Á¥§¥Ã¥¯¤·¤Æ¤¤¤Þ¤¹¡£GetTickCount´Ø¿ô¤Ç¼èÆÀ¤Ç¤­¤ë¿ôÃͤ«¤é¡¢»Ï¤á¤ËÊÑ¿ô¤Ë³ÎÊݤ·¤¿¿ôÃͤò°ú¤­»»¤·¤Þ¤¹¡£Àè¤Û¤É¤ÎÎã¤Ç¸À¤¨¤Ð¡ØGetTickCount´Ø¿ô¤Ç¼èÆÀ¤¹¤ë¿ôÃÍ - 600000¡Ù¤È¤¤¤¦·×»»¤ò¤·¤Æ¤¤¤ë¤Î¤Ç¤¹¤Í¡£
¤³¤Î·×»»¤Î·ë²Ì¤¬¡¢¡Ø1000¤è¤ê¤âÂ礭¤¯¤Ê¤Ã¤¿¤È¤­¡Ù¤È¤¤¤¦¤Î¤¬½ªÎ»¤Î¾ò·ï¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£¤Ç¤¹¤«¤é¡¢¤â¤·½èÍý¤¬Â®¤¹¤®¤ë¾ì¹ç(·×»»·ë²Ì¤¬1000¤è¤ê¾®¤µ¤¤¾ì¹ç)¤Ï¥ë¡¼¥×¤·Â³¤±¤ë¤ï¤±¤Ç¤¹¡£

¥²¡¼¥à¤Î½èÍý¤Ë£µ£°£°¥ß¥êÉä·¤«³Ý¤«¤é¤Ê¤«¤Ã¤¿¤È¤·¤¿¤é¡¢°ú¤­»»¤·¤¿·ë²Ì¤¬£±£°£°£°¤è¤ê¤â¾®¤µ¤¯¤Ê¤ê¤Þ¤¹¡£¤³¤ó¤Ê¥¦¥µ¥®¤µ¤ó¤Ë¤ÏDo¡ÁLoop¤È¤¤¤¦Ý£¤ÎÃæ¤Ç¡¢Å¬Àڤʻþ´Ö¤¬Íè¤ë¤Þ¤Ç±ä¡¹¤È²ó¤Ã¤Æ¤â¤é¤¤¤Þ¤¹¡£
¤³¤¦¤¹¤ë¤³¤È¤Ë¤è¤Ã¤Æ¡¢¥²¡¼¥à¤Î¥á¥¤¥ó¥ë¡¼¥×¤Ï¡¢Ç¤°Õ¤Î»þ´Ö¤Ç£±²ó¤º¤Ä½èÍý¤¬¹Ô¤ï¤ì¤ë¤è¤¦¤Ë¤Ê¤ë¤ï¤±¤Ç¤¹¡£¥¦¥µ¥®¤µ¤ó¤¬¤°¤ë¤°¤ë²ó¤Ã¤Æ¤¤¤ë´Ö¤Ë¡¢ÌµÂ̤ÊÉé²Ù¤¬³Ý¤«¤é¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¤¿¤á¤Ë¡¢Sleep´Ø¿ô¤òÃæ¤Ë¤¢¤ëDo¡ÁLoopʸ¤Ë»Å¹þ¤à¤È¤¤¤¦¤Î¤¬¥Ý¥¤¥ó¥È¤Ç¤¹¤Í¡£


¢£¤Þ¤È¤á

¤µ¤Æ¡¢·ë¹½Æñ¤·¤¤ÆâÍÆ¤Ç¤·¤¿¤Í¡£¤É¤¦¤Ç¤·¤ç¤¦¡¢»ä¤ÎÀâÌÀ¤¬ÉÔ­¤Ç¤Ê¤¤¤«¿´ÇۤǤ¹¤¬¡¢¤³¤ì¤Ë¤Æ¤á¤Ç¤¿¤¯¥á¥¤¥ó¥ë¡¼¥×¤Î´°À®ÅÙ¤¬£±£°£°¡ó¤ËÅþ㤷¤Þ¤·¤¿¡£

¤³¤Î¥á¥¤¥ó¥ë¡¼¥×¤Ï¡¢º£¸å¿÷·Á¤È¤·¤Æ»È¤¤¤Þ¤¹¡£¤½¤Î¹½Â¤¤Ë¤Ä¤¤¤ÆÀµ¤·¤¤Íý²ò¤¬É¬ÍפǤ¹¡£Î㤨¤Ð£±²ó¤Î¥ë¡¼¥×»þ´Ö¤ò¡¢£±ÉÃñ°Ì¤Ç¤Ï¤Ê¤¯¡¢¤â¤Ã¤Èû¤¤»þ´Ö¤Ç»ØÄꤷ¤¿¤¤¾ì¹ç¤Ï¤É¤¦¤¹¤ì¤Ð¤¤¤¤¤«¡¢³§¤µ¤ó¤Ï¤ï¤«¤ê¤Þ¤¹¤«¡©¡¡¥­¥Á¥ó¤ÈÆâÍÆ¤¬Íý²ò¤Ç¤­¤Æ¤¤¤ì¤Ð¡¢¤³¤ì¤Ï´Êñ¤Ê¤Ï¤º¤Ç¤¹¡£

£²ÈÖÌܤÎDo¡ÁLoopʸ¤Ç»ØÄꤵ¤ì¤Æ¤¤¤ë½ªÎ»¾ò·ï¡¢¡ØLoop Until GetTickCount - Stm > 1000¡Ù¤Î»þ´Ö¤òÊѹ¹¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤¹¤Í¡£
Àè¤Û¤É¤ÎÎã¤Î¾ì¹ç¤Ç¤Ï¡¢·×»»·ë²Ì¤È¤ÎÈæ³Ó¤È¤·¤Æ£±£°£°£°¤ò»ØÄꤷ¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤Ï£±£°£°£°¥ß¥êÉ䴤ȡ¢¤È¤¤¤¦¤³¤È¤Ç¤¹¤«¤é¤¹¤Ê¤ï¤Á£±É䴤ȤËÁêÅö¤·¤Þ¤¹¤Í¡£¤â¤·¡¢¤â¤Ã¤È®¤¯¥ë¡¼¥×¤ò²ó¤·¤¿¤¤¾ì¹ç¤Ë¤Ï¡¢¤³¤Î£±£°£°£°¤ÎÉôʬ¤ò¤â¤Ã¤È¾®¤µ¤Ê¿ôÃͤˤ¹¤ì¤Ð¤¤¤¤¤À¤±¤Ç¤¹¡£
¤³¤³¤Ç£µ£°£°¤ò»ØÄꤹ¤ì¤Ð£°.£µÉ䴤Ȥ˥롼¥×¤·¤Þ¤¹¤·¡¢£±£°£°¤ò»ØÄꤹ¤ì¤Ð£°.£±É䴤Ȥ˥롼¥×¤·¤Þ¤¹¡£Íý¶þ¤¬¤ï¤«¤Ã¤Æ¤·¤Þ¤¨¤Ð´Êñ¤Ç¤¹¤Í¡£

º£²ó²òÀ⤷¤¿¡ØÆ±´ü½èÍý¤¬¥­¥Á¥ó¤È¼è¤ì¤Æ¤¤¤ë¥á¥¤¥ó¥ë¡¼¥×¡Ù¤Ï¡¢Æ°¤­¤Î¤¢¤ë¥²¡¼¥à¤òºî¤ëºÝ¤Ë¤Ï¾ï¤ËɬÍפˤʤë»ÅÁȤߤǤ¹¡£»ä¤¬ºîÀ®¤¹¤ë¥²¡¼¥à¤â¡¢¤³¤Î»ÅÁȤߤòºÎÍѤ·¤Æ¤¤¤ë¤â¤Î¤¬¤Û¤È¤ó¤É¤Ç¤¹¡£
¤Û¤Ü´°À®¤µ¤ì¤¿·Á¤Ç¤¹¤«¤é¡¢Àè¤Û¤É¤â½ñ¤¤¤¿¤è¤¦¤Ë¡¢º£¸å¡¢¤³¤Î¥á¥¤¥ó¥ë¡¼¥×¤ò¿÷·Á¤È¤·¤Æ²òÀâ¤ò³¤±¤Æ¤¤¤¯¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£Æñ¤·¤¤ÆâÍÆ¤Ç¤Ï¤¢¤ê¤Þ¤¹¤¬¡¢¤·¤Ã¤«¤ê³Ð¤¨¤Æ¡¢¼¡²ó°Ê¹ß¤ËÈ÷¤¨¤Æ¤¯¤À¤µ¤¤¤Í¡£


¢£³Ê¸À

Ʊ´ü½èÍý¤Ç¤É¤ó¤Ê´Ä¶­¤Ë¤âÂбþ¤µ¤»¤ë
GetTickCount´Ø¿ô¤Ï¥¦¥£¥ó¥É¥¦¥ºµ¯Æ°¤«¤é¤Î»þ´Ö¤ò¥ß¥êÉÃñ°Ì¤Ç¶µ¤¨¤Æ¤¯¤ì¤ë


·«¤êÊÖ¤·½èÍý¡ÜƱ´ü½èÍý¡ÜSleep¡¢¤³¤ì¤Ç´°àú¥á¥¤¥ó¥ë¡¼¥×¡£





Comment

Name
E-mail
URL
Comment
Pass  *
Secret¡© ¡Ê´ÉÍý¼Ô¤Ë¤À¤±É½¼¨¡Ë

¥×¥í¥°¥é¥ß¥ó¥°´ØÏ¢¸¡º÷



¥×¥í¥°¥é¥ß¥ó¥°¤ä ExcelVBA ¤Ë´ØÏ¢¤·¤¿¸¡º÷¤Ë¤Ï¤³¤Á¤é¤ò¤É¤¦¤¾¡£

¥á¡¼¥ë¥Õ¥©¡¼¥à

±Æ»Â¤Ëʪ¿½¤¹¤È¤¤¤¦Êý¤Ï¤³¤Á¤é

̾Á°¡¡:
¥á¡¼¥ë:
·ï̾¡¡:
ËÜʸ¡¡:

²Äǽ¤Ê¸Â¤êÍ×˾¤Ë¤Ï±þ¤¨¤Þ¤¹¤¬¡¢É¬¤ºÊÖ¿®¤ä²óÅú¤¬¤Ç¤­¤ë¤³¤È¤ò¡¢Êݾ㤹¤ë¤â¤Î¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¤´Î»¾µ¤¯¤À¤µ¤¤¡£

£Ã£è£á£ð£ô£å£ò£ó

¥³¥ó¥Æ¥ó¥Ä°ìÍ÷


¢£Chapter °ìÍ÷¢£
    Á´¤Æ¤ÎChapter¤Î°ìÍ÷¤Ç¤¹¡£
    Ä¾ÀÜ¥¢¥¯¥»¥¹¤·¤¿¤¤Êý¤Ï¤³¤Á¤é¤ò¤´ÍøÍѲ¼¤µ¤¤¡£

    £Ã£è£á£ð£ô£å£ò.£± [ ÃΤäƤª¤¯¤Ù¤­¿´ÆÀ ]
    £Ã£è£á£ð£ô£å£ò.£² [ £Å£ø£ã£å£ì¤Ã¤Æ¤Ê¤ó¤À¤í¤¦ ]
    £Ã£è£á£ð£ô£å£ò.£³ [ £Å£ø£ã£å£ì¤Î´ðËܲèÌÌ ]
    £Ã£è£á£ð£ô£å£ò.£´ [ £Ö£Â£Á¤È¤Ï¡© ]
    £Ã£è£á£ð£ô£å£ò.£µ [ ¥â¥¸¥å¡¼¥ë¤Ë¤Ä¤¤¤Æ ]
    £Ã£è£á£ð£ô£å£ò.£¶ [ ÊÑ¿ô ]
    £Ã£è£á£ð£ô£å£ò.£· [ ÊÑ¿ô¤Î·¿¤ÈÀë¸À ]
    £Ã£è£á£ð£ô£å£ò.£¸ [ ¥×¥í¥·¡¼¥¸¥ã¤È¥¹¥³¡¼¥× ]
    £Ã£è£á£ð£ô£å£ò.£¹ [ ¥²¡¼¥à¤Ä¤¯¤ëÍÍ¡¹¤Ê¼êË¡ ]
    £Ã£è£á£ð£ô£å£ò.£±£° [ ¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à ]
    £Ã£è£á£ð£ô£å£ò.£±£± [ ¥×¥í¥Ñ¥Æ¥£¥¦¥£¥ó¥É¥¦ ]
    £Ã£è£á£ð£ô£å£ò.£±£² [ Íð¿ô ]
    £Ã£è£á£ð£ô£å£ò.£±£³ [ ¾ò·ïʬ´ô ]
    £Ã£è£á£ð£ô£å£ò.£±£´ [ ¥²¡¼¥à²èÌ̤Υǥ¶¥¤¥ó ]
    £Ã£è£á£ð£ô£å£ò.£±£µ [ ¥³¡¼¥Éµ­½Ò¤Î´ðËܺîË¡ ]
    £Ã£è£á£ð£ô£å£ò.£±£¶ [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£± ̾Á°¤ò¤Ä¤±¤ë ]
    £Ã£è£á£ð£ô£å£ò.£±£· [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£² ¥Õ¥©¡¼¥à¤Îµ¯Æ° ]
    £Ã£è£á£ð£ô£å£ò.£±£¸ [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£³ Íð¿ô¤Î¼ï ]
    £Ã£è£á£ð£ô£å£ò.£±£¹ [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£´ ¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£²£° [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£µ °ú¿ô ]
    £Ã£è£á£ð£ô£å£ò.£²£± [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£¶ ÌòȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£²£² [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£· ͽ¬¤ÈÀ©¸Â ]
    £Ã£è£á£ð£ô£å£ò.£²£³ [ With¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£²£´ [ ²èÁü¤òɽ¼¨¤µ¤»¤ë ]
    £Ã£è£á£ð£ô£å£ò.£²£µ [ ²èÁüɽ¼¨¤ÎȯŸ·Á ]
    £Ã£è£á£ð£ô£å£ò.£²£¶ [ ·«¤êÊÖ¤·½èÍý Forʸ ]
    £Ã£è£á£ð£ô£å£ò.£²£· [ ·«¤êÊÖ¤·½èÍý Do¡ÁLoopʸ ]
    £Ã£è£á£ð£ô£å£ò.£²£¸ [ Exit¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£²£¹ [ ¥Õ¥©¡¼¥à¾å¤Î°ÌÃÖ¾ðÊó ]
    £Ã£è£á£ð£ô£å£ò.£³£° [ API´ðÁÃÃμ± ]
    £Ã£è£á£ð£ô£å£ò.£³£± [ APIÊä­Ãμ± ]
    £Ã£è£á£ð£ô£å£ò.£³£² [ ¥á¥¤¥ó¥ë¡¼¥×¤ò¹Í¤¨¤ë ]
    £Ã£è£á£ð£ô£å£ò.£³£³ [ Ʊ´ü½èÍý¤Î³µÇ° ]
    £Ã£è£á£ð£ô£å£ò.£³£´ [ °Üư½èÍý¤½¤Î£±¡§²èÌÌÀßÄê¤È¹Í¤¨Êý ]
    £Ã£è£á£ð£ô£å£ò.£³£µ [ °Üư½èÍý¤½¤Î£²¡§DoEvents ]
    £Ã£è£á£ð£ô£å£ò.£³£¶ [ °Üư½èÍý¤½¤Î£³¡§¥­¡¼ÆþÎÏȽÄêAPI ]
    £Ã£è£á£ð£ô£å£ò.£³£· [ ¾ò·ïʬ´ô¤Î¤µ¤é¤Ê¤ëõµá Select Case ]
    £Ã£è£á£ð£ô£å£ò.£³£¸ [ ¥¢¥Ë¥á¡¼¥·¥ç¥ó ]
    £Ã£è£á£ð£ô£å£ò.£³£¹ [ ÇÛÎóÊÑ¿ô ]
    £Ã£è£á£ð£ô£å£ò.£´£° [ ¥²¡¼¥à¤Î½é´ü²½ ]
    £Ã£è£á£ð£ô£å£ò.£´£± [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±¡§¥²¡¼¥àÀß·× ]
    £Ã£è£á£ð£ô£å£ò.£´£² [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£²¡§¥á¥¤¥ó¥×¥í¥»¥¹ ]
    £Ã£è£á£ð£ô£å£ò.£´£³ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£³¡§¹½Â¤ÂÎ ]
    £Ã£è£á£ð£ô£å£ò.£´£´ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£´¡§Äê¿ô ]
    £Ã£è£á£ð£ô£å£ò.£´£µ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£µ¡§¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼ ]
    £Ã£è£á£ð£ô£å£ò.£´£¶ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£¶¡§¥·¥ç¥Ã¥È¤ò·â¤Ä­¡ ]
    £Ã£è£á£ð£ô£å£ò.£´£· [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£·¡§¥·¥ç¥Ã¥È¤ò·â¤Ä­¢ ]
    £Ã£è£á£ð£ô£å£ò.£´£¸ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£¸¡§Mod±é»»»Ò¤Î³èÍÑ ]
    £Ã£è£á£ð£ô£å£ò.£´£¹ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£¹¡§Å¨¥­¥ã¥é¥¯¥¿¡¼Åоì ]
    £Ã£è£á£ð£ô£å£ò.£µ£° [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£°¡§¾×ÆÍȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£µ£± [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£±¡§¾×ÆÍ¤Î¼ÂÂÎ ]
    £Ã£è£á£ð£ô£å£ò.£µ£² [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£²¡§Å¨¤Î¹¶·â ]
    £Ã£è£á£ð£ô£å£ò.£µ£³ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£³¡§Çúȯ¥¨¥Õ¥§¥¯¥È ]
    £Ã£è£á£ð£ô£å£ò.£µ£´ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£´¡§»Äµ¡¿ôɽ¼¨­¡ ]
    £Ã£è£á£ð£ô£å£ò.£µ£µ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£µ¡§»Äµ¡¿ôɽ¼¨­¢ ]
    £Ã£è£á£ð£ô£å£ò.£µ£¶ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¶¡§¥¹¥³¥¢¤Îɽ¼¨ ]
    £Ã£è£á£ð£ô£å£ò.£µ£· [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£·¡§¥¿¥¤¥È¥ë²èÌÌ ]
    £Ã£è£á£ð£ô£å£ò.£µ£¸ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¸¡§¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼ ]
    £Ã£è£á£ð£ô£å£ò.£µ£¹ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¹¡§ºÇ¸å¤Î»Å¾å¤²¤Ø ]
    £Ã£è£á£ð£ô£å£ò.£¶£° [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£²£°¡§¤¤¤è¤¤¤è´°À®STG ]
    £Ã£è£á£ð£ô£å£ò.£¶£± [ ¥«¡¼¥É¥²¡¼¥à¤Ç»È¤¨¤ë¤á¤¯¤ê¸ú²Ì ]
    £Ã£è£á£ð£ô£å£ò.£¶£² [ ¥é¥¸¥¢¥ó¤È³ÑÅÙ ]
    £Ã£è£á£ð£ô£å£ò.£¶£³ [ ¥é¥¸¥¢¥ó¤Î³èÍÑ¡§±ß±¿Æ° ]
    £Ã£è£á£ð£ô£å£ò.£¶£´ [ ¥é¥¸¥¢¥ó¤Î³èÍÑ¡§Ç¤°Õ¤Î³ÑÅÙ¤Ø°ÜÆ°¤¹¤ë ]
    £Ã£è£á£ð£ô£å£ò.£¶£µ [ API¤Ë¤è¤ë¥µ¥¦¥ó¥ÉºÆÀ¸¡§´ðÁà ]
    £Ã£è£á£ð£ô£å£ò.£¶£¶ [ API¤Ë¤è¤ë¥µ¥¦¥ó¥ÉºÆÀ¸¡§MIDI¤È¿½ÅºÆÀ¸ ]
    £Ã£è£á£ð£ô£å£ò.£¶£· [ API¤Ë¤è¤ë¥µ¥¦¥ó¥ÉºÆÀ¸¡§MCI¥³¥Þ¥ó¥É¤È¥ë¡¼¥×ºÆÀ¸ ]
    £Ã£è£á£ð£ô£å£ò.£¶£¸ [ Function ¥×¥í¥·¡¼¥¸¥ã ]
    £Ã£è£á£ð£ô£å£ò.£¶£¹ [ ÃÍÅϤ·¤È»²¾ÈÅϤ· ]
    £Ã£è£á£ð£ô£å£ò.£·£° [ ¥Ç¥Ð¥Ã¥°£±¡§¥¤¥ß¥Ç¥£¥¨¥¤¥È¥¦¥£¥ó¥É¥¦ ]
    £Ã£è£á£ð£ô£å£ò.£·£± [ ¥Ç¥Ð¥Ã¥°£²¡§¥í¡¼¥«¥ë¥¦¥£¥ó¥É¥¦ ]
    £Ã£è£á£ð£ô£å£ò.£·£² [ ¥Ç¥Ð¥Ã¥°£³¡§¥³¡¼¥É¼Â¹Ô¤ÎÃæÃÇ ]
    £Ã£è£á£ð£ô£å£ò.£·£³ [ ¥ª¥Ö¥¸¥§¥¯¥È¤Ã¤Æ¤Ê¤ó¤À ]
    £Ã£è£á£ð£ô£å£ò.£·£´ [ ¥×¥í¥Ñ¥Æ¥£¡¦¥á¥½¥Ã¥É¡¦¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£·£µ [ ¥ª¥Ö¥¸¥§¥¯¥ÈÊÑ¿ô ]
    £Ã£è£á£ð£ô£å£ò.£·£¶ [ ¥ª¥Ö¥¸¥§¥¯¥È¤È¥³¥ì¥¯¥·¥ç¥ó ]
    £Ã£è£á£ð£ô£å£ò.£·£· [ ÆÃ¼ì¤Ê·«¤êÊÖ¤·¡§For Each ]
    £Ã£è£á£ð£ô£å£ò.£·£¸ [ ¥¨¥é¡¼½èÍý ]
    £Ã£è£á£ð£ô£å£ò.£·£¹ [ On Error ¤È GoToʸ ]
    £Ã£è£á£ð£ô£å£ò.£¸£° [ Resume¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£± [ ¥Ð¥¤¥È¤È¥Ó¥Ã¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£² [ ¥¦¥£¥ó¥É¥¦¥á¥Ã¥»¡¼¥¸¤È¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£³ [ ʸ»úÎó¤Î´ðÁà ]
    £Ã£è£á£ð£ô£å£ò.£¸£´ [ ʸ»úÎóÁàºî­¡ ]
    £Ã£è£á£ð£ô£å£ò.£¸£µ [ ʸ»úÎóÁàºî­¢ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¶ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£±¡§»ÅÍͤò·è¤á¤ë ]
    £Ã£è£á£ð£ô£å£ò.£¸£· [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£²¡§¥­¡¼ÆþÎϸ¡ÃÎ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¸ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£³¡§Ê¸»úÎó¾È¹ç ]
    £Ã£è£á£ð£ô£å£ò.£¸£¹ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£´¡§È½Äê´Ø¿ô ]


    ¥³¡¼¥É¤äVBA¤Ë´Ø¤¹¤ë¼ÁÌä¤Ê¤É¤Ï¥µ¥Ý¡¼¥È·Ç¼¨ÈÄ¡ÊÊ̴ۡˤޤǤªµ¤·Ú¤Ë¤É¤¦¤¾¡£




fc2 seotool Excel VBA ¥²¡¼¥à ¥×¥í¥°¥é¥ß¥ó¥° ¹ÖºÂ

By FC2¥Ö¥í¥°

º£¤¹¤°¥Ö¥í¥°¤òºî¤í¤¦¡ª

Powered By FC2¥Ö¥í¥°

Counter

DigitalClock

¥×¥í¥Õ¥£¡¼¥ë

Author:
±Æ»Â
£Å£ø£ã£å£ì¤ò¤³¤è¤Ê¤¯°¦¤¹¤ë¤Ò¤È¡£
£²¡Á£³Ç¯¤Û¤ÉÁ°¤«¤é¡¢£Å£ø£ã£å£ì£Ö£Â£Á¤Ë¤è¤ë¥²¡¼¥à¥×¥í¥°¥é¥ß¥ó¥°¤ËÌܳФá¤ë¡£
ÆÀ°Õ¤Ê³«È¯Ê¬Ìî¤Ï¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à(¼«¾Î)¡£

IT¥Ö¥í¥°¥é¥ó¥­¥ó¥°

IT´ØÏ¢¤Î¥Ö¥í¥°ÀìÍÑ¥é¥ó¥­¥ó¥°¤Ç¤¹¡£ Îɤ«¤Ã¤¿¤é¤ò¥¯¥ê¥Ã¥¯¤ª´ê¤¤¤·¤Þ¤¹¡£

edita


edita.jp¡Ú¥¨¥Ç¥£¥¿¡Û


From Omoituki