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

[µo°Ý] ¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk

[µo°Ý] ¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk


´ú¸ÕÀÉ¡J ¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk.rar (179.22 KB)
·Q±NA¤u§@ªíªºB2:S51¡AV2:AM51¡AAP2:BG51¡ABJ2:CA51ªº¤½¦¡­È¡A
¥H¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¤ºªº¤½¦¡­È¡A
¦U¶K¤WB105:AX122¡FB155:AX172¡FB205:AX222¡FB255:AX272(¥|­Ó°Ï¬q¦U18¦C)¡C
½Ð¸Ô¨£¡J(2021-01-05)_®ÄªGÀÉ

½Ð°Ý¡J
¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¤ºªº»yªk¡AÀ³¸Ó¦p¦ó½s¼g¡H
ÁÂÁ¡I

PS¡J¦³¹w¯d1­ÓCSVÀÉ¥H§Q´ú¸Õ¥Î¡C

¦]¬°¤£À´«ç»ò¤Þ¥Î¨ä¥¦ªº¤u§@ªí(EX:A!)¸ê®Æ¡A©Ò¥H¥u­n¬O¯à¤Þ¥Î¤½¦¡¹F¨ì¦p®ÄªGÀɪºµª®×§Y¥i~
µL½×¬Oª½±µ±N¤½¦¡©ñ¦b¼Ò²Õ1¤º©Î¤Þ¥Î¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¬Ò¥i¡C
ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-1-9 14:06 ½s¿è

©êºp!¤½¦¡ªºµù¸Ñ¦³µ§»~~
¤½¦¡­È½Æ»sÂà¦Ü¶K¤W
­×¥¿¬°
¤½¦¡­È½Æ»sÂà¸m¶K¤W¡C
ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2021-1-9 15:23 ½s¿è

¦^´_ 1# ziv976688

·Q±NA¤u§@ªíªºB2:S51¡AV2:AM51¡AAP2:BG51¡ABJ2:CA51ªº¤½¦¡­È
¥H¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¤ºªº¤½¦¡­È
¦U¶K¤WB105:AX122¡FB155:AX172¡FB205:AX222¡FB255:AX272(¥|­Ó°Ï¬q¦U18¦C)¡C

­È ¬O ­È¡A¤½¦¡ ¬O ¤½¦¡¡A½ÐºÉ¶qÁקK¥Î ¤½¦¡­È ³oºØ±Ô­z.......

«Ü®e©ö²V²cÃB³y¦¨»~·|¡A§â§Aªº±Ô­z§ï¦¨¦p¤U¡A´N²M·¡¦h¤F

·Q±N'T1'ªº'A'¤u§@ªíªºB2:S51¡AV2:AM51¡AAP2:BG51¡ABJ2:CA51ªº "­È"
¥H¤½¦¡A¡A¤½¦¡B¡A¤½¦¡C¡A¤½¦¡Dµ¥4­Ó¼Ò²Õ¤ºªº "¤½¦¡"
¦U¶K¤W'Á`Äý'ªºB105:AX122¡FB155:AX172¡FB205:AX222¡FB255:AX272(¥|­Ó°Ï¬q¦U18¦C)¡C


¥Î"¤½¦¡"¥h¨ú¨ä¥L¬¡­¶Ã¯ªºÀx¦s®æ¸ê®Æ ­n¦h¼g¸Ó¬¡­¶Ã¯ªº¸ô®|+ÀɦW

¦p¤U¬O¨úA1Àx¦s®æ½d¨Ò

='C:\¨Ï¥ÎªÌ­Ì\¯µ±Kªº¨Ï¥ÎªÌ\®à­±\¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk\[49¿òº|§R_ªÅ¼Æ(VBA)_T1.xls]A'!$A$1

¥ú¤@­ÓÀx¦s®æ´N­n¼g³o»òªø!¡A¦pªG§AªºA~D³£³o¼Ë¼g¡A¤½¦¡·|Åܱo§óÃø¾\Ū...ÁÙ¦³¶W¥X 255 ¦r¤¸ªº°ÝÃD

§Ú­Ó¤H¬O«Ü¤Ö¥ÎVBA ¥h¼g Àx¦s®æ¤½¦¡ªº¡A¤×¨ä¹³§A³oºØ¶K§¹¤½¦¡«á¡AÁÙ­n°¨¤WÂন­Èªº~

³oºØ¦bµ{¦¡°õ¦æ¹Lµ{¤¤¡A¤£¯àÃö±¼¤½¦¡¦Û°Ê­pºâ(¤@Ãö±¼´N¨ú¤£¨ì­È)

¦ý¬O¤£Ãö±¼¡AVBAµ{¦¡¨C¹ï¥ô·N¤@­ÓÀx¦s®æªº¤º®e°µÅܧó¡A´N·|¦Û°ÊIJµo­«ºâ¾ã­Ó¤u§@ªí

·|¨Ï±o®Ä²vÅܪº¤ñ¸û§C¡A¹J¨ì ¸ê®Æ¶q¤jªº±¡ªp¡A´N·|«Ü¥d!

¦Ó¥B§AªºªF¦è¬Ý°_¨Ó¶V¨Ó¶V½ÆÂø¤F.........«Øij§A­n¾Ç¨ÇVBA¡A°µÂ²³æªº­pºâ(±Ë±ó¤½¦¡)

§è»·¤F¡A¤W­±ªº¤è¦¡¼g°_¨Ó³Â·Ð¡A¤½¦¡¤]·|Åý¤HÃø¥H²z¸Ñ

¤ñ¸û²³æªº°µªk¬O§âA ¤u§@ªí Copy¨ì ²£¥Í¥X¨Óªº"Á`Äý"¬¡­¶Ã¯

³o¼Ë"Á`Äý"¬¡­¶Ã¯ªº¤½¦¡¡A­n¨úAªí¸ê®Æ¡A´N¤£¦A¬O "¸ó¬¡­¶Ã¯" ¤F

¦A¶K¤W¤½¦¡ > Âà­È¡A³o¼Ë¤@¨Ó§Aªº¤½¦¡ §¹¥þ¤£¥Î­×§ï

³Ì«á"Á`Äý"¬¡­¶Ã¯­nÃö³¬«e¡A¦A§R°£Aªí§Y¥i

Àɮצp¤U



¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk-OK.rar (200.38 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 4# n7822123
n¤j : ±z¦n!
§Ú¤]«Ü·Q¾ÇVBA¡A¦ýÂù¥_¥«³£¨S¦³¸É²ß¯Z(¦³¸ß°Ý¹L"¥¨¦K"©M"Áp¦¨")¶}¯Z±Ð±ÂVBA½Òµ{(¨ä¥¦¦³¶}¯Zªº¦ü¥G³£¦b¤¤«n³¡)¡F
¦³·Q¤Wºô¾Ç²ß¡A¦ý«o¤S¬O¦³¬Ý¨S¦³À´>*<
ÁÙ¦n!³o¤w¸g¬O³Ì«áªº¨BÆJ~»Ý¨DÀɲשó"§¹¦¨¤F"!

ÁÂÁ±z¤@¦Aªº¼ö¤ßÀ°¦£©M­@¤ß«ü¾É»P»¡©ú~·P®¦(Áù°`)~~~

TOP

¦^´_ 4# n7822123
n¤j : ±z¦n!
¤£¦n·N«ä¡A°²³]"A"¤u§@ªí¤º®e¤£ÅÜ®É~
½Ð°Ý : ¯à«ö1¦¸°õ¦æÁä¡A°õ¦æ¦h­ÓCSVÀÉ®×¶Ü ?
¦pªG¥i¥H¡A½Ð°Ýµ{¦¡½X­n¦p¦ó¼W­×?
¦pªG¤£¥i¦æ¡A´N¥H¥Ø«e«ö1¦¸°õ¦æÁä°õ¦æ1­ÓCSVÀɮקY¥i¡C
ÁÂÁ±z

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2021-1-9 20:54 ½s¿è

¦^´_ 6# ziv976688

·w­Ë¡A§Ñ°O§A¥Dµ{¦¡ÁÙ¦b Dir·í¤¤¡AÁÙ¨S·j§¹©O

Dir ¤£¯à¥Î¤F¡A§ï¤@¤U¤U­±ªºµ{¦¡

­ì¥»


Sub ½Æ»sAªí¨ìÁ`Äý()
Á`Äý_Nm$ = Dir(Module1.NewName)
With Workbooks(Á`Äý_Nm)
    ThisWorkbook.Sheets("A").Copy After:=.Sheets(.Sheets.Count)
    .Sheets(1).Activate   '¦^¨ì¸ê®ÆÀÉ
End With
End Sub

Sub ©óÁ`Äý§R°£Aªí()
Application.DisplayAlerts = False
Á`Äý_Nm$ = Dir(Module1.NewName)
Workbooks(Á`Äý_Nm).Sheets("A").Delete
End Sub


§ï¬°

Sub ½Æ»sAªí¨ìÁ`Äý()
Á`Äý_Nm$ = Mid(Module1.NewName, InStrRev(Module1.NewName, "\") + 1)
With Workbooks(Á`Äý_Nm)
    ThisWorkbook.Sheets("A").Copy After:=.Sheets(.Sheets.Count)
    .Sheets(1).Activate   '¦^¨ì¸ê®ÆÀÉ
End With
End Sub

Sub ©óÁ`Äý§R°£Aªí()
Application.DisplayAlerts = False
Á`Äý_Nm$ = Mid(Module1.NewName, InStrRev(Module1.NewName, "\") + 1)
Workbooks(Á`Äý_Nm).Sheets("A").Delete
End Sub


¤Þ¥ÎA¤u§@ªí­Èªº¤½¦¡»yªk-OK2.rar (209.33 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-1-9 22:00 ½s¿è

¦^´_ 7# n7822123
n¤j : ±z¦n!
¥þOK¤F!
¸U¤À·P¿E±zªº¼ö¤ßÀ°¦£©M­@¤ß«ü¾É~¨ü´f¨}¦h~·P®¦¦A·P®¦~~~~~ ~~~

PS : °õ¦æ40­ÓÀÉ®×(¥þ³¡»Ý¨Dªº¤½¦¡³£©ñ¶i¥h~482¦C¤½¦¡)~¯Ó®É51¬í~¤]¤£ºâ«ÜºC~ÁÂÁ±z

TOP

Aªí¬J¬O¦@¥Îªº, ¼W­ÓAAAªí¨ú¤½¦¡¤Î­È, ª½±µ¶K¤W§Y¥i,
À³¤£¶·¨C­ÓÀɮ׳£¥[¸ü¤@¦¸¤½¦¡§a!

¤Þ¥ÎA¤u§@ªíªº¤½¦¡­È_01.rar (216.57 KB)

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2021-1-10 13:09 ½s¿è

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

ÁÙ¬O·Ç¤j¼F®`~~¤S§âµ{¦¡Â²¤Æ¤F~ ¡A µ{¦¡®Ä²v·|¦bUP

¦pªG§å¦¸°õ¦æ49­ÓÀɮסAAªí¤º®e³£¤£·|ÅÜ¡A¤½¦¡¤]¬O©T©wªº

¨ººâ¥X¨Óªº­È¤]¤£·|ÅÜ¡A½T¹ê¤£¥Îºâ¨º»ò¦h¦¸

¦b°j°é¥~ºâ¥X¨Ó¤@¦¸§Y¥i¡A¤§«á¨C­ÓÀɮ׳£¥u­n½Æ»s¸Ó­È~

¨º4­Ó¤½¦¡A~D¡A§Ú­ì¥»¤]·Q­n¹³·Ç¤j¨º¼Ë¦X¨Ö¼g¡A¥u§ï°Ï°ì½d³ò

¦ý¬O¦Ò¶q¨ì»Ý¨DªÌ¤£¾ÕªøVBA¡A©Ò¥H§Ú´NºÉ¶q¤£¥h°Ê¤F

µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD