- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
![2017 Âû¦~¥þ¶Ô¼ú³¹ 2017 Âû¦~¥þ¶Ô¼ú³¹](images/common/ji.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![2012Às¦~¥þ¶Ô¼ú³¹ 2012Às¦~¥þ¶Ô¼ú³¹](images/common/long.gif) ![½×¾Â°^Äm¾±³¹ ½×¾Â°^Äm¾±³¹](images/common/medal5.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2011¨ß¦~¥þ¶Ô¼ú³¹ 2011¨ß¦~¥þ¶Ô¼ú³¹](images/common/tu.gif)
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-6-4 12:06 ½s¿è
¦^´_ 1# luke
¸Õ¸Õ¬Ý- Option Explicit
- Sub Ex()
- Dim Ar, E As Variant, xi As Integer, xlCsv As String, xlPath As String
- Dim Sh(1 To 2) As Worksheet
- xlPath = ThisWorkbook.Path & "\" '->קאּ¥¿½TªºÀɮ׸ô®|
- Set Sh(1) = Workbooks.Open(xlPath & "test21.csv").Sheets(1)
- Set Sh(2) = Sh(1).Parent.Sheets.Add
- Sh(1).Cells.Copy Sh(2).Cells(1) '½Æ»s test21.csv ªº¸ê®Æ '
- xlCsv = Dir(xlPath & "*.Csv") '´M§ä *.CsvÀÉ®×
- Do While xlCsv <> "" And LCase(xlCsv) <> "test21.csv"
- With Workbooks.Open(xlPath & xlCsv).Sheets(1)
- Sh(2).Cells(Rows.Count, 1).End(xlUp).Offset(2) = "[*" & xlCsv & "*]"
- .[a1].CurrentRegion.Copy Sh(2).Cells(Rows.Count, 1).End(xlUp).Offset(1)
- .Parent.Close 0
- End With
- xlCsv = Dir
- Loop
- With Sh(2)
- .Activate
- For Each E In ActiveWorkbook.Names
- '§R°£©Ò¦³¤w©w¸qªº¦WºÙ ¥HÁקK : ©w¸qªº¦WºÙ¤¤¦³¤£¦bªº *.Csv
- E.Delete
- Next
- '*** ³B¸Ì ¤w¶×¤Jªº *.Csv *********
- Ar = .Range("a:a").Value
- .Range("a:a").Replace "[*.*]", "=1/0" '[*.Csv] ´À¥N¬°¿ù»~È
- .Range("a:a").SpecialCells(xlCellTypeFormulas, xlErrors).Select '¿ï¾Ü¦³¿ù»~ȪºÀx¦s®æ
- .Range("a:a").Value = Ar '½Æìì¨ÓªºÈ
- For Each E In Selection
- E.CurrentRegion.Name = Replace(Replace(E, "*]", ""), "[*", "")
- '¨C¤@Àx¦s®æªº©µ¦ù½d³ò: ©w¸q¦WºÙ *.Csv
- Next
- '****************************
- Sh(1).Cells.Clear 'test21.csv.Sheets(1) :²M°£©Ò¦³¸ê®Æ «·s¶×¤J±Æ§Ç«áªº*.Csv
- For Each E In ActiveWorkbook.Names '©w¸q¦WºÙ :·|¦Û°Ê±Æ§Ç¦WºÙ
- xi = Sh(1).Cells(Rows.Count, 1).End(xlUp).Row
- xi = IIf(xi = 1, 1, xi + 2)
- Range(E.Name).Copy Sh(1).Cells(xi, 1)
- xi = Sh(1).Cells(Rows.Count, 1).End(xlUp).Row
- Sh(1).Cells(xi + 2, 1) = "[*div*]"
- Next
- Application.DisplayAlerts = False
- .Delete '§R°£¤u§@ªí
- Application.DisplayAlerts = True
- End With
- '***** ´ú¸Õ ¦¨¥\«á ¸Ñ°£µù¸Ñ ¥i¦sÀÉ
- 'Sh(1).Parent.Close True
- End Sub
½Æ»s¥N½X |
|