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

±qWeb¨ú±o¥~³¡¸ê®Æªº¦Û°Ê§ó·s®É¶¡

±qWeb¨ú±o¥~³¡¸ê®Æªº¦Û°Ê§ó·s®É¶¡

ªí³æ¤¤³Ì§Öªº¿ï¾Ü¡A¥u¦³1¤ÀÄÁ¦Û°Ê§ó·s1¦¸¡A½Ð°Ý¦p¦ó°µ¨ì20¬í©Î§ó§Ö¦Û°Ê§ó·s1¦¸?
¦AÁÂÁ¤j¤j!

¥»©«³Ì«á¥Ñ luhpro ©ó 2010-10-11 21:43 ½s¿è

¦^´_ 1# cdkee

³o¤@½g¤º¦³§A·Q­nªºµª®× :
[µo°Ý] ½Ð°Ý¦p¦ó±N¥H³s±µEXCELªºDDE¼Æ¾Ú¨C¤ÀÄÁ¬ö¿ý¤U¨Ó¡H
¥u­n±N ®É¡B¤À ³¡¤À³£³]¦¨ "0" ,¦A½Õ¾ã¬í¼Æ¨º³¡¤Àªº¼Æ¦r´N¥i¥H¤F.
TimeSerial(Hour(Time), Minute(Time), 0) <- «á­±¨º­Ó ",0" ³æ¦ì´N¬O¬í.

¥t¥~§ó·sªº®É¶¡³æ¦ì¸û¤p®É, (¨Ò¦p¨C¼Æ¬í§ó·s¤@¦¸¤§Ãþªº)
­n½Ð¯d·N¨C¤@¶¥¬q§ó·s¸ê®Æªºµ{¦¡¬q¸¨,
¨ä°õ¦æ®É¶¡¬O§_·|¶W¹L¨C¶¥¬q§ó·s§@·~ªº°õ¦æ¬í¼Æ,
¥HÁקKµo¥Íµ{¦¡¥Ã»·°õ¦æ¤£§¹©Î¬O¨t²Î¸ê·½¤£¨¬ªº±¡§Î¥X²{.

TOP

¦^´_ 2# luhpro


    ÁÂÁ¤j¤j«ü¾É!
¦pªG¥u¬O¨C20¬í¦Û°Ê§ó·sSheet2¡AÀ³¸Ó«ç¼Ë¼g?ÁÂÁÂ!

TOP

¦^´_ 3# cdkee
  1. Sub auto_open()
  2.     For Each qy In Sheet2.QueryTables
  3.     qy.Refresh BackgroundQuery:=False
  4.     Next
  5. Application.OnTime Now + TimeValue("00:00:20"), "auto_open"
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ cdkee ©ó 2010-10-12 17:21 ½s¿è

¦^´_ 4# Hsieh


    ¦A·PÁª©¤j±Ð¾É!
½Ð±Ðqy¬O«ç¼Ë©w¸q?¬O§_«üSheet2¤¤ªºcells?ÁÂÁÂ!
ªþ¥ó¤¤ªº¨Ò¤l¡A¤£¦¨¥\¡A½Ðª©¤j«ü¥¿¡AÁÂÁÂ!
¦Û°Ê§ó·s.rar (18.56 KB)

TOP

±Nµ{¦¡½X¸m©ó¤@¯ë¼Ò²Õ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ¦¨¥\¤F!·PÁª©¤j±Ð±Â!

TOP

¦A½Ð±Ðª©¤j¡A¥u§ó·s¬Y´X­ÓCELLS(¨Ò¦p:B5¦ÜC7¤ÎD11)¡AÀ³¸Ó«ç¼Ë¼g¡AÁÂÁ±бÂ!

TOP

¥»©«³Ì«á¥Ñ cdkee ©ó 2010-10-13 19:32 ½s¿è
¦A½Ð±Ðª©¤j¡A¥u§ó·s¬Y´X­ÓCELLS(¨Ò¦p:B5¦ÜC7¤ÎD11)¡AÀ³¸Ó«ç¼Ë¼g¡AÁÂÁ±бÂ!
cdkee µoªí©ó 2010-10-12 18:51



    ¤p½úµLª¾¡A¬O§_»P§ó·s1­ÓWORKSHEET¨S¦³©úÅã®t§O?¦ý¤]·Q¾Ç²ß§ó·s¬Y´X­ÓCELLS¡AÀ³¸Ó«ç¼Ë¼g¡AÁÂÁª©¤j±Ð±Â!

TOP

§AªºÀɮרëDB5¦ÜC7¤ÎD11¤¤Àx¦s¦U§O¬d¸ß
¦P¤@¬d¸ß§Y·|¥þ³¡¤º®e§ó·s
­Y¬O§Aªº¬d¸ß¬O¦h­Ó¦s¦b©ó¤£¦PÀx¦s®æ
¨º´N¬O
For Each A In [B5:C7,D11]
A.QueryTable.Refresh
Next
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD