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

[µo°Ý] ¨Ï¥ÎWEB¬d¸ß§ó·s¸ê®Æ®É,¸õ¥X¨Óªº¿ù»~,

[µo°Ý] ¨Ï¥ÎWEB¬d¸ß§ó·s¸ê®Æ®É,¸õ¥X¨Óªº¿ù»~,



¦p¤W¹Ï §Ú¦b¨Ï¥ÎWEB¬d¸ß§ó·s ¦]ºô¯¸(©Î¨ä¥¦§Ú¤£ª¾¤°»ò­ì¦]) ¦³®É·|¤@ª½¸õ¥X¨Ó¦p¤W¹Ïªº°T®§ §Ú±o¤â°Ê«öenter©ÎÂI½T©w

¤£ª¾¯à¤£¯à¨Ï¥Î¡@¨Æ¥óµ{§Ç¡@©Î¨ä¥¦¤èªk¡@¦b¸õ¥X°T®§®É¡A¦Û°Ê«ö¤Uenter¡A¤£µM¥u­n§Ú¨S¥h«ö¡@§ó·s´N·|¼È°±¡Aª½¨ì§Ú±µ¤Uenter

·PÁ¡@À°¦£¤F¡@³o°ÝÃD§Ë¦n¤[³£§Ë¤£¥X¨Ó¡@¦Ó¥B¤£¬O¨C¦¸§ó·s³£¤@©w·|¥X²{°T®§¡@¦³®É§¹¥þ¨S¦³¡@¦³®ÉÓý¦h¨ì§Ú·Qª½±µÃö¤F¤£­n§ó·s¤F¡C¡C

¦^´_ 1# icestormer
½Ðªþ¤WÀɮ׬ݬÝ
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE

¹ï¤£°_ ¤£¬O¤£·Qªþ¤WÀɮצý ÀɮפӤj¤F¦³23MB,¦Ó¥B§Ú¬Q¤ÑÁÙÅý¥¦¶]¤@¦¸§ó·s ¥u­n¥¦¤@¸õ¥X°T®§ §Ú´N°O¿ý¤@¤U(ªÑ²¼ªº¥N½X)¦³3X²Õ

µ²ªG«çµÛ?  §Ú¦A¥Î¨º¨Ç¥N½X¥h§ó·s(¤â°Ê¿é¤J¥N½X¥h§ó·s) Óý¨S¦³¤@­Ó¦A¸õ¥X°T®§..¨Æ±¡´N¨º»ò©_©Ç ..

½Ð°Ý¡@ ¬¡­¶Ã¯¨Æ¥ó¡@³£¨Sªk³B²z³oºØ°ÝÃD¶Ü¡H¡H

ÃD¥~¸Ü¡G¸ò§Ú¤§«e°Ý¹L¤@­Ó°ÝÃD¬°¤°»ò§Ú¥ÎVBA¼gªº¤pµ{¦¡¶i¦æCOPY¤u§@ªí¬°¤°»ò¦Ñ¬O¨ì¤F3X­¶«á´N·|¦º·í ³o°ÝÃD§Ú¤]¨ì³B°Ý¤H §x´o¤F§Ú1 ¡A2¦~¤F..¥¿·í§Ú­n¦º¤ß¤F,¤@­ÓªB¤ÍPO¥X¤@­ÓEXCEL©x¤è(°O±o¬O)°Ýµª, ­ì¨Ó °ÝÃD¥X¦b ­nCOPYªº¤u§@ªí¸ò§Ú¥Ø«e¥´¶}ªºEXCEL¬O¦P¤@­Ó¦a¤è¡@¥u­n§â¡@­n³Q¢Ñ¢Ý¢Þ¢çªºªí¡@©ñ¥h§O¦a¤è¡@´Nºâ¢Ñ¢Ý¢Þ¢ç¨ì¤@¤d±i¤]¤£·|¦º·í¡]¥u¬O·|ºCªº¶WºC¡^

TOP

¦^´_ 3# icestormer
¦Ü¤Ö¤]­n¦³µ{¦¡½X,¤~¦n¤F¸Ñ°ÝÃD.
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2013-7-8 12:17 ½s¿è

¦^´_ 4# GBKEE



¤£¹L¡@¥Lªº§ó·s¡@¬O¦Û°Êªº¡@§Ú¥´¶}excelÀÉ¡@´N°Ý§Ú­n¤£­n§ó·s¡@¦p¤W¹Ï

¥t¥~§Ú»¡¤â°Ê§ó·s¤]¥u¬O³æ¯Â¡@¿é¤JªÑ¸¹¡@³]©w¥u­n©Ò¦b®æ¡@¼Æ¦r¡@´N¸òªÌ§ó·s¡@³o³¡¥÷¤]§¹¥þ§Ú¨S¦³¥h¼g¥ô¦ó¤@ÂIµ{¦¡½X¡@¦p¤U¹Ï


©Ò¥HÀ³¸òµ{¦¡½X¨SÃö«Y¡H¡]¦]¤£¬O¥Îµ{¦¡½X¨Ó¶]§ó·sªº¡A¬O¥Î¢å¢Ó¢Ð¬d¸ß¦Û°Ê¤U¸ü¸ê®Æ¡^¡@ÁÙ¬O§Ú²z¸Ñ¦³»~©O¡H

TOP

¦^´_ 5# icestormer
³o³¡¥÷¤]§¹¥þ§Ú¨S¦³¥h¼g¥ô¦ó¤@ÂIµ{¦¡½X


¦p¹ÏÅý¥L¤£¦b¦Û°Ê¸ß°Ý

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

TOP

¦^´_ 6# GBKEE


   Á ¦ý°ÝÃD¨Ã¤£¬O¦b¨º¸Ì, ¨º¬O¤@¶}©l¥´¶}EXCEL®É¡@°Ý§Ú­n¤£­n§ó·s¡]³o³¡¥÷¨S¦³°ÝÃD¡A§Ú¥i¥H¿ï­n©Î¤£­n¡^

°ÝÃD¬O¦b§ó·s®É¡@¥L·|¦]ºô¯¸°ÝÃD¡]¤U¤È¢²ÂI¹L«á¡@±¡ªp·|¦n«Ü¦h¡^¥X²{¡@ºô¯¸¨S¦³¦^À³¤§Ãþªº¡@¦pªG§Ú¤£¤â°Ê«ö¤U¡@¡e½T©w¡f¡A¾ã­Óµ{§Ç´N°±¦b¨º¡@«áÀY³£¤£·|§ó·s

§Ú¤]¤£¬O·Q­nÅý¥¦¤£·|¥X²{°ÝÃD¡@§Ú¥u¬O·Q­nÅý°ÝÃD¥X²{®É¡@¥Ñ¢ä¢Ð¢Ï¨Æ¥óµ{§Ç¤§Ãþªº¦Û°Ê«ö¤U½T©w´N¦æ¤F

·PÁ§Aªá®É¶¡¦^ÂЧڡã

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2013-7-17 09:30 ½s¿è

¦^´_ 7# icestormer
ÀɮפӤj¥i¥H§â¦h¾l¸ê®Æ§R°£¦A¤W¶Ç§a¡A¤£µM¦Û¤v¸Õ¸Õ¥Î Application.DisplayAlerts ¯à¤£¯à¸Ñ¨M¡C

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2013-7-17 09:38 ½s¿è

¦^´_ 8# stillfish00


Application.DisplayAlerts
¦pªG§Ú¨S¦³°O¿ù¡@³o­Ó«ü¥O¬O¥Î¦b­nÃöÀɮפ§Ãþªº·|¥ý¸ß°Ý§A¡@³]¥¦¬°¯u´N¤£­n°Ý¤F¡@¤£¬O¡H¡@¨º­Ó¤]¸òºô¯¸¨S¦³¦^À³À³¨SÃö«Y§a¡H

¦Ü©ó¡C¡CÀɮפӤj¡@¥L¤]¤£¬O¨C¦¸³£·|¥X°ÝÃD¡@¤£µM¡@¦pªG¯Â¦]ÀɮפӤj¤£¬OÀ³·|¡e¨C¦¸¡f³£·|¥X¿ù¡H
¹³³o´X¤Ñ§ó·sÓý¤@ÂI¿ù»~¤]¨S¦³¸õ¥X¨Ó©O¡C

¥t¥~¡@¨º¤£¬O¤W¶Ç©O¡A¡@¬O§Q¥Î¢å¢Ó¢Ð¬d¸ß¤U¸ü¸ê®Æ

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2013-7-17 09:55 ½s¿è

¦^´_ 9# icestormer
§Úªº·N«ä¬O¤W¶Ç§AªºÀɮרì½×¾Â¡A­Y¤Ó¤j¥i¥H¥ý§R°£¸ê®Æ¡C

­YdisplayalertsµL®Ä(¸Õ¹L¤F¶Ü)¡A
¤]¥i¥H¸Õ¸Õ¬Ý§ï¥ÎVBA¥hrefresh web query¡A¥Îon error resume next ¨Ïµo¥Íerror®É©¿²¤¥¦¬Ý¬Ý¡C
³£¸Õ¬Ý¬Ý¤~ª¾­þºØ¥i¥H¸Ñ¨M§a¡A·íµM¤]¥i¯à¸Ñ¨M¤£¤F...

DisplayAlerts¥Î¦b¦sÀɦ۰ÊÂл\¬O¤@ºØ¥Îªk¡AWeb Query §Ú¤£½T©w¦³¨S¦³®Ä¤~·|­n§A¸Õ¬Ý¬Ý¡C
  1. Application.DisplayAlerts ÄÝ©Ê
  2. ¦pªG°õ¦æ¥¨¶°®É¡AMicrosoft Excel ·|Åã¥Ü¯S©wªº´£¿ô¤Î°T®§¡A«h¥»ÄݩʭȬ° True¡C¥iŪ¼gªº Boolean¡C
  3. »yªk

  4. ¹Bºâ¦¡.DisplayAlerts

  5. ¹Bºâ¦¡   ¥Nªí Application ª«¥óªºÅܼơC

  6. ³Æµù


  7. ¹w³]­È¬° True¡C¦pªG­n¦b¥¨¶°°õ¦æ®ÉÁôÂô£¥Ü©Mĵ§i°T®§¡A´N±N¥»Äݩʳ]©w¬° False¡F·í¥X²{»Ý­n¨Ï¥ÎªÌ¦^À³ªº°T®§®É¡AMicrosoft Excel ·|¿ï¾Ü¹w³]¦^À³¡C

  8. ¦pªG±z±N¦¹Äݩʳ]©w¬° False¡A°£«D±z¥¿¦b°õ¦æ¸ó³B²z§Çµ{¦¡½X¡A§_«h Microsoft Excel ·|¦bµ{¦¡½Xµ²§ô®É±N¦¹Äݩʳ]©w¬° True¡C
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD