|
本帖最后由 乐乐2006201506 于 2016-6-22 23:12 编辑
在下面代码中加入一段另存为的代码,保存路径“C:\Users\Administrator\Desktop\写入代码另存\花名册测试文件\”,而不是红色代码直接保存在原文件中。谢谢!
Sub test()
p = "C:\Users\Administrator\Desktop\写入代码另存\花名册测试文件\"
f = Dir(p & "*.xls")
Do While f <> ""
Workbooks.Open p & f
With ActiveWorkbook.VBProject.VBComponents("thisworkbook").CodeModule
.InsertLines 1, "sub test()"
.InsertLines 2, "msgbox ""just a test""" '双引号中的双引号,2个代表1个.
.InsertLines 3, "end sub"
End With
ActiveWorkbook.Close True
f = Dir
Loop
End Sub
乐乐2006201506 发表于 2016-6-22 20:37
如果能实现插入文件夹及子文件夹中所有工作簿则更好。
试试这个: - Sub test()
- p = "C:\Users\Administrator\Desktop\花名册测试文件"
- f = Dir(p & "*.xls")
- Do While f <> ""
- Workbooks.Open p & f
- With ActiveWorkbook.VBProject.VBComponents("thisworkbook").CodeModule
- .InsertLines 1, "sub test()"
- .InsertLines 2, "msgbox ""just a test""" '双引号中的双引号,2个代表1个.
- .InsertLines 3, "end sub"
- End With
- ActiveWorkbook.SaveAs Filename:=p & Replace(f, ".xls", ".xlsm"), FileFormat:=52
- ActiveWorkbook.Close True
- f = Dir
- Loop
- End Sub
复制代码
|
|