Dim XLApp As New Excel.Application Dim XLWorkBook As New Excel.Workbook Dim XLWorkSheet As New Excel.Worksheet Set XLApp = CreateObject("Excel.Application") Set XLWorkBook = XLApp.Workbooks.Add Set XLWorkSheet = XLWorkBook.Worksheets(1)XLApp.Visible = TrueXLWorkSheet.Cells(i + 1, j + 1).Value = Format(xxx, "#0.00")xxx就是你要写的内容,需要引用Excel
如果表格早有的话 Dim XLApp As New Excel.Application Dim XLWorkBook As New Excel.Workbook Dim XLWorkSheet As New Excel.Worksheet Set xlBook = XlApp.Workbooks.Open(App.Path & "\123.xls") Set XLWorkBook = XLApp.Workbooks.Add Set XLWorkSheet = XLWorkBook.Worksheets(1) XLApp.Visible = True XLWorkSheet.Cells(1, 1).Value = Format(xxx, "#0.00")如果表格有密码,可以这样: Set xlBook = XlApp.Workbooks.Open(App.Path & "\123.xls", , , , 密码)
Dim XLApp As New Excel.Application Dim XLWorkBook As New Excel.Workbook Dim XLWorkSheet As New Excel.Worksheet 以上放在通用里 Set XLWorkBook = XlApp.Workbooks.Open(App.Path & "\123.xls") Set XLWorkBook = XLApp.Workbooks.Add Set XLWorkSheet = XLWorkBook.Worksheets(1) XLApp.Visible = True 以上放在Form_Load中 XLWorkSheet.Cells(1, 1).Value = Format(Dynamic_Func, "#0.00") 以上放在Timer里 要在工程->引用 中选择Microsoft Excel ...
Dim XLWorkBook As New Excel.Workbook
Dim XLWorkSheet As New Excel.Worksheet
Set XLApp = CreateObject("Excel.Application")
Set XLWorkBook = XLApp.Workbooks.Add
Set XLWorkSheet = XLWorkBook.Worksheets(1)XLApp.Visible = TrueXLWorkSheet.Cells(i + 1, j + 1).Value = Format(xxx, "#0.00")xxx就是你要写的内容,需要引用Excel
Dim XLApp As New Excel.Application
Dim XLWorkBook As New Excel.Workbook
Dim XLWorkSheet As New Excel.Worksheet
Set xlBook = XlApp.Workbooks.Open(App.Path & "\123.xls")
Set XLWorkBook = XLApp.Workbooks.Add
Set XLWorkSheet = XLWorkBook.Worksheets(1)
XLApp.Visible = True
XLWorkSheet.Cells(1, 1).Value = Format(xxx, "#0.00")如果表格有密码,可以这样:
Set xlBook = XlApp.Workbooks.Open(App.Path & "\123.xls", , , , 密码)
比如说这个函数叫做Dynamic_Func(),每次调用他返回的值都不一样
这样在excel里 = Dynamic_Func()的值并不变化...
调用Calculate也不行...
Dim XLWorkBook As New Excel.Workbook
Dim XLWorkSheet As New Excel.Worksheet
以上放在通用里
Set XLWorkBook = XlApp.Workbooks.Open(App.Path & "\123.xls")
Set XLWorkBook = XLApp.Workbooks.Add
Set XLWorkSheet = XLWorkBook.Worksheets(1)
XLApp.Visible = True
以上放在Form_Load中
XLWorkSheet.Cells(1, 1).Value = Format(Dynamic_Func, "#0.00")
以上放在Timer里
要在工程->引用 中选择Microsoft Excel ...
不知道是不是这问题