发表于:2006/2/12 17:46:00
#0楼
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim objExcelApp
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Visible = True
ObjExcelApp.Workbooks.Open"c:\Documents and Settings\zhongguoliang\My Documents\ExcellExample.xls"
objExcelApp.Cells(4,3).Value = ScreenItems("IOField1").OutputValue
objExcelApp.ActiveWorkbooks.Close
objExcelApp.Quit
Set objExcelApp = Nothing
End Sub
objExcelApp.Cells(4,3).Value = ScreenItems("IOField1").OutputValue是啥意思?
能在表格中看到IOField1中的数据吗?
Dim objExcelApp
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Visible = True
ObjExcelApp.Workbooks.Open"c:\Documents and Settings\zhongguoliang\My Documents\ExcellExample.xls"
objExcelApp.Cells(4,3).Value = ScreenItems("IOField1").OutputValue
objExcelApp.ActiveWorkbooks.Close
objExcelApp.Quit
Set objExcelApp = Nothing
End Sub
objExcelApp.Cells(4,3).Value = ScreenItems("IOField1").OutputValue是啥意思?
能在表格中看到IOField1中的数据吗?
zhong