sFileName = App.path + "\temp*.xls"
sTemp = Dir(sFileName)
Do Until sTemp = ""
On Error Resume Next
Kill App.path + "\" + sTemp
On Error GoTo 0
sTemp = Dir
Loop
先用上面一段程序把原程序的删除
sTemp = Dir(sFileName)
Do Until sTemp = ""
On Error Resume Next
Kill App.path + "\" + sTemp
On Error GoTo 0
sTemp = Dir
Loop
先用上面一段程序把原程序的删除
如下
XLAPP.Workbooks(i).Saved = True /FALSE 判断文件是否需要保存
XLAPP.Workbooks(I).SaveAs 文件名
如果你之打开一个文件的话 I 的值为1就行了