Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet As Excel.Worksheet Dim i As IntegerPrivate Sub Command1_Click() Set xlapp = CreateObject("Excel.Application") '创建EXCEL对象-------->>>>(这句变成黄色的啦) Set xlbook = xlapp.Workbooks.Add() Set xlsheet = xlbook.Worksheets("Sheet1") '设置活动工作表 xlapp.Visible = False xlsheet.Cells(5, 5) = "试验" '向第五行第五列写入该数据 xlbook.SaveAs "d:\测温数据表.xls" '另存文件 xlbook.Close '关闭工作簿 Set xlbook = Nothing '从内存中清除 xlapp.Quit '关闭excel Set xlapp = Nothing '从内存中清除 End SubPrivate Sub Command2_Click() Static i As Integer i = i + 1 Set xlapp = CreateObject("Excel.Application") Set xlbook = xlapp.Workbooks.Open("d:\测温数据表.xls") Set xlsheet = xlbook.Worksheets("sheet1") If xlsheet.Cells(i, 1) = "" Then xlsheet.Cells(i, 1) = Val(Text1.Text) + Val(Text2.Text) End If xlbook.Close (True) xlapp.Quit '结束EXCEL对象 Set xlapp = Nothing '释放xlApp对象 End Sub我引用了那个excel控件,不知道为什么不好使
rundll32.exe advpack.dll /DelNodeRunDLL32 %systemroot%\System32\dacui.dll
rundll32.exe advpack.dll /DelNodeRunDLL32 %systemroot%\Catroot\icatalog.mdb
regsvr32 /s comcat.dll
regsvr32 /s asctrls.ocx
regsvr32 /s oleaut32.dll
regsvr32 /s shdocvw.dll /I
regsvr32 /s shdocvw.dll
regsvr32 /s browseui.dll
regsvr32 /s browseui.dll /I
regsvr32 /s msrating.dll
regsvr32 /s mlang.dll
regsvr32 /s hlink.dll
regsvr32 /s mshtml.dll
regsvr32 /s mshtmled.dll
regsvr32 /s urlmon.dll
regsvr32 /s plugin.ocx
regsvr32 /s sendmail.dll
regsvr32 /s mshtml.dll /i
regsvr32 /s scrobj.dll
regsvr32 /s corpol.dll
regsvr32 /s jscript.dll
regsvr32 /s msxml.dll
regsvr32 /s imgutil.dll
regsvr32 /s cryptext.dll
regsvr32 /s inseng.dll
regsvr32 /s iesetup.dll /i
regsvr32 /s cryptdlg.dll
regsvr32 /s actxprxy.dll
regsvr32 /s dispex.dll
regsvr32 /s occache.dll
regsvr32 /s iepeers.dll
regsvr32 /s urlmon.dll /i
regsvr32 /s cdfview.dll
regsvr32 /s webcheck.dll
regsvr32 /s mobsync.dll
regsvr32 /s pngfilt.dll
regsvr32 /s licmgr10.dll
regsvr32 /s hhctrl.ocx
regsvr32 /s inetcfg.dll
regsvr32 /s trialoc.dll
regsvr32 /s tdc.ocx
regsvr32 /s MSR2C.DLL
regsvr32 /s msident.dll
regsvr32 /s msieftp.dll
regsvr32 /s xmsconf.ocx
regsvr32 /s ils.dll
regsvr32 /s msoeacct.dll
regsvr32 /s wab32.dll
regsvr32 /s wabimp.dll
regsvr32 /s wabfind.dll
regsvr32 /s oemiglib.dll
regsvr32 /s directdb.dll
regsvr32 /s inetcomm.dll
regsvr32 /s msoe.dll
regsvr32 /s oeimport.dll
regsvr32 /s msdxm.ocx
regsvr32 /s dxmasf.dll
regsvr32 /s laprxy.dll
regsvr32 /s l3codecx.ax
regsvr32 /s acelpdec.ax
regsvr32 /s mpg4ds32.ax
regsvr32 /s danim.dll
regsvr32 /s Daxctle.ocx
regsvr32 /s lmrt.dll
regsvr32 /s datime.dll
regsvr32 /s dxtrans.dll
regsvr32 /s dxtmsft.dll
regsvr32 /s wshom.ocx
regsvr32 /s wshext.dll
regsvr32 /s vbscript.dll
regsvr32 /s scrrun.dll mstinit.exe /setup
regsvr32 /s msnsspc.dll /SspcCreateSspiReg
regsvr32 /s msapsspc.dll /SspcCreateSspiReg
echo.
echo.
echo 修复成功!任意键退出!
pause>nul
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As IntegerPrivate Sub Command1_Click()
Set xlapp = CreateObject("Excel.Application") '创建EXCEL对象-------->>>>(这句变成黄色的啦)
Set xlbook = xlapp.Workbooks.Add()
Set xlsheet = xlbook.Worksheets("Sheet1") '设置活动工作表
xlapp.Visible = False
xlsheet.Cells(5, 5) = "试验" '向第五行第五列写入该数据
xlbook.SaveAs "d:\测温数据表.xls" '另存文件
xlbook.Close '关闭工作簿
Set xlbook = Nothing '从内存中清除
xlapp.Quit '关闭excel
Set xlapp = Nothing '从内存中清除
End SubPrivate Sub Command2_Click()
Static i As Integer
i = i + 1
Set xlapp = CreateObject("Excel.Application")
Set xlbook = xlapp.Workbooks.Open("d:\测温数据表.xls")
Set xlsheet = xlbook.Worksheets("sheet1")
If xlsheet.Cells(i, 1) = "" Then
xlsheet.Cells(i, 1) = Val(Text1.Text) + Val(Text2.Text)
End If
xlbook.Close (True)
xlapp.Quit '结束EXCEL对象
Set xlapp = Nothing '释放xlApp对象
End Sub我引用了那个excel控件,不知道为什么不好使
为什么呢??啊~~~~~
http://www.orsoon.com/article/article_21125.html
我看了你代码,也在我的电脑上做了测试,能通过测试.根据我的经验,很可以是EXCEL的dll受损.
将你的程序在另一台装有EXCEL的电脑上如能运行,就证明判断正确.一般需重装OFFIEC