用vba 新建命名工作簿

2024-12-15 10:45:49
推荐回答(2个)
回答1:

1
2
3
4
5
6
7

Sub test()
Dim iFile As String
iFile = ThisWorkbook.Path & "\" & "技术质量.xls"
Workbooks.Add
ActiveWorkbook.SaveAs iFile, True
MsgBox "新建Excel工作薄完成," & vbCrLf & "完整路径及名称:" & vbCrLf & iFile
End Sub

回答2:

录制宏改一改就行了