|
练习练习
Sub 导出()
Dim rng As Range, wk As Workbook
Set d = CreateObject("scripting.dictionary")
Set fso = CreateObject("scripting.filesystemobject")
Application.ScreenUpdating = False
Application.DisplayAlerts = False
p = ThisWorkbook.Path & "\"
fso.copyfile p & ThisWorkbook.Name, p & "副本.xlsm"
Set wk = Workbooks.Open(p & "副本.xlsm")
With wk.Sheets(1)
arr = .UsedRange
For j = 1 To UBound(arr, 2)
If arr(3, j) = "" Then
d(j) = ""
End If
Next j
For Each k In d.keys
If rng Is Nothing Then
Set rng = Columns(k)
Else
Set rng = Union(rng, Columns(k))
End If
Next
rng.EntireColumn.Delete
wk.Save
wk.Close
End With
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub |
|