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

[µo°Ý] ³s±µºô¸ô§ì¨ú¸ê®Æ¶×¤J¤u§@ªí³t«×ºC?¦³µL¿ìªk§ïµ½?

¥»©«³Ì«á¥Ñ t8899 ©ó 2013-9-11 03:34 ½s¿è
¦^´_  t8899 ½Ð¬ÝªþÀÉ ­×§ï§Aªºµ{¦¡½X,¤u§@ªíªº¤½¦¡
GBKEE µoªí©ó 2013-9-10 15:12


Application.OnTime Time + #12:00:15 AM#, "ThisWorkbook.EX"
12:00:15 ===>­â±á12:00:15 ¶}©l§ó·s?? 15¬í§ó·s¤@¦¸??
¥i§_§ï¬° 12:00:05 ¶}©l§ó·s?15¬í§ó·s¤@¦¸? (§Y 12:00:05¡A12:00:20, 12:00:35....)

³o¨â­Ó¥¨¶°¥i§_©ñ¦b¦P¤@­Ó¬¡­¶Ã¯?(¤Ö¤@­Óexcel ,¸û¬Ù¸ê·½)

ÁôÂõøµ¡¤w§ä¨ì "HiddeX " ¸Ñ¨M (   http://dejavu.narod.ru/hiddex.html   )

TOP

¦^´_ 31# t8899
12:00:15 ===>­â±á12:00:15 ¶}©l§ó·s?? 15¬í§ó·s¤@¦¸??  ¹ïªºÃþ±À   #00:00:01#    1¬íÄÁ,    #00:01#  1¤ÀÄÁ
³o¨â­Ó¥¨¶°¥i§_©ñ¦b¦P¤@­Ó¬¡­¶Ã¯?(¤Ö¤@­Óexcel ,¸û¬Ù¸ê·½)     ¸Õ¸Õ¬Ý°Ú,DeeªºÀɮפ¤µ²¦X2­Óµ{§Ç
  1. Option Explicit
  2. Sub TwOSub()
  3.     Application.OnTime Time + #12:00:01 AM#, "twosub"
  4.     SUB_A
  5.     SUB_B
  6. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


    ½Ð¯qG¤j

Ãö©ó³o­Óª«¥ó With CreateObject("InternetExplorer.Application")

¦³¨S¦³§ó¸Ô²Ó¤@ÂIªº»¡©ú¡A¥i¥H¾Ç²ßªº©O? §Ú¦³¤W¤º«Ø¸Ñ»¡¡A¦ü¥G¹ï³o­Óª«¥ó¨S¦³°µ¸ÑÄÀ

³o­Ó¬O¤£¬OÄÝ©óActiveXªº½dÃ¥©O@@?

TOP

¦^´_ 33# handsometrowa
ºô¸ô·j´M CreateObject("InternetExplorer.Application") ¦³³\¦h¥iºCºC¤F¸Ñ
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_  handsometrowa
ºô¸ô·j´M CreateObject("InternetExplorer.Application") ¦³³\¦h¥iºCºC¤F¸Ñ
GBKEE µoªí©ó 2013-9-11 10:16



    ·PÁÂG¤jªº«ü¾É¡A
¥t¥~§Ú¦bºô¸ôª¦¤å¡Aµo²{MSDN «Ü¦hÃö©ó³o­Óª«¥óªº±Ô­z¦ü¥G¦³ÂIÃø¬d¸ß
¹ï©¤ªºªB¤Í¦³¥H¤Uªº¬ö¿ýºô­¶   

¥H¤UÂà¸ü
http://blog.csdn.net/darkread/article/details/7241098
(·PÁ¤À¨É)

§Úı±o¼gªº«Ü¸Ô²Ó¡AÁöµM¥L¤]¬O±qMSDN¤W§ì¤U¨Óªº¡A¤£¹L¹ï©ó¶}±Òºô­¶ª«¥ó¦³«Ü¸Ô²Óªº»¡©ú¡C
ª¦¤@¤U¤åÀ³¸Óª¾¹D¦Û¤v­n§ä­þ¨ÇªF¦è¡C
§Æ±æ¤j®a³£¯à¦bIEª«¥ó¤W¦h¥[±j^^

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2013-9-12 18:49 ½s¿è

¦^´_ 32# GBKEE

For Each i In Array(20, 24)
°}¦C 20 ,24===> ¦p¦óºâ¥X?

TOP

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

TOP

¦^´_  t8899
GBKEE µoªí©ó 2013-9-12 20:32

¥ÎIE ³s±µ http://udn.megatime.com.tw/asp/hot/ShortOperate.asp?lcount=20&m=puplim&align=v
«ö¥kÁä ¶×¥X¦Ü Microsoft Excel
¥X²{
Snap1.jpg
2013-9-13 15:50

TOP

¦^´_ 38# t8899
«ö½T©w«á,·Ó¹Ï¥Ü¦A°µ¤U¥h¬Ý¬Ý
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_  t8899
«ö½T©w«á,·Ó¹Ï¥Ü¦A°µ¤U¥h¬Ý¬Ý
GBKEE µoªí©ó 2013-9-13 16:16


Selection=23,24 ' ¶·´î 1 , 22,23  ½Ð¬Ý  http://forum.twbts.com/thread-10361-1-1.html

¬°¦ó­n´î1??
http://forum.twbts.com/thread-10361-1-1.html   =====>µL¦¹¥DÃD??
«ü©wªº¥DÃD¤£¦s¦b©Î¤w³Q§R°£©Î¥¿¦b³Q¼f®Ö¡A½Ðªð¦^

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD