|
上传附件,是全修改过了,意义不大,把代码上传
Sub test()
Dim p, f, s(), k, mfc$, confirm, indata
mfc = InputBox("输入替换内容" & Chr(10) & "输入格式" _
& Chr(1) & "B8等单元格")
MsgBox mfc & "请确认"
confirm = InputBox("y")
If confirm = "y" Then indata = mfc
p = ThisWorkbook.Path & "\"
f = Dir(p & "*.xlsx")
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Do While Len(f)
If f <> ThisWorkbook.Name Then
k = k + 1
ReDim Preserve s(1 To k)
With Workbooks.Open(p & f)
With Sheets("1.8")
.Activate
s(k) = Replace(.Range("c7").Formula, "B7", mfc)
.Range("c7").Formula = s(k)
End With
.Save
.Close (True)
End With
End If
f = Dir
Loop
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub |
评分
-
1
查看全部评分
-
|