¼ÐÃD:
[µo°Ý]
¨Ì«ü©w°Ï¶¡¤é´Á¡B±b¸¹ ¶ñ¤J¸ê®Æ
[¥´¦L¥»¶]
§@ªÌ:
PJChen
®É¶¡:
2021-1-16 16:00
¼ÐÃD:
¨Ì«ü©w°Ï¶¡¤é´Á¡B±b¸¹ ¶ñ¤J¸ê®Æ
¤j¤j̦n,
1.. ¦b"»¡©ú"¤u§@ªí¤¤¦³4Ó±b¸¹"¤j¡B¬ü¡B¨Î¡B®¶",²Å¦X±b¸¹¡B¤é´Á(¦P±b¸¹¤Î¤é´Á,¤£¤@©w¥u¦³¤@µ§)
2.. ¥H"»¡©ú"¤u§@ªí¤¤ªº¥æ¹B¤é´Á,³Ì¤jÈ&³Ì¤pȬ°°Ï¶¡,±NMÄ檺¨úªO½s¸¹¡BOÄ檺¹w¬ùªO¼Æ¶ñ¤J"¹w¬ù"¤u§@ªí¤¤ªºG/CÄæ
3.. ¨úªO½s¸¹¶ñ¤J®É,¨Ì츹½X,¦b³Ì«e±¥[¤W#0000(¨Ò:½s¸¹¬°118120,«h¬°#0000118120)
4.. "¹w¬ù"¤u§@ªí¤¤,¤£ÄÝ©ó¥æ¹B¤é´Á°Ï¶¡Èªº©Ò¦³¸ê®Æ¤Î±b¸¹,³£¤£n¦³¥ô¦óÅÜ°Ê(¦³¸ê®Æªº,«O¯dì¸ê®Æ,µL¸ê®Æ«hªÅ¥Õ)
5.. ¨Ò¦p¡G1/13~1/29¤£¦b¦¹°Ï¶¡,¤w¦³ªºì¸ê®Æ¤£¥iÅÜ°Ê,1/15 & 1/18¤]¦³«DÄÝ4¤j±b¸¹,¤]¤£¥i¶ñ¤J¸ê®Æ
½Ð°Ýn¹F¨ì³o¨Çn¨D,¥Î¨ç¼Æorµ{¦¡¥i¥H¹F¦¨?
[attach]32980[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-1-16 22:51
¦^´_
1#
PJChen
¦³ªÅÀ°§Ú¸Õ¸Õ¬Ý¬O¤£¬O³o¼Ë¤ñ¹ï ·PÁ ^^"
Public Sub ¸ó¤u§@ªí¤ñ¹ï½m²ß()
Arr = [»¡©ú!I2].CurrentRegion
Brr = [¹w¬ù!A1].CurrentRegion
For X = 2 To UBound(Arr)
A = Arr(X, 1) & "-" & Arr(X, 4)
For Y = 2 To UBound(Brr)
B = Brr(Y, 2) & "-" & Brr(Y, 1)
If A = B And Arr(X, 4) <> "" Then
Brr(Y, 3) = Arr(X, 7)
Brr(Y, 7) = "#0000" & Arr(X, 5)
End If
Next Y
Next X
[¹w¬ù!A1].Resize(UBound(Brr, 1), UBound(Brr, 2)) = Brr
End Sub
½Æ»s¥N½X
§@ªÌ:
ã´£³¡ªL
®É¶¡:
2021-1-17 10:19
Sub ¹w¬ù§ó·s()
Dim Arr, xD, i&, T$
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range([»¡©ú!R1], [»¡©ú!i65536].End(xlUp))
For i = 3 To UBound(Arr)
If Arr(i, 1) = "" Or IsDate(Arr(i, 4)) Then
T = Arr(i, 1) & "|" & Arr(i, 4)
xD(T) = xD(T) + Val(Arr(i, 7)) '¦P¤é¦P¸¹¤£¥u¤@µ§,²Ö¥[
xD(T & "/m") = "#0000" & Arr(i, 5) '¨úªO½s¸¹
End If
Next i
Arr = Range([¹w¬ù!G1], [¹w¬ù!A65536].End(xlUp))
For i = 2 To UBound(Arr)
T = Arr(i, 2) & "|" & Arr(i, 1)
If xD.Exists(T) Then
Arr(i, 3) = xD(T)
Arr(i, 7) = xD(T & "/m")
End If
Next i
[¹w¬ù!A1].Resize(UBound(Arr), 7) = Arr
End Sub
'==========================
§@ªÌ:
PJChen
®É¶¡:
2021-1-17 16:05
¦^´_
3#
ã´£³¡ªL
¦^´_
2#
°a¤ªºµ
·PÁ¨â¦ì¤j¤j,
¤GÓµ{¦¡´ú¸Õµ²ªG³£¬Û¦P¡G
¦P¤@¤é´Á¡B¦P±b¸¹¦³¦hµ§¨úªO¸ê®Æ®É,±a¥Xªºµ²ªG¦³»~
¨úªO½s¸¹¥u·|±a¥X³Ì«á¤@µ§,¼Æ¶q·|Åܦ¨²Ö¥[
¥H¤U¹Ï¤ù¬°¶]µ{¦¡µ²ªG v.s. ¥¿½T¸ê®Æ
[attach]32981[/attach]
§@ªÌ:
ã´£³¡ªL
®É¶¡:
2021-1-17 17:40
¦^´_
4#
PJChen
Sub ¹w¬ù§ó·s()
Dim Arr, xD, i&, T$
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range([»¡©ú!R1], [»¡©ú!i65536].End(xlUp))
For i = 3 To UBound(Arr)
If Arr(i, 1) <> "" And IsDate(Arr(i, 4)) Then
T = Arr(i, 1) & "|" & Arr(i, 4) & "#0000" & Arr(i, 5)
xD(T) = xD(T) + Val(Arr(i, 7))
End If
Next i
Arr = Range([¹w¬ù!G1], [¹w¬ù!A65536].End(xlUp))
For i = 2 To UBound(Arr)
T = Arr(i, 2) & "|" & Arr(i, 1) & Arr(i, 7)
If xD.Exists(T) Then Arr(i, 3) = xD(T)
Next i
[¹w¬ù!A1].Resize(UBound(Arr), 7) = Arr
End Sub
§@ªÌ:
PJChen
®É¶¡:
2021-1-17 18:03
¦^´_
5#
ã´£³¡ªL
¤j¤j,
§Ú¸Õ¤F´X¦¸,³£µL°Ê§@,¤£ª¾µo¥Í¤°»ò¨Æ...
§@ªÌ:
PJChen
®É¶¡:
2021-1-17 18:17
¥»©«³Ì«á¥Ñ PJChen ©ó 2021-1-17 18:24 ½s¿è
¦^´_
5#
ã´£³¡ªL
¸Õ¤F´X¦¸ÁÙ¬O¤£¦æ,½Ð¤j¤jÀ°¦£¬Ý¤Uµ{¦¡¡I
·PÁÂ
[attach]32983[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-1-17 20:06
¦^´_
7#
PJChen
¦³ªÅ¦A¸Õ¸Õ¬Ý³o¼Ë¦æ¤£¦æ ·PÁÂ
Public Sub ¸ó¤u§@ªí¤ñ¹ï½m²ß()
Arr = [»¡©ú!I2].CurrentRegion
Brr = [¹w¬ù!A1].CurrentRegion
For X = 2 To UBound(Arr)
A = Arr(X, 1) & "-" & Arr(X, 4)
For Y = X To UBound(Brr)
B = Brr(Y, 2) & "-" & Brr(Y, 1)
If A = B And Brr(Y, 3) = "" Then K = 0
If A = B And Arr(X, 4) <> "" And K <> 1 Then
K = 1
Brr(Y, 3) = Arr(X, 7)
Brr(Y, 7) = "#0000" & Arr(X, 5)
Exit For
End If
Next Y
Next X
[¹w¬ù!A1].Resize(UBound(Brr, 1), UBound(Brr, 2)) = Brr
End Sub
½Æ»s¥N½X
§@ªÌ:
PJChen
®É¶¡:
2021-1-17 20:22
¦^´_
8#
°a¤ªºµ
·PÁ¡I
³oÓµ{¦¡OK¤F
§@ªÌ:
PJChen
®É¶¡:
2021-1-20 21:53
¦^´_
8#
°a¤ªºµ
±z¦n,
µ{¦¡¦b¹ê§@®É,µo²{¤F°ÝÃD:°õ¦æµ{¦¡«á,·|±ND:FÄ檺¤½¦¡È¤Æ,¥B¤£ÄÝ©ó³oӰ϶¡ªº¤]³£È¤Æ¤F,
½Ð°Ýn¦p¦óקïµ{¦¡,ÅýD:FÄ椣¨üµ{¦¡¼vÅT,«O«ùì¼Ë(¦³¤½¦¡«h«O¯d)¡H
[attach]32991[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-1-21 00:29
¦^´_
10#
PJChen
§â°}¦C§ï¦¨ CELLS À³¸Ó¥i¥H ¦³ªÅ¦A¸Õ¸Õ¬Ý¦æ¤£¦æ ·PÁÂ
Sub ¹w¬ù§ó·s_2()
Application.ScreenUpdating = False
Arr = [»¡©ú!I2].CurrentRegion
Brr = [¹w¬ù!A1].CurrentRegion
For X = 2 To UBound(Arr)
A = Arr(X, 1) & "-" & Arr(X, 4)
For Y = X To UBound(Brr)
B = Brr(Y, 2) & "-" & Brr(Y, 1)
If A = B And Brr(Y, 3) = "" Then K = 0
If A = B And Arr(X, 4) <> "" And K <> 1 Then
K = 1
Cells(Y, 3) = Arr(X, 7)
Cells(Y, 7) = "#0000" & Arr(X, 5)
Exit For
End If
Next Y
Next X
Application.ScreenUpdating = True
End Sub
½Æ»s¥N½X
§@ªÌ:
PJChen
®É¶¡:
2021-1-21 21:38
¦^´_
11#
°a¤ªºµ
¯u·PÁ¡I°õ¦æ¨S°ÝÃD¤F
½Ð°Ýì¨Óªºµ{¦¡,¤£»Ýn¤F¶Ü? [¹w¬ù!A1].Resize(UBound(Brr, 1), UBound(Brr, 2)) = Brr
2 To UBound(Arr)...UBound(Arr)«e±ªº¼Æ¦r¥Nªí¤°»ò?§Ú±`¬Ý¨ìµ{¦¡«e¦³¤£¦P¼Æ¦r,¦ý¤£²z¸Ñ¥Îªk¡I
¥i¥Hªº¸Ü¯à§_À°¦£¸Ñ»¡±z¼gªºµ{¦¡¡H
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-1-22 00:11
¦^´_
12#
PJChen
Sub ¹w¬ù§ó·s_2()
Application.ScreenUpdating = False 'Ãö³¬§ó·sµe±
'§â¤u§@ªíªº©Ò¦³¤º®e©ñ¨ì°}¦C
Arr = [»¡©ú!I2].CurrentRegion
Brr = [¹w¬ù!A1].CurrentRegion
For X = 2 To UBound(Arr) '¦b°}¦C¸Ìªº²Ä2¦C¶}©l¨ì³Ì«á¤@¦C
A = Arr(X, 1) & "-" & Arr(X, 4) '»¡©ú¤å¦r ±b¸¹¦êÁp¤é´Á
For Y = X To UBound(Brr) '¦b°}¦C¸Ìªº²Ä2¦C¶}©l¨ì³Ì«á¤@¦C
B = Brr(Y, 2) & "-" & Brr(Y, 1) '¹w¬ù¤å¦r ±b¸¹¦êÁp¤é´Á
If A = B And Brr(Y, 3) = "" Then K = 0 '¦pªG»¡©ú¤å¦r»P¹w¬ù¤å¦r¬Û¦P ¥B¹w¬ùX¦C¦ìªº²Ä3Äæ¦ì¨S¦³¤º®e K´Nµ¥©ó0 ªí¥Ü¨S¦³³Q¤ñ¹ï¹L
If A = B And Arr(X, 4) <> "" And K <> 1 Then '¦pªG»¡©ú¤å¦rªº»P¹w¬ù¤å¦r¬Û¦P ¥B»¡©úX¦C¦ìªº²Ä4Äæ¦ì¦³¤º®e ¥BK¤£µ¥©ó1 ªí¥Ü¨S¦³³Q¤ñ¹ï¹L
K = 1 'ªí¥Ü¤w¸g³Q¤ñ¹ï¹L
Cells(Y, 3) = Arr(X, 7) '§â»¡©úªº¹w¬ùªO¼Æ©ñ¨ì¹w¬ù¤u§@ªíªº³æ¶µ¨úªOÄæ¦ì
Cells(Y, 7) = "#0000" & Arr(X, 5) '§â»¡©úªº "#0000"¦êÁp¨úªO½s¸¹ ©ñ¨ì¹w¬ù¤u§@ªíªº¨úªO½s¸¹Äæ¦ì
Exit For '¸õ¨ì¤U¤@Ó°j°é
End If
Next Y
Next X
'D:FÄ檺¤½¦¡È¤Æ ¬O¦]¬° Brr = [¹w¬ù!A1].CurrentRegion ªºÃö«Y ©Ò¦³¤º®e©ñ¨ì°}¦C ©Î§ï¦¨¯S©w¦ì¸m
'[¹w¬ù!A1].Resize(UBound(Brr, 1), UBound(Brr, 2)) = Brr ¦]¬°¨S¦³¦b°}¦C¸Ì¤ñ¹ï©Ò¥H¤£»Ýn
Brr«üªº¬O¹w¬ù¤u§@ªí¤ñ¹ï«áªº¤º®e
¨ä¹ê¥Î¦r¨å¤èªk·|§ó¦n ¦ý¤p§ÌÁÙ¦b¾Ç²ß¤¤¤£¤Ó²z¸Ñ...¦³ªÅÁÙ¬O·|¨Ó¬Ý¬Ý¤j¤jÌ«ç»ò¼g.¶¶«K¾Ç²ß^^"
Application.ScreenUpdating = True '¶}±Ò§ó·sµe±
End Sub
§@ªÌ:
PJChen
®É¶¡:
2021-1-22 23:00
¦^´_
13#
°a¤ªºµ
½Ð°Ý§Ú¬d¤FCurrentRegion¬O·í«e°Ï°ìªº·N«ä,
¨ºArr = [»¡©ú!I2].CurrentRegion
¬O«ü±qI2¨ìþÓÀx¦s®æ¬°¤î?
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-1-23 01:13
¦^´_
14#
PJChen
¨º¬O¤@ӰʺA½d³ò ·|ÀHµÛÀx¦s®æ¤º®eÅÜ°Ê ¦ý«e´£¬O ¥un¦³¤º®eªºÀx¦s®æ ³£¬O§Anªº §_«h·|¿ï¨ì¤@¨Ç¤£¬ÛÃöªº¤º®e
¨ä¹ê«Ü¦h°ÝÃD ³£¥i¥H¦b³o¸Ì§ä¨ìµª®×
¹F¤HÁ`µ²ªºVBAºë¨åªº""¤K""Ãþ¦Ê±ø»y¥yª©
·s¤â VBA ¤Jªù±`¨£°ÝÃD
§Ú³£¬O¦b³o¸Ì¾Çªº ¦pªG§ä¤£¨ìµª®× ¬Ý¬Ý¤@¨Ç¤å³¹¸Ì¤]³\·|¦³ ¦A¤£¦æ«e½ṳ́]·|¦³µª®× ³o¸Ì¯uªº¥i¥H¾Ç¨ì«Ü¦h
¦]¬°¨CÓ«e½úªº«ä¦ÒÅÞ¿è³£¦³©Ò¤£¦P ¦³®ÉԬݨì«e½ú̼g ·|µo²{ «z~ì¨ÓÁÙ¥i¥H³o¼Ë...... ¨þ¨þ..
§@ªÌ:
PJChen
®É¶¡:
2021-1-23 21:40
¦^´_
15#
°a¤ªºµ
ÁÂÁ±z, ¦³°ÝÃD·|¦A½Ð±Ð
§@ªÌ:
PJChen
®É¶¡:
2021-3-4 22:14
¦^´_
15#
°a¤ªºµ
ºµ¤j¦n,
¤µ¤Ñ°µ¤À§å¹w¬ù®É,µo¥Í¤F°ÝÃD,½ÐÀ°¦£¬d¬Ýµ{¦¡,·PÁ¡I
»¡©ú¤u§@ªíªºÄx¦â°Ï¶ô¥ý¶i¦æ²Ä¤@¦¸¹w¬ù,¶ñ¤J¸ê®Æ¨S°ÝÃD
¶À¦â°Ï¶ô¬O²Ä¤G§å¹w¬ù¸ê®Æ,¶K¨ìL11:S19«á,µ{¦¡´NµLªk¸ü¤J¸ê®Æ¦Ü"¹w¬ù¤u§@ªí",
¸g¹L´ú¸Õ,¥un§â"¹w¬ù¤u§@ªí"ªº«ü©w°Ï¶¡¸ê®Æ²M°£,¶ñ¤J¸ê®Æ´N¥i¥¿±`°õ¦æ,
½Ð°Ý¦³¨S¦³¿ìªk,·í¸ê®Æ¤À§å¥X²{®É,¤£¥Î°µ²M°£°Ê§@,´N¥i¥H¸ü¤J¸ê®Æ??
[attach]33093[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-5 03:43
¦^´_
17#
PJChen
§Ú¬Ý¤£¥X¨Ó¡D¡D¡D¡@¡ÖÈСա@¡@¥i¤£¥i¥H½Ð¡@PJChen¤j¤j¡@°µ°O¸¹©ÎµÛµe®Ø®Ø¡@»¡²M·¡¤@ÂI¡@©êºp¡@§Ú²z¸Ñ¯à¤O¤£¤Ó¦n¡@³Â·Ð©p¤F¡@·PÁÂ
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-5 04:14
¦^´_
17#
PJChen
¦n¹³¬O¡@¢ÚÄæ®æ¦¡¡@¤£¬O¤é´Á®æ¦¡¡@¦³§ï¤F¤@¤U¡@¦³ªÅ©p¦A¸Õ¸Õ¬Ý¬O¤£¬O¢ÚÄ檺°ÝÃD¡@·PÁÂ
[attach]33096[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-5 04:49
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-5 04:53 ½s¿è
¦^´_
17#
PJChen
©êºp¡@è¤~µo²{¡@nÂI¦n´X¦¸¸ê®Æ¤~·|¥þ³¡¦C¥X¡@§PÂ_¨S§ï¦n¡@¦A¶Ç¤@¦¸¡@¡ÖÈСա@¦³ªÅ¦AÀ°§Ú¬Ý¬ÝÁÙ¦³¨S¦³¨ä¥¦°ÝÃD¡@·PÁÂ
[attach]33097[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-5 05:24
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-5 05:26 ½s¿è
¦^´_
17#
PJChen
¤W±ªºÀɮס@¨S§ï¦n·|¥X¿ù¡@©Ò¥H«·s¦A¤W¶Ç¡@·Q§â¤W±ªºÀɮקR°£¡@¥i¬O¤£ª¾¹D«ç»ò§R°£¡@¦n¹³®É¶¡¹L¤F´NµLªk§R°£¡D¡D¡D©êºp¤Fã¤j¡@©¹«á§Ú·|ª`·N½T©w¤F¦A¤W¶Ç¡@
[attach]33098[/attach]
§@ªÌ:
PJChen
®É¶¡:
2021-3-7 21:20
¦^´_
21#
°a¤ªºµ
ºµ¤j,
§Ú±N¹w¬ù!¶À¦â°Ï°ìªº¸ê®Æ²M°£¤F, °õ¦æµ{¦¡«á,´N¥i¥H¬Ý¨ì¬Y¨Ç¤é´ÁµLªk¸ü¤J¸ê®Æ
³Â·Ð±z¤F...
[attach]33104[/attach]
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-7 22:11
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-7 22:18 ½s¿è
¦^´_
22#
PJChen
§A¬O»¡³o¸Ì¶Ü? ©p«üªº¬Oþ¨Ç³¡¤À¥i¥H®Ø°_¨Ó©ÎµÛ°µ°O¸¹¶Ü? §Ú¬Ý¤£¥X¨Ó ...>"<
»¡©ú¸ê®Æ¸Ì±¨S¦³
03/02 ¶g¤G ¬ü
03/03 ¶g¤T ¨Î
03/03 ¶g¤T ¬ü
03/04 ¶g¥| ¬ü
¤j 9 2021/2/18¶g¥|
¤j 10 2021/2/19¶g¤
¤j 11 2021/2/19¶g¤
¤j 12 2021/2/19¶g¤
¤j 13 2021/3/2¶g¤G
¤j 14 2021/3/3¶g¤T
¤j 15 2021/3/4¶g¥|
[attach]33105[/attach]
[attach]33106[/attach]
§@ªÌ:
PJChen
®É¶¡:
2021-3-8 16:06
¦^´_
23#
°a¤ªºµ
ºµ¤j¦n,
§Ú¤U¸ü¤F§A´ú¸ÕªºÀÉ®×,¬Ý¨ì¦³¥¿½Tªº¸ü¤J¸ê®Æ,
¦ý§Ú±N¸ê®Æ²M°£«á,¦A«·s°õ¦æµ{¦¡,ÁÙ¬O¦P§Ú¤§«e´ú¸Õ¤@¼Ë,
±b¸¹"¤j"¸ü¤J¸ê®Æ¥u¨ì2/17´N°±¦í¤F,°õ¦æ¦h¦¸,³£¦P¼Ëµ²ªG,
¬d¤£¨ìì¦]¡I
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-8 21:21
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-8 21:26 ½s¿è
¦^´_
24#
PJChen
§Ú³o¸Ì´ú¸Õ 2Ó¤èªk³£¨S¦³°ÝÃD
§Ú·Q¥i¯à¬O ÅܼƨS¦³©w¸q ©ÎµÛ ¬O¤å¦rªºªø«×¦³°ÝÃD
¦³§ï¼g¤F §ì¨ú »¡©ú¸ê®Æ¸Ìªº LÄæ ¤è¦¡ ¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý ·PÁÂ
[attach]33108[/attach]
§@ªÌ:
PJChen
®É¶¡:
2021-3-8 21:41
¦^´_
25#
°a¤ªºµ
ºµ¤j,
¤GÓ¼gªk°õ¦æµ²ªG³£¬Û¦P,±b¸¹"¤j"¸ü¤J¸ê®Æ¥u¨ì2/17´N°±¦í¡I
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-8 21:46
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-8 21:53 ½s¿è
¦^´_
26#
PJChen
§Ú³o¸Ì¶] 2Ó³£¥¿±`
[attach]33109[/attach]
©p¥ý§â »¡©ú¸ê®Æ¸Ìªº ¥H¤U¤¤¤å§R°£ ¥u¯d¤é´Á ¥Î²Ä2Ӥ覡¶]¬Ý¬Ý ¤£n¥Î Function
2021/2/18¶g¥|
2021/2/19¶g¤
2021/2/19¶g¤
2021/2/19¶g¤
2021/3/2¶g¤G
2021/3/3¶g¤T
2021/3/4¶g¥|
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-8 22:04
¦^´_
26#
PJChen
ÁÙ¬O©pªº Excel ³]©w¦³§ï¨ì¬Æ»òªF¦è? ¬Ý¬Ý¦³¨S¦³¤j¤j¯àÀ°¦£´ú¸Õ¤@¤U ¬O¤£¬O§Úªº¼gªk¦³°ÝÃD §Ú¶]¥X¨Ó ¬O¥¿±`ªº ¤£ª¾¹D¬Oþ¸Ì¦³°ÝÃD >"<
§@ªÌ:
PJChen
®É¶¡:
2021-3-8 23:04
¥»©«³Ì«á¥Ñ PJChen ©ó 2021-3-8 23:06 ½s¿è
¦^´_
27#
°a¤ªºµ
ºµ¤j,
§Ú´ú¸Õªº®ÉÔ,³£¥u¦³¤é´Á&±b¸¹,¦Ó¥B§Ú¤]¨S¦³¥t¥~°µ¤°»ò³]©w,¦ý¶]¥Xªºµ²ªG¤@ª½³£¤£¥¿±`,
쥻§@·~¨Sµo¥Í¤°»ò°ÝÃD,¬O¦]¬°³Ìªñ¤@ª½n¤À§å¹w¬ù,¤~µo²{°ÝÃDªº¡I
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-8 23:16
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-8 23:24 ½s¿è
¦^´_
29#
PJChen
»¡©ú¸ê®Æ¸Ìªº LÄæ ¦³¨Ç¤£¬O¤é´Á®æ¦¡ ¤£ª¾¹D¬O¤£¬O³oÓ°ÝÃD
¦ý §Ú¤w¸g §ï¼g¤F iif ¸ò Function 2Ӥ覡 ³£¥i¥H§ì¨ì ¤é´Á
§Ú¸ÕµÛ§â»¡©ú¸ê®Æ¶À¦â³¡¤À¥ý§R°£ °õ¦æ¤@¦¸ µM«á¶K¦^¥h ¦b°õ¦æ¤@¦¸ ¸ê®Æ¤]³£·|¥X²{
ÁÙ¬O ©pªº¤À§å «üªº¤£¬O§Ú»¡ªº¨º¼Ë? ©ÎµÛ¹w¬ù¸ê®Æ®æ¦¡¦³ÅܤÆ? ¦pªG¤£¬O ¥i¥H§i¶D§Ú©p¬O«ç»ò°µ¤À§åªº ²Ó¸`¨BÆJ ·PÁÂ
§@ªÌ:
PJChen
®É¶¡:
2021-3-9 00:20
¥»©«³Ì«á¥Ñ PJChen ©ó 2021-3-9 00:31 ½s¿è
¦^´_
30#
°a¤ªºµ
ºµ¤j,
ì¨Ó¬O¤U¸ü¤U¨Óªº¸ê®Æ,¤£ª¾¦Wªºì¦],¤é´ÁÅܦ¨¤å¦r,Åý§Ú¶Ë³z¸£µ¬,¤]µÛ¹ê³Â·Ð±z¤F¡I
¤£¥Î¦A§ï,¥Îì¨Óªºµ{¦¡´N¦n,¥un§Ú¤p¤ß¤é´Á°ÝÃD´N¥i¥H¤F¡I
ÁÂÁ±zµo²{³oÓ°ÝÃD, ¤£¹L¬°¦ó¤é´ÁÅܦ¨¤å¦r,§Ú°õ¦æµ{¦¡¦³°ÝÃD,±z«o¥i°õ¦æµL»~©O¡H
¬O«ç»ò°µªº¡H
§@ªÌ:
°a¤ªºµ
®É¶¡:
2021-3-9 22:03
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-9 22:08 ½s¿è
¦^´_
31#
PJChen
§Ú¥u¬O°õ¦æ ¹w¬ù#1 «ö¶s¦Ó¤w ¨S¦³°µ¥ô¦ó°Ê§@ À³¸Ó¬O§Úªº¼gªk¦³°ÝÃD
¦³ªÅ ¦bÀ°§Ú¸Õ¸Õ¬Ý §Ú§â®æ¦¡ ¥[¤J CDate ¬Ý¬Ý¦³¨S¦³¥Î 2Ó¤èªk³£¦³¥[
¦pªG¬O¥Î Function ¦r¦êªø«×´N¤£¥Î¾á¤ß¦³ÅÜ¤Æ ¦ý³t«×·|ÅܺC
IIf ¬O©T©w¦©³Ì«á2Ó¦r ¦r¦êªø«×¦³ÅܤƴN·|¥X¿ù ¦ý·|¤ñ¸û§Ö¤@ÂIÂI
¦]¬°§Ú³oÃä´ú¤£¥X¨Ó®t§O ¥¿±`À³¸Ó·|Âà¤é´Á¤~¹ï
[attach]33112[/attach]
§@ªÌ:
PJChen
®É¶¡:
2021-3-10 21:09
¦^´_
32#
°a¤ªºµ
ÁÂÁºµ¤j,
¥H¥Ø«e¹w¬ùªº¸ê®Æ,¨S¦³·Pı©úÅ㪺§ÖºC®t¶Z,¨âªÌ³£¥i¥H·Ç½Tªº¸ü¤J¸ê¡I
Åwªï¥úÁ{ ³Â»¶®a±Ú°Q½×ª©ª© (http://forum.twbts.com/)