|
点击“登记应收账款”按钮,没有反应,还是还是什么状况。那我把代码给你:
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Dim wb As Workbook
On Error Resume Next
Set wb = Workbooks.Open(ThisWorkbook.Path & "\附件 应收账款及明细.xlsx") '注意文件名
ActiveWindow.Visible = False
For ysh = 4 To 65536
If Cells(ysh, 1) = "合计" Then Exit For
With wb.Sheets("" & Cells(ysh, 1) & "")
If .Name <> Cells(ysh, 1) Then
MsgBox "明细表中无 " & Cells(ysh, 1) & " ,忽略。", , "提示"
GoTo abc
End If
L = .Cells.Find("余额").Column
h = .Cells(65536, L).End(xlUp).Row
If IsNumeric(.Cells(h, L)) Then Cells(ysh, "k") = .Cells(h, L)
End With
abc: Next ysh
wb.Close False
Application.ScreenUpdating = True
End Sub
|
|