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

´ú¸ÕIP

¦^´_ 10# linderlong
  1.         RetVal = Shell("command.com /c Ping -n 1 " & ¤u§@ªí1.Cells(cts, 1) & " > " & ThisWorkbook.Path & "\iptest" & cts & ".txt")
½Æ»s¥N½X
¸g¹ê¦a¦b Excel 2010  ¤U´ú¸Õ¬OµL»~ªº¡A
½ÐÀˬd§Aªº°õ¦æ¿ù»~ÂI¬O¦b­þ¤@¬q¡H

TOP

¦^´_ 10# linderlong

TOP

À³¸Ó¤£¬Oofficeªº°ÝÃD¡A¦Ó¬O§@·~¨t²Îw7¡A32¦ì¤¸¡A¥i¥H°õ¦æ¡A¦Ó¦b64¦ì¤¸¨t²Î¡A«h¿ù¦b
RetVal = Shell("command.com /c Ping -n 1 " & ¤u§@ªí1.Cells(cts, 1) & " > " & ThisWorkbook.Path & "\iptest" & cts & ".txt")
³o¦æ«ü¥O¤W¡A¤£ª¾¬°¦ó­ì¦]¡HÁÂÁ¡I
Às

TOP

¥»©«³Ì«á¥Ñ linderlong ©ó 2013-8-30 14:43 ½s¿è

¦bw7,64¦ì¤¸,office2007¤U¡A³v¨B°õ¦æ®É¡A«h°±¦b¤U¦C«ü¥O¡A
RetVal = Shell("command.com /c Ping -n 1 " & Cells(i, 1) & " > " & ThisWorkbook.Path & "\" & i & ".txt")

«ö¤@¤U»¡©ú¡A¥X²{¥H¤U¤å¦r¡A¦ý¬Ý¤£À´¡A¤£ª¾¦p¦ó­×¥¿¡H¤£ª¾¹D¬O¤£¬O§ä¨ì command.com ³o­Ódos«ü¥O¡H

§ä¤£¨ìÀÉ®× (¿ù»~ 53)

©Ò«ü©wªºÀɮק䤣¨ì¡C¦¹¿ù»~¦³¥H¤Uªº°_¦]©M¸Ñ¨M¤èªk¡G
¡E        ³¯­z¦¡¦p Kill¡BSetAttr ©Î Name µ¥¡A¤Þ¥Î¨ì¤@­Ó¤£¦s¦bªºÀɮסC
ÀˬdÀɮצWºÙªº«÷¦r¥H¤Î¸ô®|»¡©ú¡C
¡E        ±ý©I¥s°ÊºA³sµ²µ{¦¡®w (DLL) ¤¤ªºµ{§Ç ©Î Macintoshµ{¦¡½X¸ê·½°Ï¡A¦ý§ä¤£¨ì¦b Declare ³¯­z¦¡ªº Lib ¤l¥y¤¤©Ò«ü©wµ{¦¡®wÀɮצWºÙ©Î¸ê·½·í®×¦WºÙ¡C
ÀˬdÀɮצWºÙªº«÷¦r¥H¤Î¸ô®|»¡©ú¡C
¡E        ¦bµo®iÀô¹Ò¤¤¡A¦pªG±z±ý¶}±Ò¤£¦s¦bªº±M®×©Î¸ü¤J¤£¦s¦bªº¤å¦rÀɮסA±Nµo¥Í¿ù»~¡C
ÀˬdÀɮצWºÙ©Î±M®×¦WºÙªº«÷¦r¥H¤Î¸ô®|»¡©ú¡C
¸Ô²Ó¸ê°T¡A¥i¿ï¨ú¦³ºÃ°Ýªº¶µ¥Ø¨Ã«ö¤U F1 (¦bWindows¤¤) ©Î HELP (¦bMacintosh¤W)¡C
Às

TOP

¦^´_ 14# linderlong
¸ÕµÛ¦b WinX 64 ¦ì¤¸Àô¹Ò¤U´ú¸Õ¬O§_OK¡H

TOP

¦^´_ 14# linderlong
§Aª½±µ±N Debug µe­±§¹¾ã Copy ¤W¶Ç (»Ý¦³¿ù»~ÂI«ü¦V)

TOP

¦^´_ 16# c_c_lai
¤£¦n·N«ä¡A¤½¥Î¹q¸£¡A¥Ø«e¦³¤H¨Ï¥Î¡A«SªÅÀɮɦA¤W¶Ç¡AÁÂÁ¡I
Às

TOP

¦^´_ 16# c_c_lai
¿ù»~»¡©ú¦p¤U¹Ï¡F
Às

TOP

¦^´_ 18# linderlong
RetVal  ¤W¦æ´¡¤J DoEvents ¸Õ¸Õ¬Ý¡C
  1.     DoEvents
  2.     RetVal = Shell("command.com /c Ping -n 1 " & Cells(i, 1) & " > " & ThisWorkbook.Path & "\" & i & ".txt")
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ linderlong ©ó 2013-8-30 17:00 ½s¿è

¦^´_ 19# c_c_lai
¥[¤JdoeventsÁÙ¬O¤£¦æ¡CªGµM¬O§ä¤£¨ìcommand«ü¥O¡A¤£ª¾¦³µL¨ä¥¦´À¥N¤èªk¡H¤£¦n·N«ä¡A¤U¯Z¤F¡A¤U¬P´Á¤@¤~¦³ªÅ¦A¤W¨Ó¡CÁÂÁ¡I

Às

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD