Àx¦s¤£·|¦Û°Ê°±¤î¡A¸Ó«ç»ò§ï¡H
- ©«¤l
- 48
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-4-9
- ³Ì«áµn¿ý
- 2019-12-17
|
¦^´_ 17# stillfish00
TO stillfish00¤j¤j
¦pªG§Ú½Æ»sBB¤u§@ªí¡A§ï¦W¬°CC ¤u§@ªí¡A¸Ì±ªºµ{¦¡³£©MBB¤u§@ªí¤@¼Ë¡A¥u¬O§ïÓ¦W¡A´«Ó®É¶¡(§ï¬°1¤p®É°O¿ý¤@¦¸)
¦pªG§ï®É¶¡¬O10¤ÀÄÁ©Î¬O20¤ÀÄÁ°O¿ý¤@¦¸®É¡A¤@¤Á³£«Ü¶¶§Q¡C
¦ýY§ï¬°¤@Ó¤p®É°O¿ý¤@¦¸®É
¦p¡G
Sub SetTimer3(sSheetName As String)
Const MAX_ROW = 270 '³Ì¦h270
If mainFunc3(sSheetName) < MAX_ROW And Not gbStop3 Then Application.OnTime Now + TimeValue("01:00:00"), "'SetTimer3 """ & sSheetName & """'"
End Sub
¥¦°£¤F°O¿ý¤@Ó¤p®Éªº¼ÆÈ¥~¡AÁÙ·|°O¿ý§Oªº®É¶¡ªº¡C
¦p¡G 12¡G00¡G21 «ö¤U¶}©l¡A¬°²Ä¤@µ§ªº°O¿ý
12¡G09¡G02 ¬°²Ä¤Gµ§ªº°O¿ý
13¡G00 ¡G21 ¬°²Ä¤Tµ§ªº°O¿ý
13¡G09¡G02 ¬°²Ä¥|µ§ªº°O¿ý
½Ð°Ý¬°¤°»ò·|³o¼Ë©O¡H§Ú»Ýnªº¬O¤@Ó¤p®É¤@µ§¸ê®Æ´N¦n¡C
§Ú¸Õ¹LY¬Oµu®É¶¡ªº°O¿ý¡A´N¤£·|¦³³o¼Ëªº±¡§Î¡C
¯àª¾¹D¬O¤°»òì¦]³y¦¨ªº¶Ü¡H
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 48
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-4-9
- ³Ì«áµn¿ý
- 2019-12-17
|
¦^´_ 17# stillfish00
ÁÂÁ§Aªº¦^ÂСA§Ú«·s¥ÎF8¤@Ó¤@Ó¹ï¡A¦b«ö¤U¶}©l¨º¤@Àþ¶¡¡AF3 & G3 ¥X²{ªº¼ÆȬO#DIV/0!¡A¦ý´N¨º¤@Àþ¶¡¡A°¨¤W´N¦³¼ÆÈ¥X¨Ó¤F¡C
§Ú·Q¡AÀ³¸Ó¬O¨º¤@Àþ¶¡³Q°O¿ý¤U¨Ó¡A©Ò¥HL3 & M3 ¤~·|°O¿ý#DIV/0!¡C
§Ú¦A·Q¬Ý¬Ý¸Ó«ç»ò³B²z¤~¦n¡C
ÁÂÁ§Aªº¦^ÂСC |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 16# ahsiek
§Ú«Ü½T©wF3 & G3ªº®æ¤l³£¬O¦³¼ÆȪº¡A¦ÓL4 & M4¬O½Æ»sF3& G3ªº¼ÆÈ¡A¬°¤°»òÁÙ·|¥X²{#DIV/0!©O¡H
§Ú¤]ı±o¤£·|¦³³o±¡§Î¡A§A¬O¦p¦ó½T©w"·í¤U"ªºF3 & G3ªº®æ¤l³£¬O¦³¼ÆȪº?- Y¯uªº¬O¦]¬°F3&G3ªº¤½¦¡¡A¦Ó¾ÉPL4&M4¥X²{#DIV/0!ªº¸Ü¡A¦³¤°»ò¤èªk¥i¥HÅýL4&M4³æ¯ÂÀx¦s¼ÆÈ´N¦n©O¡H
½Æ»s¥N½X ¤Ï¹L¨Ó°Ý¡AYF3&G3´N¬O#DIV/0!¡A§AnL4&M4Àx¦s¤°»ò¼ÆÈ? |
|
|
|
|
|
|
- ©«¤l
- 48
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-4-9
- ³Ì«áµn¿ý
- 2019-12-17
|
¦^´_ 14# stillfish00
Stillfish00 ¤j¤j¡A§Ú¤S¦³Ó°ÝÃD·Q½Ð±Ð§A¡C
¦pªþ¤WªºÀÉ®×CC¤u§@ªí
¼ÆÈ°O¿ý.rar (313.9 KB)
CC¤u§@ªí¬OBB¤u§@ªíªº©µ¦ù¡A½Æ»sªº®æ¼Æ¦h¤F¤TÓ¡CB3-G3ªº¼ÆȽƻs¨ìH4-M4ªº®æ¤l¸Ì¡A¥H¦¹Ãþ±À¡C
§Ú¤]·Ó¤èªk§ï¦n¤FCC¤u§@ªí¡C
¦ý¬O¡A¶}©l°Ê§@«á¡AL4 ©MM4ªºÀx¦s®æ·|¥X²{#DIV/0!¡A¦Ó±µ¤U¨ÓªºÀx¦s®æ´N¨S¦³°ÝÃD¡C
(CC¤u§@ªí¤WªºB3-G3ªº¦Ê¤À¤ñ¬O¶Ã¼Æ³B²z¡A¯u¥¿ªºªí®æ¬O¦³¤½¦¡³sµ²¡A©Ò¥H§A¬ÝÀɮ׮ɡA¬O¤£·|¦³°ÝÃDªº¡C)
§Ú·Q°Ýªº¬O¡A§Ú«Ü½T©wF3 & G3ªº®æ¤l³£¬O¦³¼ÆȪº¡A¦ÓL4 & M4¬O½Æ»sF3& G3ªº¼ÆÈ¡A¬°¤°»òÁÙ·|¥X²{#DIV/0!©O¡H
Y¯uªº¬O¦]¬°F3&G3ªº¤½¦¡¡A¦Ó¾ÉPL4&M4¥X²{#DIV/0!ªº¸Ü¡A¦³¤°»ò¤èªk¥i¥HÅýL4&M4³æ¯ÂÀx¦s¼ÆÈ´N¦n©O¡H
¯uªº³Â·Ð§A¤F¡A§Æ±æ§Úªº±Ôz§A¯à¬Ý±oÀ´¡CÁÂÁ¡C |
|
|
|
|
|
|
- ©«¤l
- 48
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-4-9
- ³Ì«áµn¿ý
- 2019-12-17
|
¦^´_ 14# stillfish00
¤£nºò¡A ÁÂÁ§A¡Astillfish00¤j¤j¡C
§ÚºÉ¶q¤£n¦³ÅÜ°Ê¡AÀ³¸Ó´N¨S¦³°ÝÃD¤F¡C
Á`¤§¡AÁÙ¬OÁÂÁ§AªºÀ°¦£©M«ü¾É¡C :) |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 13# ahsiek
©êºp¤F¡A§Ú¤]¤£¾å±oDDE¬O§_·|/¦p¦ó¼vÅT©Î¨ú®øExcelªº³¡¤À¥\¯à¡A
¤]¦³¥i¯à¬O»PExcelÀ³¥Îµ{¦¡¸ê·½¤À°t°ÝÃD¡A³o¤è±¨S¦³¬ã¨s¹L¡A
¤âÃä¤]¨S¬ÛÃö¤u¨ã¥i´ú¸Õ¡A³o°ÝÃD¥i¯àn½Ð±Ð¨ä¥Lª©¤Í¬O§_¯à¸Ñ´b¤F¡C
¦ý¤@¯ë±`¨£ªº¬OÂǥѤu§@ªíªºCalculate¨Æ¥ó¨Ó°O¿ýDDEªºÈ¡Aª©¤W¤]¦³Ãþ¦ü°Q½×¥i°Ñ¦Ò¬Ý¬Ý¡C |
|
|
|
|
|
|
- ©«¤l
- 48
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-4-9
- ³Ì«áµn¿ý
- 2019-12-17
|
¦^´_ 10# stillfish00
§Ú¥i¥H¦A°Ý¤@Ó°ÝÃD¶Ü¡HY°£¤FAA(2) & BB(2)¤u§@ªí¥~¡AÁÙ¦³ÓCCªº¤u§@ªí¡ACCªº¤u§@ªí¸Ì±¦³DDE³sµ²©M¤½¦¡¡C
¦Ó§Ú¦bCC¤u§@ªí¤W·|¾ã²z¤@¨Ç¸ê®Æ©Î°µ§ó§ï®É¡ABB¤u§@ªí³ºµM°±¤îÀx¦s¤F¡C
§Ú¥i¥H½T©w¬OCC¤u§@ªí©MBB(2)¤u§@ªí¨Ã¨S¦³³sµ²¡A·Q½Ð°Ý§Ú¸Ó¦p¦ó§ó§ï¤~¤£·|ÅýBB(2)¤u§@ªí°±¤îÀx¦s©O¡H[attach]¼ÆÈ°O¿ý[/attach] |
-
-
¼ÆÈ°O¿ý.rar
(286.5 KB)
¼ÆÈ°O¿ý
|
|
|
|
|
|
- ©«¤l
- 48
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-4-9
- ³Ì«áµn¿ý
- 2019-12-17
|
¦^´_ 10# stillfish00
ÁÂÁÂstillfish00¤j¤jªºÀ°¦£¡AÀ³¸Ó¬O¨S¦³°ÝÃD¤F¡C
¯uªº«D±`·PÁ§A¡C§Ú¤]·|§V¤O¾Ç²ßVBAªº¡A¦A¦¸ÁÂÁ¡C |
|
|
|
|
|
|