用vba写了一段程序,对sheet1中的单元格进行修改
修改完成后怎么保存、关闭文件?Dim exwork As Excel.Workbook
Dim exsheet As Excel.Worksheet
dim file_name as string
file_name="d:\1234.xls"
.
.
.
.
exwork.SaveAs file_name
exwork.close有错误,希望高手指点啊!
修改完成后怎么保存、关闭文件?Dim exwork As Excel.Workbook
Dim exsheet As Excel.Worksheet
dim file_name as string
file_name="d:\1234.xls"
.
.
.
.
exwork.SaveAs file_name
exwork.close有错误,希望高手指点啊!
exwork.Close True就行了,保存修改,然后关闭。