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

[µo°Ý] EXCEL VBAµn¤JIE²§±`¨D§U¡H

[µo°Ý] EXCEL VBAµn¤JIE²§±`¨D§U¡H

§Ú¤½¥q¦³¨â¥x¹q¸£¡A¦ý¦³¤@¥x¹q¸£·|¤@ª½¥X²{²§±`°T®§¡AµLªk¸ü¤J¸ü¡A
½Ð°Ý¬O­þ¥X¤F°ÝÃD©O¡H  
PS¡K§Úªº¹q¸£¥i¬d¸ß¡A°ß¿W¥t¤@¥x¤£¦æ¡AºN¤£µÛÀYºü¡C

²§±`»y¥y¨âºØ§¡µLªkµn¤J¡G
.Navigate "http://XXX/XXX/XXX.php" '¶i¤J¦¨«~¼ÐÅҧǸ¹ºÞ²zºô­¶
IE.Navigate "http://XXX/XXX/XXX.php" '¶i¤J¦¨«~¼ÐÅҧǸ¹ºÞ²zºô­¶

¥X²{¿ù»~°T®§¡G
°õ¦æ¶¥¬q¿ù»~'-2147024726(800700aa)
vba navigate¤èªk('iwebrowse2'ª«¥ó)¥¢±Ñ

¦^´_ 1# hayden0009


°Ñ¦Ò http://automatetheweb.net/how-to ... tml-object-library/
  1. Sub EX()
  2.     With New InternetExplorer
  3.         .Visible = True
  4.         .Navigate "http://www.twhappy.com/php.php"
  5.         Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
  6.         ''
  7.         ''
  8.     .Quit
  9.     End With
  10. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


    thank you!!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD