|
有个表格,有900列,现在需要每三列的数据提出,形成一个新的表格,保存为CSV格式的。也就是最后生成300个CSV格式的文件。
例子中是9列的表格,现在希望能生成三个表格,分别是文件名一班,二班,三班。CSV格式。
新人,请高手指点。多谢!
之前没有附件重发。
- Sub demo()
- Dim irow As Long, icol As Long, ar, str As String, i As Long, mybook As Workbook
- Application.ScreenUpdating = False
- irow = Sheet1.Cells(Rows.Count, 1).End(3).Row
- icol = Sheet1.Cells(2, Columns.Count).End(1).Column
- For i = 1 To icol Step 3
- ar = Range(Cells(1, i), Cells(irow, i + 2))
- str = Cells(1, i)
- Set mybook = Workbooks.Add
- With mybook
- ActiveSheet.Range("a1").Resize(UBound(ar), 3) = ar
- .SaveAs Filename:=ThisWorkbook.Path & "" & str, FileFormat:=xlCSV
- .Close (False)
- End With
- Next
- Application.ScreenUpdating = False
- End Sub
复制代码附件楼下
|
|