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

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

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2018-9-16 18:35 ½s¿è

xN = "Data.xls"  >> xN = "Data.xlsx"  
ÁÙ¦³ open ªº¸ô®|¬O¿ùªº, mybook.path ­n²M±¼,
ÀÉ®×µLªk¥´¶}, ¦Û¦æ¥h§ä¸Ñ¨M


SearchData2.rar (76.35 KB)

TOP

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

¤£ª¾°ÝÃD¥X¦b¨º¨½? ¬°¦óÁÙ¬O¤£¦æ?

TOP

¦^´_ 42# Qin


§Ú¨S¦³·sª©¥»ªºEXCEL,
½Ð¨ä¥L¤j¤j¬O§_¥i´ú¤@¤U, ­×§ïOPENµ{¦¡½X~

TOP

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


­ã¤j, ·Q½Ð§A¦AÀ°§Ú¬Ý¤@¬Ý¡K
§Ú¦A¦¸´ú¸Õ,
§A²Ä¤@¦¸µ¹ªºµ{¦¡½X, ¤£½×¬O Data.xls  ©Î Data.xlsx ³£¥i¥H°õ¦æ

«á¨Ó,¦b§Ú­n¨D¼W¥[2¶µ玏¯à¦Z:

1) ¤é´Á±Æ§Ç
2) ¼W¥[¤é´Á·j´M玏¯à

¤£½×¬O Data.xls ©Î Data.xlsx ³£¤£¯à°õ¦æ.

¦b¦¹ªþ¤W2­Ó xls ÀÉ, §Æ±æ¥i¥HÀò±o¥¿½Tªºµª®×. ÁÂÁÂ!

Test again.rar (48.38 KB)

TOP

¦^´_ 44# Qin


§A©Ò¿×ªº¤£¯à°õ¦æ, ¬O«ü·|¿ù»~¤¤Â_(­n¬Ýµ{¦¡½X¿ù¦b­þ¤@¦æ)?  ÁÙ¬O§ì¤£¨ì¸ê®Æ?
§Ú³o´ú¬O¥i¥H(.xls),

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2018-9-21 22:53 ½s¿è

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


     ¥H«~¦W"·¨®ç"¬°¨Ò,ÂùÀ»Ä²µo, §i¤§³£¬O"§ä¤£¨ì²Å¦Xªº¸ê®Æ!" (.xls)

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2018-9-22 08:40 ½s¿è

¦^´_ 46# Qin

¨S°ÝÃDªº~~

TOP

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

­ã¤j,        
       
¦]¬°²Ä2­ÓÀɦ³°ÝÃD,®Ú¥»·j´M¤£¨ì¸ê®Æ, °ß¦³©ñ±ó.       
§Ú®³¦^§Aµ¹§Úªº²Ä1­ÓÀÉ, ¦A«ö·Ó²Ä2­ÓÀɪºµ{¦¡½XºV¥´¶i¥h,       
µo²{³o¬q¦³°ÝÃD       
"  xU.AutoFilter Field:=3, Criteria1:=">=" & Ur1(3), Operator:=xlAnd, Criteria2:="<=" & Ur1(4)  "       
¥u­n¤£¼g¤W³o¬q, ´N¥i¥H¨Ï¥Î.       
¦ý¤é´Áªº·j´M¥\¯à´N¤£ºÞ¥Î¤F       
¨Ò: ¶ñ¤W From Date    01/ 01/2017     to Date    "Today()"       
¦ý¥¦ 2015 - 2016 ¦~ªº¸ê®Æ¤]¶]¥X¤F???       
       
³Â·Ð§A¦AÀ°§Ú¬Ý¤@¬Ý¡KÁÂÁÂ!!       


New folder1.rar (61.15 KB)

TOP

¦^´_ 48# Qin


¹ê¦b¬Ý¤£¥X­ì¦], ©Î³\¤é´Á®æ¦¡¦³°ÝÃD§a!

TOP

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

­ã¤j
§Aµ¹ªº´£¥Ü, §Ú¤]¥h§ó§ï¤F¦h­Ó¤é´Á®æ¦¡
¦ý¬O³£¬O¦æ¤£³q¡K

«á¨Ó, ¹Á¸Õ¥u¥Î¤W¥b¥y»yªk¨Ó°õ¦æ, ·Q¤£¨ì¤S¥i¥H®@!
xU.AutoFilter Field:=3, Criteria1:=">=" & Ur1(3)

¤]´N¬O»¡, Áä¤J 01/01/2016  ¥¦´N¥u¥X²{ 2016 ¦~¦Ü¤§«áªº¸ê®Æ (ÁöµM¦³¨Ç¿ò¾Ñ, ¦ý¦Ü¤Ö, ¬O¹F¨ì§Ú·Q­nªº¬Y³¡¥÷»Ý¨D)
§Ú·Q°ß¦³Åý³o¤U¥b¥y»yªk"Operator:=xlAnd, Criteria2:="<=" & Ur1(4)" ¦b¤@®Ç¨IºÎ, «Ý§ä¨ì厡¦]®É, ¤~Åý¥¦­«¨£¤Ñ¤é.

¦]¦¹, ½Ð°Ý­ã¤j,

1) ¦pªG¥u¥Î "xU.AutoFilter Field:=3, Criteria1:=">=" & Ur1(3) " ³o¤W¥b¥y»yªk, ¦b·j´M¹Lµ{¤¤, ¹ï¨ä¥L¸ê®Æ·|¤£·|¦³¼vÅT. (¦p: ¸ê®Æ·j´M¥X¨Ó¤£§¹¾ã©Î·j´M³t«×½wºCµ¥°ÝÃD.)

2) §Ú¥Î( .xls OR .xlsx) ¦@40¸Uµ§¸ê®Æ·j´M®É, ¤j·§­nªá30¬íªº®É¶¡, ½Ð°ÝÁÙ¥i¥H¥[³t¶Ü?

3) ¦b½s¸¹·j´MÄæ¦ì, ¨Ò¦p½s¸¹¬O " 20000350"  "11005710"  "10003210" ¦Ó§Ú¥u»ÝÁä¤J " 2*350 " ©Î " 11*5710"... ¤]¥i¥H§â¸ê®Æ·j¥X¨Ó.
´N¦n¹³ Excel ¨½ªº find ¥\¯à, ¥u¬O¤£ª¾¹DVBA ¬O§_¤]¥i¥H°µ¨ì?

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD