|
- Sub rtian()
- On Error Resume Next
- fp = ThisWorkbook.Path & ""
- mf = Dir(fp & "*.csv")
- Do While mf <> ""
- If Sheets(Split(mf, ".")(0)) Is Nothing Then
- Sheets.Add(after:=ActiveSheet).Name = Split(mf, ".")(0)
- With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & fp & mf, Destination:=Range("$A$1"))
- .Name = Split(mf, ".")(0)
- .FieldNames = True
- .TextFileCommaDelimiter = True
- .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
- .Refresh BackgroundQuery:=False
- End With
- End If
- mf = Dir
- Loop
- End Sub
复制代码- Option Explicit
- Sub czeroone()
- Dim wsSum As Worksheet
- Dim ws As Worksheet
- Dim i As Integer
- Set wsSum = Worksheets("C01")
- wsSum.Range("a3:c" & wsSum.Cells(Rows.Count, 1).End(3).Row).Clear
- i = 3
- Application.ScreenUpdating = False
- For Each ws In Worksheets
- If ws.Name <> wsSum.Name And IsDate(ws.Name) Then
- wsSum.Cells(i, 1) = ws.Name
- wsSum.Cells(i, 2) = Format(ws.Name, "yyyy/mm/dd")
- wsSum.Cells(i, 3) = WeekdayName(Weekday(Format(ws.Name, "yyyy/mm/dd"), vbMonday), False, vbMonday)
- i = i + 1
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 我想把这两个宏结合成一个宏,然后第一个宏先运行,运行完了再运行第二个宏。如果可以的话,应该把代码合在一起?另外的话,类似第二个宏的还有很多个,例如,第三个,第四个宏是类似第二个宏的,我要实现的是要那么多宏一起运行。
如果这些宏的代码不能放在一起的话,能不能编写一个程序运行所有的宏?但是前提是,第一个宏必须是第一步运行的。
如果上面两个方法都不行的话,能不能把每个宏都设置一个按钮,然后编写一个程序,单击所有的按钮
|
|