Private Sub MnuInput_Click()
Rem 保存表格中的数据
Dim FileName As String '''''''''''将数据保存到Excel表里
Dim i As Integer
CommonDialog1.FileName = ""
CommonDialog1.Filter = "Excel 表|*.xls"
CommonDialog1.ShowOpen
FileName = CommonDialog1.FileName
If FileName = "" Then
Exit Sub
End If
Set xlApp = CreateObject("Excel.Application")
''Set xlBook = xlApp.Workbooks ''.Add ''添加新工作表
Set xlBook = xlApp.Workbooks.Open(FileName)
‘’’Set xlBook = xlApp.Workbooks.Open(“c:\lizi.xls”) ‘’’具体路径
Set xlSheet = xlBook.Worksheets(1) ''''''打开Excel表
xlSheet.Activate ''激活工作表
''Next Alfi
Next i
'''xlBook.SaveAs FileName
xlBook.RunAutoMacros (xlAutoClose) '''执行Excel关闭宏
xlBook.Close (True) '''''关闭Excel工作表
xlApp.Quit '''''''''关闭Excel工作本
Set xlApp = Nothing
End Sub