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

½Ð°Ý³o­Óºô­¶¦p¦ó¥ÎWEB¬d¸ß¿é¤Jexcel

¦^´_ 68# GBKEE
«¢«¢¡I
¤Ó²M²n¤F¤]¤£¦æ¡I (¥u¯à²Ä¤@­Ó "ªÅ¥Õºô­¶")

TOP

¦^´_ 71# c_c_lai
2­ÓIE³£¤£Åã¥Ü,2003¦A¶]¤@¦¸,OK!
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 72# GBKEE
©Ò¥H»¡¹À¡A³o´N¬O§Ú¤§©Ò¥H¨ØªA Micrsoft ªº¦a¤è¡I
¤£±o¤£ªA®ð¡C

TOP

¦^´_ 72# GBKEE
¤£«H¨¸¦A¸Õ¤@¦¸ (Marked «á¥ýÀx¦s¤@¦¸¡A¦A¦æ°õ¦æ)¡C
¨Æ«á¥u¥X²{¹L¤@¦¸"Åv­­°ÝÃD"«á¡A¤@¤Á¤SÂk©ó¥­ÀR (¥¿±`¤F)¡C
³o«K¬O§Ú¨ØªA Microsoft ªº½t¬G¡C

TOP

¦^´_ 72# GBKEE
  1.     Set ie = CreateObject("InternetExplorer.Application")
  2.     ie.Navigate "about:Tabs"
  3.     '  ie.Visible = True
  4.    
  5.     Set shts = ActiveSheet    '  Sheets("¤u§@ªí2")
  6.     shts.Cells.Clear
  7.    
  8.     URL = "http://www.cnyes.com/twstock/Institutional/1101.htm"
  9.     With CreateObject("InternetExplorer.Application")
  10.         '  .Visible = True     '  ¬O§_Åã¥Ü IE
  11.         .Navigate URL
  12.         
½Æ»s¥N½X

TOP

·s¤â ­è¥[¤J ¾Ç²ß¤F
ÁÂÁ¤j¤j­Ì ^^

TOP

¿n¤ÀÁÙ¤£°÷><"
¥i¤U¸ü"¬d§ä¼ÐÅÒ.zip" ªº¤j¤j,¥i§_¶Çµ¹¤p§Ì!

E-mail: [email protected]
·P¿E¤£·q~

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD