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

[µo°Ý] excel ÀÉ®×µLªk¦s¨ú ½Ð½T©w¤U¦C´X¥ó¨Æ¬O§_¥¿½T

[µo°Ý] excel ÀÉ®×µLªk¦s¨ú ½Ð½T©w¤U¦C´X¥ó¨Æ¬O§_¥¿½T

¦P¼ËªºexcelÀɮצb¤½¥q(¥i¦æ)¦ý¦b®a¸Ì¹q¸£«o¥X²{¥H¤U²{¶H¡C
½Ð°Ý¦³¤H¹J¹L¥H¤U°ÝÃD¶Ü?¦³¸Ñ¶Ü?

¦bExcelÀɮפº³s±µ¨ìyahooªººô­¶§@ªÑ²¼ªº»ù®æ§ó·s¡A
¥i¬O¦b§ó·s¹Lµ{¤¤¡A¦³®É·|¸õ¥X

ÀÉ®×µLªk¦s¨ú¡C½Ð½T©w¤U¦C´X¥ó¨Æ¬O§_¥¿½T:
¡E½T©w©Ò«ü©wªºÀɮק¨¬O§_¦s¦b¡C
¡E½T©wÀɮק¨¤£¬O°ßŪ¡C
¡E½T©wÀɮצWºÙ¤£¥]§t¤U¦C¦r¤¸: < > ? [ ] : ©Î *¡C
¡E½T©wÀɮפθô®|¦WºÙ¤£¶W¹L 218 ­Ó¦ì¤¸²Õ¡C
"¤£¥¿½Tªºweb¬d¸ß" ¡A

¤]´N¬O¦³¨Ç¥i¥H§ó·s¡A¦³¨Ç¤£¦æ¡A
¦Ó§Ú¤]¤£ª¾¹D­þ¨Ç¬O¨S¦³§ó·sªº¡A
³Â·Ð½Ð¦U¦ì¤j¤j«ü¾É¡AÁÂÁÂ!

¦^´_ 1# cji3cj6xu6


    ¥i¯à­ì¦]¦p¤U
     1.¸ô®|§ó°Ê
     2.¸ô®|¦WºÙ¦³¯S®í¦r(²Å¸¹)
     3.¸ô®|¦WºÙ¤Óªø

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

ÁÂÁÂmark15jill¤jªº¦^ÂСA
¦pªG»¡mark15jill¤j©Ò²qªº¬O¹ïªº¡A¨º¥i¯à¬O"¸ô®|§ó°Ê"¶ûºÃ¤ñ¸û¤j¡C

­è­è¬O¤F¤@­Ó¤èªk"²M°£¨t²Î©U§£"¡Aµo²{¤]¦³À°§U¡A¤£¹L¦n¹³¤S«Ü®e©ö¦A¦¸µo¥Í¡C
¥i¯à§Ú¬O±Ä¥Îoffice2003¤]¦³Ãö¡A§ï¤Ñ¦A¨Ó§ï¦¨2007¦n¤F¡C

ÁÂÁÂmark15jill¤j

TOP

ÁÂÁÂmark15jill¤jªº¦^ÂСA
¦pªG»¡mark15jill¤j©Ò²qªº¬O¹ïªº¡A¨º¥i¯à¬O"¸ô®|§ó°Ê"¶ûºÃ¤ñ¸û¤j¡C

­è­è¬O¤F ...
cji3cj6xu6 µoªí©ó 2013-5-1 13:16



"²M°£¨t²Î©U§£"  ³o¤èªk¶È¬° Åý¨t²Î¿W¨úºô­¶¤ñ¸û¶¶ÂI.. ¦]¬°¦³®É­Ô¨t²Î©U§£¤Ó¦h ·|³y¦¨¤@¨Ç°±¹y¤Î¨ä¥L°ÝÃD
¦Ü©ó ª©¥»°ÝÃD¡A«h·|¦³¤@©wªº¼vÅT¡A¦ý¤£¬Oµ´¹ï...
¨Ò¦p  ¦P¼Ëµ{¦¡½X  ¦P¼Ëºô¯¸ ¤£¦Pª©¥»¶]¥X¨Óªº®Ä¯à ¤£¤@©w·|¬Û¦P
²z½×¤W¨Ó»¡  ª©¥»¶V°ª  ÁôÂêºÀu¤Æµ{«×¶V¦n
©ÎªÌ¬O­×§ïµ{¦¡½X ¤]¬O¤@ºØ¤èªk

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

ÁÂÁÂmark15jill¤j¡A§A»¡ªº¨S¿ù¡A§Úµo²{¤½¥qªº¤]¬O2003¡A
¥i¬O§Ú¥u¬O§Q¥ÎIQY¥h§ì¨úyahoo ªº­ÓªÑ¸ê®Æ¡A¦ý¤£ª¾¬°¦ó·|¥X²{¸Ó¶µ°ÝÃD¡C

TOP

ÁÂÁÂmark15jill¤j¡A§A»¡ªº¨S¿ù¡A§Úµo²{¤½¥qªº¤]¬O2003¡A
¥i¬O§Ú¥u¬O§Q¥ÎIQY¥h§ì¨úyahoo ªº­ÓªÑ¸ê®Æ¡A¦ý¤£ª¾ ...
cji3cj6xu6 µoªí©ó 2013-5-2 23:06



1. »¡¦A¦h¤]¨S¥Î¡Aªþ¤WExcel ÀÉ¡A¤~¯àÀ°§A§ä¥X°ÝÃD
2. ¦pªG¬O¥ÎVBA ¤£Â_ªº QueryTable.Add¡A ¨S¦³¥Î§¹¥ß§Y¿z°£¡A¦¸¼Æ¤@¦h¤@¼Ëµo¥Í°ÝÃD¡C
diabo

TOP

·Ð½Ð¦U¦ì¤j¤jÀ°¦£¬Ý¬Ý­þ¸Ì¥X¿ùÅo¡AÁÂÁ¡C
§Q¥Îa1~a20ªºÅܤƨӦ۰ʧó·s­ÓªÑ·í¤ÑªºÅܤơC

³o¬O§Úªº¼gªk¡G¥ý¦æ©I¥srenumber
Sub renumber()

    Windows("test.xls").Activate
    Sheets("cji32").Select
    Range("b1:b20").Select
    Selection.Copy
    Range("a1").Select
    ActiveSheet.Paste
      
    Application.OnTime Now + TimeValue("00:00:5"), "renumber2"
   
    End Sub
Sub renumber2()

  
    Sheets("cji32").Select
    Range("c1:c20").Select
    Selection.Copy
    Range("a1").Select
    ActiveSheet.Paste
   
    End Sub
¦Ó iqy Àɼgªk¦p¤U¡G
WEB
1
http://tw.stock.yahoo.com/q/q?s=["¥N¸¹","¥N¸¹"]

Selection=7
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

TOP

¤j·§¸Ñ¨M¤F¡AÀ³¸Ó¬Oie¦b·d°­¡Aupdate¦¨ie8«á¦¹²{¶H¦ü¥G¤£¥X²{¤F¡C

¤§©Ò¥H»{¬°¬Oie¦b·d°­¡A¬O¦]¬°ºô¸ô·j´M¹Lµ{µo²{¦³¤H´£¨ìÃþ¦üªº²{¶H¡C

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-5-8 13:19 ½s¿è

¦^´_ 8# cji3cj6xu6
¦]¤U¸üªº³\¦hµ{¦¡¤¤»P Ie °_½Ä¬ð,§A»¡¬Oie¦b·d°­ : ¦³³o¥i¯à
¥ý«e¤@¬q®É®É¶¡§Ú¨Ï¥Îªº¬OIe8,¦bVBA¨Ï¥Î¨ìCreateObject("InternetExplorer.Application")³£·|¤£¥¿±`
­«·s¦w¸Ëie8 ¤]¤£¦æ,¥u¦n­«Äé§@·~¨t²Î,¤~¸Ñ¨M
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD