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

[µo°Ý] ¨Ì¤é´Á¨ú¸ê®Æ

[µo°Ý] ¨Ì¤é´Á¨ú¸ê®Æ

¥»©«³Ì«á¥Ñ qaqa3296 ©ó 2020-9-12 20:42 ½s¿è

¨Ì¤À­¶1ªºE2¤é´Á¥h§PÂ_¤À­¶¥Ø¼Ðªº¥Í®Ä»P¥¢®Ä¤é´Á


±ø¥ó
«ö¶s©ñ¨ì¤À­¶1
¥Í®Ä»P¥¢®Ä¤é´Á¬°ªÅ¥Õ®É¡A¸Ó¦æ­n¦C¥X
¥Í®Ä¤é´Á»P¥¢®Ä¤é´Á³£¬Û¦P®É¡A¤w¥¢®Ä¬°·Ç¡A¸Ó¦æ¤£¦C¥X

²Å¦X±ø¥óªº¸ê®Æ¦C¨ì¦¨ªG¡A¥H2020/09/12¬°¨Ò


¤é´Á¤ñ¹ï­n¦p¦ó¼g¨S¦³ÀYºü¡Aª¦¤å¬ÝCDdate¡BdateVaule¡B#()#¡A¬Ý¤£À´¦p¦ó¹B¥Î¡A§Æ±æ¦U¦ì¤j¤jÀ°¦£

0912.zip (9.4 KB)

¦^´_ 1# qaqa3296
¦³ªÅÀ°§Ú ´ú¸Õ¤@¤U¬Ý¬Ý¬O¤£¬O §A­nªº
¥Í®Ä¤é´Á»P¥¢®Ä¤é´Á³£¬Û¦P®É¡A¤w¥¢®Ä¬°·Ç¡A¸Ó¦æ¤£¦C¥X    ³o§Ú¤£¤Ó©ú¥Õ   §A¥ý¸Õ¸Õ¬Ý¬O¤£¬O³o¼Ë

javascript:;

0913.rar (29.11 KB)

TOP

¦^´_ 2# °a¤ªºµ

·PÁ°a¤ªºµªºµ{¦¡¡A¥\¯à¥¿½T

µM«á¬Ý¨ì¼ô±xªº¦r¦ê©î¶}®æ¦¡¡A¤~µo²{§Ú¬Y¤@¤Ñªº¤é´Á®æ¦¡¥´¿ù¤F!

Åý§A¦h¼g¤À³Î¤å¦r

¸ß°Ý¤@¤U
U = True: K = 1
For i = 1 To UBound(Arr)
    If U = True Then
        For F = 1 To UBound(Arr, 2)
            Brr(1, F) = Arr(1, F)
        Next F
    U = False
    End If
§@¥Î¬O¤°»ò?

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2020-9-13 12:47 ½s¿è

¦^´_ 3# qaqa3296
¨º¥u¬O¦C¥X ¼ÐÃD¦Ó¤w¨S¦³¬Æ»ò§@¥Î  ...XD    ÁÂÁ§AÀ°§Ú´ú¸Õ

TOP

¦^´_ 3# qaqa3296
³o¬O ¥[¤F§R°£­«½Æ À³¸Ó·|§Ö¤@ÂIÂI ¶¶«K§â Select Case §ï¦¨ if  ·Pı¤£¤Ó¾A¥Î >"<


javascript:;

0913_1.rar (32 KB)

TOP

¦^´_ 3# qaqa3296
©êºp °j°é¨S¦³§R°£¨ì... ¦A¶Ç¤@¦¸ >"<


javascript:;

0913_2.rar (31.67 KB)

TOP

¥»©«³Ì«á¥Ñ qaqa3296 ©ó 2020-9-13 21:32 ½s¿è

¦^´_ 6# °a¤ªºµ

©êºp§Ú«e­±¨S¦³´ú¸Õ¥X¨Ó¡AÅÞ¿è¬O¦³°ÝÃDªº

¦ý§Ú¥i¥H¦Û¦æ­×§ï

ªþ¤W´ú¸Õµ²ªG

¦³¦b¥Ø¼Ð¥´¤W³Æµù

0913A.zip (30.57 KB)

TOP

¦^´_ 7# qaqa3296
¦nªº¡@ÁÂÁ§AÀ°§Ú´ú¸Õ¡@§Ú¤]§ï¤F¤@¤U¦³ªÅÀ°§Ú¬Ý¤@¤U¬O¤£¬O³o¼Ë¡@·Qª¾¹D­þ¸Ì¦³°ÝÃD¡@:) ¡@¡@¡@



    javascript:;

0913A_1.rar (29.49 KB)

TOP

¤é´Á®æ¦¡¦³¦hºØ,
¼Æ­È/¤å¦r®æ¦¡+mm/dd/yyyy ???
§ó¥D­n¬O¬Ý¤£À´¤ñ¸û³W«h?? ¤ñ¤j¤ñ¤p???

TOP

¥»©«³Ì«á¥Ñ qaqa3296 ©ó 2020-9-14 20:30 ½s¿è

¦^´_ 9# ­ã´£³¡ªL

§Ú¨ú±oªº¸ê®Æ¡A¥þ³¡ªº®æ¦¡¥u¦³YYYY/MM/DD/¡A¼ÒÀÀÀÉ¥´¿ù¤F©êºp¡C

³o¬O¤@­ÓERPªº¥\¯à¡C
¸ê®Æ§e²{¬O¨C­Óªí®Æ¥ó³£¦³¥Í®Ä»P¥¢®Äªº¤é´Á¡A¿é¤J¤é´Á´N¯àª¾¹D·í®É¥Î¤°»ò®Æ

§Ú·Q§â¥¦·í§@½m²ß¨Ã¾Ç²ß¼gµ{¦¡¡A¦ý¸£³U¥d¦í¤F
¤£ª¾¦p¦ó¤~¯àÅý¤é´Á®æ¦¡¥h¤ñ¤j¤p¡Aªá¤F¤@¨â­Ó¬P´Á...·Q¤£¥X¨Ó¸Õ¤]¸Õ¤£¥X¨Ó

´N¬O³æ¯Âªº¤ñ¤é´Á¤j¤p¨ú±o¹ïÀ³®Æ¥ó¸ê°T¡C
¦ý¬O­n²Å¦X®É¶¡ÅÞ¿è¡A²Ä¤@¦¸«ØÀɧ¹¥þ¨S¦³®É¶¡¥þ³¡®Æ¦³¥Î¨ì(¥þ¦C¥X)
¤§«á§ïª©¨ú®ø®Æ¥ó¡A´N·|µ¹¥¢®Ä¤é¡A·s¼W®Æ·|µ¹¥Í®Ä¤é(¶}©l¦³¤é´Á®t²§)
¥Í®Ä¤é¨ì¡A¦ýµLªk¶q²£»s³y«h¥Í®Ä»P¥¢®Ä¬O¦P¤Ñ¡A©Ò¥H¹ê»Ú¤]¨S¦³¥Î¨ì¨º­Ó®Æ¥ó(¤£¦C¥X)

7¼Óªº¨º­ÓÀÉ¥i¥H¬Ý¥X§Ú·Q­nªºÅÞ¿è¡C




¦^´_°a¤ªºµ
³o¦¸ÅÞ¿è¹ï¤F¡A·PÁ§Aªºµ{¦¡Åý§Ú¾Ç²ß

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD