Advertisement
Advertisement
| 05.23.2008 at 11:26AM PDT, ID: 23428516 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: |
Function delrows()
Dim xlApp As Excel.Application
Dim xlWb As Excel.Workbook
Dim xlWs As Excel.Worksheet
Dim strXLFile As String
Dim i As Integer
strXLFile = "i:\report.xls"
Set xlApp = CreateObject("Excel.Application")
Set xlWb = xlApp.Workbooks.Open(strXLFile)
Set xlWs = xlWb.Worksheets("Report")
xlWs.Range("A2").Select
i = 1
Do Until i >= xlWs.Cells(65536, "A").End(xlUp).Row
If (Trim(ActiveCell.Value) = "") Then
xlWs.Rows(i).Delete
xlWs.Cells(i, 1).Select
Else
ActiveCell.Offset(1, 0).Select
i = i + 1
End If
Loop
xlWs.Range("A2").Select
xlWb.Save
Set xlWs = Nothing
Set xlWb = Nothing
xlApp.Quit
Set xlApp = Nothing
End Function
|