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

½Ð±Ð¤j®a,ºô­¶ªº¸ê®Æ¯à§_¤£»Ý¶×¤J´Nª½±µ½Æ»s¨ìexcel¸Ì­±

½Ð±Ð¤j®a,ºô­¶ªº¸ê®Æ¯à§_¤£»Ý¶×¤J´Nª½±µ½Æ»s¨ìexcel¸Ì­±

¦U¦ì°ª¤â¤j®a¦n

³Ìªñ·Q¥Îexcel§ì´Á¥æ©Òªº¸ê®Æ,³sµ²¦p¤U

http://www.taifex.com.tw/chinese/3/3_1_1.asp

·Q½Ð°Ý¤j®a,¬O¤£¬O¦³¿ìªk¤£»Ý¶×¤J´Nª½±µ±N¸ê®Æ§ì¨ìexcel¸Ì­±©O?

¦]¬°²{¦b³£¬O¥ý±Nºô­¶¸ê®Æ¶×¤J¨ì¥Î¤£¨ìªº¤u§@ªí(sheet2)¤§«á¦A±N¸ê®Æ§ì¨ì¥t¤@­Ó¤u§@ªí(sheet1)

¤£ª¾¹D¬O§_¦³¿ìªk¸õ¹L¶×¤Jªºµ{§Ç,ª½±µ±N¸ê®Æ§ì¨ì§Ú­n¥Îªº¤u§@ªí(sheet1)¤¤´N¦n¤F©O?

ÁÂÁ¤j®a

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-6-22 15:46 ½s¿è

¤£¥Î¶×¤J¥\¯à¨º´N½Æ»s/¿ï«h©Ê¶K¤W¤å¦rªü
¨þ!·íµM³o¤£¬O§A­nªº
¥Îvba¨ú±oºô­¶ªí®æ¸ê®Æ§a!
http://chijanzen.net/VBAFILE/DHTML/J0007.htm
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂ HSIEH¤j

¥t¥~·Q½Ð±Ð¤@¤U,¦]¬°§Ú¨Ï¥ÎVBA¤j¦h³£¬O»Pºô¸ô°µ³sµ²

©Ò¥H±`±`¬Ý¨ìÃþ¦üHSIEH©Ò´£¨Ñªº³sµ²¸Ì­±©Ò¨Ï¥Îªº¤èªk

(¤Þ¥Î Microsoft HTML Object Library¡BMicrosoft Internet Controlsµ¥¤¸¥ó)

¦ý§Ú¦Û¤v§ä¤F¥«­±¤Wªº´X¥»®Ñ³£¨S¬Ý¨ìÃþ¦üªº±Ð¾Ç

©Ò¥H·Q½Ð±Ð ¦pªG·Q¾Ç²ß³o¤è­±ªº§Þ¥©(¤Þ¥Î¤£¦P¤¸¥ó)

À³¸Ó±q¤°»ò¦a¤èµÛ¤â©O?¦³±À¯òªº®ÑÄy©Îºô¯¸¶Ü?ÁÂÁÂ

TOP

¦^´_ 3# sasho


    ¥»¤H¨Ã«D¬ì¯Z¥X¨­,©Ò¦³§Þ¥©»Pª¾Ãѳ£¨Ó¦Ûºô¸ô
°ß¦³¦h¬Ý¦h°Ý¦h¾Ç²ß,¤~¬OÀò±oª¾ÃѪº³Ì¨Î¤èªk
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


   HSIEH«e½ú,¤p§Ì§Ú¦b¨Ï¥Î±z©Ò¤À¨Éªººô¯¸¤º®e®Éµo¥Í¤F°ÝÃD,ÁٽбzÀ°¦£«ü¥¿

    §Ú±Nºô¯¸¤Wªºcode¶K¨ìVBE¤¤,¨Ã±Nºô§}§ï¦¨§Ú§Æ±æ¶×¤Jªººô­¶

    ¦ý¦b°õ¦æ®É ¦b¥H¤U¦ì¸m¥X²{¤F¿ù»~
    Cells(4, rCol).Value = Tbl.Rows(RWLEN).Cells(2).innerText
   Cells(5, rCol).Value = Tbl.Rows(RWLEN).Cells(3).innerText

    ¿ù»~¤º®e¦p¤U:
  °õ¦æ¶¥¬q¿ù»~'91
  ¨S¦³³]©wª«¥óÅܼƩÎwith°Ï¶ôÅܼÆ

  ÁٽЫe½úÀ°¦£,ÁÂÁÂ!

TOP

¦^´_ 5# ¦Ñ®L


    ·PÁ¦ѮL«e½ú,±ß½ú¤~²¨¾Ç²L,©Ò¥H­­¦bÁÙ¦b±q³Ì°ò¥»ªºexcel VBAºN°_,

    µ¥­þ¤Ñ¦Ûı¥\¤O¸û²`«p¤§«á,¦A¦V«e½ú°Q±Ð§ó°ª©úªºcoding §Þ¥©

TOP

¦^´_ 6# Hsieh


    ·PÁÂHSIEH«e½ú,±ß½ú·|¥Î¤ß¦V¦U¦ì«e½ú½Ð±Ðªº...

    ¤£ª¾¹D¥i§_½ÐHSIEH«e½ú±ÀÂË´X­Ó±Ð¾Çºô¯¸©O?

    «D±`·PÁÂ

TOP

¦^´_ 5# sasho


    ¤w¸Ñ¨M,°ÝÃD¥X¦b­n¶×¤Jªºªí®æªº°ÝÃD,ÁÂÁ¤j®a!

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD