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

VBA ¸ê®Æ·j´M°ÝÃD

¦^´_ 21# a5007185


    ÁÂÁÂ, ¼ö¤ß¤À¨É

TOP

¦^´_ 14# Kubi

  ½Ð±Ð, ¦pªG Data ¥Ø«e¤S¼W¥[¦h¤@­¶,  Data 1, ¤S©ÎªÌ¦n´X­¶, ¨º»yªk¤S­n¦p¦ó­×§ï?

    Book1(½d³òª«¥óªk¥[±Æ§Ç)-2.rar (24.69 KB)

TOP

¦^´_ 24# Kubi

    Kubi
   
   ¤£À´¬O¤£¬O§Úªº Data ¤Ó¦h¤F

   Data & Data 1 ¥[°_¨Ó¦@¦³8¸U¦hµ§

   ©Ò¥H¦b·j´M¹Lµ{¤¤, ¦³®É¥i¥H, ¦³®É¤S¤£¥i¥H

   ­ì¥»·Q±NªþÀɤW¶Çµ¹§A¬Ý. ¦ý¤å¥ó¤Ó¤j¤F(7MB), ¤£¥i¥H¤W¶Ç
   
    ·Q°Ý, §Aµ¹§Ú³Ì¦Zªº»yªk, ¬O§_¶W¥X6¸Uµ§, ´N·j´M¤£¨ì?

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2018-9-7 00:05 ½s¿è

¦^´_ 26# Kubi

   ­º¥ý,ÁÂÁ§A©âªÅÀ°§Ú­×§ïµ{¦¡½X
   ·j´M¸ê®Æªº³t«×ªº½T«D±`ªº§Ö.

   ­ì¥»,§Ú·Q¦b Data & Data1 ªº K Ä樽¦A²K¦h1Äæ¸ê®Æ.
   ¦ý¬O, ¦³¤@­Ó§Ú¤£©ú¥Õªº¦a¤è,¬°¦ó§Ú§ä¤£¨ì" Temp" File, ·Pı«Ü¯«©_.
   ¦b¤£±o­n»âªº±¡ªp¤U,¦A¦¸½Ð§A«üÂI°g¬z.
   ÁÂÁÂ!

TOP

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

   ¥Ñ©ó¶Ã½XªºÃö«Y,  ¥i§_½Ð§A±N»yªk¶K¦b¯d¨¥ªO¤W.ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2018-9-14 01:01 ½s¿è

¦^´_ 28# Kubi
   «u§r! ¸£³U¥d¦í¤F, §Ñ¤F¼Ò²Õ..
    ©¯¦n¥H¤W°ÝÃD¸Ñ¨M¤F.

    ¦b"temp"ªºÁôÂÃ¥\¯à

Data.rar (17.54 KB)

Search Data.rar (30.97 KB)

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2018-9-14 07:36 ½s¿è

©_©Ç, ¬°¦ó¯d¨¥¤£¯à§¹¥þÅã¥Ü???

TOP

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

­ã¤jªº¤ßªk©M©Û¦¡¯uªº¤dÅܸU¤Æ,¼h¥X¤£½a.

Åý§Ú·Q°_«Ü¤[¥H«e, ¦b¦¹½×¾Â¤Wªº¤@¦ìª©¥D´¿»¡¹L:
¥u¦³§A·Q¤£¨ìªº, ¨S¦³°µ¤£¨ìªº.

TOP

VBA¸ê®Æ·j´M°ÝÃD

¥»©«³Ì«á¥Ñ Qin ©ó 2018-9-14 13:18 ½s¿è

¦^´_ 28# Kubi

¤å±µ31¼Ó
§Ú·Q±N­ì¥»ªº¤@­ÓÀɤÀ¦¨2­ÓÀɨӨϥÎ.
AÀɬO: Data , Password 1234 , ¸ô®|¬O U:/ACWH/
BÀɬO: Search Data , Password 5678 , ¸ô®|¬O C:/Users/Public/Documents/
½Ð°Ý,­n°µ³o¨Ç­×§ï, »yªk¤S­n¦p¦ó¼g©O?
2ÀɬҪþ¤W
¦b31¼Ó

TOP

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

­ã¤j, ÁÙ¦³¤@¨Ç°ÝÃD·Q­×§ï, ³Ò·Ð¤F!
1) Data Àɸê®Æ«ùÄò¼W¥[¤¤, ¦b¦³·s¸ê®Æ§ó·s¤~·|¥´¶}§ó·s (¦³¥Î±K½XÂê¤Wªº " 1234") , ©Ò¥H§Æ±æ¦b ¨Ï¥Î Search DataÀÉ·j´M¸ê®Æ®É,  Data ÀɬO¤£»Ý­n¥´¶}ªº
2) §Æ±æ·j´Mµ²ªG©Ò§e²{ªº "Date" ¬O¥Ñ²{¤µªº¦~¥÷¦Ü¸û¤[»·ªº¦~¥÷...
3) Á{®É·Q°_, ·Q¼W¥[1­Ó"¤é´Á"·j´M¥\¯à, ½Ð参¦Ò Search DataÀÉ

Search Data1.rar (38.27 KB)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD