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

[µo°Ý] ½Ð±Ð ¦p¦ó¦bEXCELL¨ú±o¸Óºô¯¸¤§"§Y®É¦ô­p²b­È"

¥»©«³Ì«á¥Ñ GBKEE ©ó 2015-7-19 10:39 ½s¿è

¦^´_ 6# lcctno
http://forum.twbts.com/thread-14577-1-1.html  ·|¬O¦P¼Ëªº°ÝÃD¶Ü
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ no3-taco ©ó 2015-7-19 11:28 ½s¿è

°Ñ¦Ò¬Ý¬Ý
±qª©¤jµ{¦¡½X¦Aµy·L­×§ïªº¦a¤è
  1. Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
  2. 'Application.SendKeys "~", True   '«ö¤U¦P·NÁä  =>¬Ù²¤¤]¥i¥H
  3. Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
  4. Wait Now + #12:00:01 AM#     =>¦n¹³¯Ê¤@­Óµ¥«Ý®É¶¡
  5. .
  6. .
  7. .
  8. .PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:=False, NoHTMLFormatting:=True
  9. .
  10. .
½Æ»s¥N½X

TOP

¦^´_ 11# GBKEE
§Úªº°ÝÃD¬O­n°µ­Ó²³æªº«ö¶s¤§EXCELLµ{¦¡ ·íÂI«ö¶s´N¯à¦Û°Ê§ó·sEXCELL¤º¤§"§Y®É¦ô­p²b­È"  À³¸Ó¬O¤£¦Pªº±¡§Î§a!  ¦ýÁÙ¬O«D±`ªº·PÁ±zªº¦^ÂÐ

TOP

¦^´_ 12# no3-taco

«D±`ªº·PÁ±zªº¦^ÂÐ ¦ý¹ïªì¦¸¨Ï¥ÎVBAªº§Ú «ÜÃø¥Ñ±z©Ò´£¨Ñªº­×§ï ¦Ó¦³¯à¤Oªº§¹¥þ²Õ¦Xª©¤j»P±zªº«Øij ¥h§¹¦¨§¹¾ãªºVBA ¥i§_«ô°U±zµ¹­Ó§¹¾ãªº»yªk ¥ýÁÂÁ±z¤F

TOP

¦^´_ 13# lcctno


   
§Úªº°ÝÃD¬O­n°µ­Ó²³æªº«ö¶s¤§EXCELLµ{¦¡ ·íÂI«ö¶s´N¯à¦Û°Ê§ó·sEXCELL¤º¤§"§Y®É¦ô­p²b­È"  À³¸Ó¬O¤£¦Pªº±¡§Î§a!

¥i¦Û¦æ¦b¤u§@ªí¤W´¡¤J¤@«ö¶s ±N"§Y®É¦ô­p²b­È"ªºµ{§Ç«ü©w¨ì³o«ö¶s

¦p¹Ï
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 11# GBKEE

§Ú«Ü«æµÛ­n¥Î¨º¥\¯à ­ì¥ý"§Y®É¦ô­p²b­È" ¤@ª½³£¨Sµo¥Í°ÝÃD ¦ý¤¸¤jÄ_¨Ó¤§ºô¯¸§ïª©¤§«á §Úªº­ì¥ý¤gªkÁå¿û¤§EXCELLÀÉ ´NµLªk§Y®Éªºª¾¹D²b­È Áٻݭn¥t¶}ºô­¶¨Ã¤â°Ê¿é¤J¼Æ­Ó¼Æ¾Ú ¹ê¦b«ÜÀY¤j  §Ú¤w¸gµo¶O«Ü¦h®É¶¡ª¦¤å¤F ¦ý¤@ª½§ä´M¤£¨ì¤èªk ©Ò¥H³Ì«á¤£±o¤£µù¥U¥[¤J·|­û¨Ãµo©«¨D±Ï §Æ±æ¯à¦³¤HÀ°§Ú.....

TOP

¦^´_ 15# GBKEE

¥Ñ©óºô¯¸ªº³W©w §Ú¨C¤p®É¥u¯à¦^ÂÐ3¦¸ ¥B¤SµLÅv­­µoµu®ø®§ «Ü©êºpÅý±z¤[µ¥§Úªº¦^ÂФF

©ó²Ä¤@®É¶¡®É §Ú¦³¨Ì±zªº»yªk§¹¦¨ ¦ýÂI¥¦¥u·|¦Û°Ê¶}±ÒIE¨Ã¨ì¨ººô¯¸ ¨Ã¤£·|¦Û°Ê§âDATA¶×¤J§ÚªºEXCELL¤º ©Ò¥H§Ú¤~·|Ä~Äò°Ý¤U¥h §Æ±æ¦³¤H¯àÀ°§U²Â²Âªº§Ú¸Ñ¨M³o­Ó°ÝÃD ¨ä¹ê§Úµo²{³°Äò¦³ºô¯¸¤wµLªk¨Ï¥Î "¶×¤J¥~³¡¸ê®Æ ·s¼WWEB¬d¸ß"  ¨Ó¨ú±oDATA ©Ò¥H§Ú¦­±ßÁÙ¬O­n­±¹ï¥¦¨Ã¾Ç·|¥¦

¥H¤U¬O§Ú¦bapk.tw©Òµoªº©« ­Y±z¹ïªÑ¥«¦³¿³½ì ¤£§«¥h¬Ý¬Ý

¸HÆp·íµM­n·Q¿ìªkÁÈ ¦ýT50¤Ï1 (00632R)ªº¯u¶r±z·QÁȶÜ?
http://apk.tw/forum.php?mod=viewthread&tid=647659&fromuid=685805
(¥X³B: Android ¥xÆW¤¤¤åºô)

00632R T50¤Ï1 ³o©«¨S¸HÆp ¦ý¦³§ÚÁȯu¶rªº²Î­p¤ÀªR
http://apk.tw/forum.php?mod=viewthread&tid=672636&fromuid=685805
(¥X³B: Android ¥xÆW¤¤¤åºô)

TOP

§A§âª©¤jªºµ{¦¡½X´¡¤J

Wait Now + #12:00:01 AM#     =>¦n¹³¯Ê¤@­Óµ¥«Ý®É¶¡

¸Õ¬Ý¬Ý

TOP

¦^´_ 9# lcctno

§A¤£¬O»¡§A°µ¤F«ö¶s¡Aºô­¶¤]¦³¶}±Ò¡A©Ò¥HÀ³¸Ó¬Oµ{¦¡½X¨S¦³§ì¨ì¡Aµ¹¥L©µ¿ð¤@¬í¬Ý¬Ý

Wait Now + #12:00:01 AM#     '=>¦n¹³¯Ê¤@­Óµ¥«Ý®É¶¡

TOP

§Ú¸Õ¹L¤F¡A¯à¥´¶}ºô­¶¡A¥¹¥N½X  .document.body.innerHTML = E.outerHTML
³o¦æ´£¥Ü¥X¿ù¡C

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD