ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] °ïÅ|¿ù»~¡A¨S°±¯d¦b¿ù»~ªºµ{¦¡½X¡H

[µo°Ý] °ïÅ|¿ù»~¡A¨S°±¯d¦b¿ù»~ªºµ{¦¡½X¡H

°ïÅ|¿ù»~¡A¨S°±¯d¦b¿ù»~ªºµ{¦¡½X¡H¡H
§Ú¦bPrivate Sub Worksheet_Calculate()¼g¤F«Ü¦hªF¦è
¥t¥~¤]¦³¥ÎDDE§ì¬Yµ{¦¡ªº¸ê®Æ
¦b¶]®ÉVBµøµ¡¡]alt-f11)¬OÃö³¬ªº
¥¿±`¥X²{¿ù»~·|°±¯d¦b¿ù»~ªºµ{¦¡½X
¬°¦ó¥X²{°ïÅ|¿ù»~¡A¨S°±¯d¦b¿ù»~ªºµ{¦¡½X¡H§Ú¨S¿ìªkª¾¹D¨º¸Ì¿ù»~¡H¡H
°ïÅ|¿ù»~¥X²{¡A·|³y¦¨§Ú¥¿¦b°õ¦æªº Application.OnTime ¥X²{°ÝÃD
Set Ie = CreateObject("InternetExplorer.Application") ¤]¥X²{°ÝÃD
ie.quit µLªkÂ÷¶}¡AÁÙ¦b°O¾ÐÅé

¤p´£¥Ü
VBA ´X¥G³£¬O¦P¨B
Application.OnTime «h¬O·¥¨ä¤Ö¼Æ²§Ãþ¤¤ªº²§¨B
ÂI¨ì³o¸Ì

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD