Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim sheet As Worksheet
' Open the destination Excel workbook.
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open("D:\Book1.xls")
xlApp.Visible = True
Set sheet = xlApp.Worksheets("Sheet1")
Range("A3").Select
ActiveCell.FormulaR1C1 = "购货方:" & Text1(0).Text
Range("D3").Select
ActiveCell.FormulaR1C1 = "供货方:" & Text1(10).Text
xlApp.Visible = False
' Clean up everything.
xlBook.SaveAs "c:\v.xls"
xlBook.Close False
xlApp.Quit
Set xlBook = Nothing
Set xlApp = Nothing这样处理,结果在进程里EXECL就关不掉了,求教
Dim xlBook As Excel.Workbook
Dim sheet As Worksheet
' Open the destination Excel workbook.
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open("D:\Book1.xls")
xlApp.Visible = True
Set sheet = xlApp.Worksheets("Sheet1")
Range("A3").Select
ActiveCell.FormulaR1C1 = "购货方:" & Text1(0).Text
Range("D3").Select
ActiveCell.FormulaR1C1 = "供货方:" & Text1(10).Text
xlApp.Visible = False
' Clean up everything.
xlBook.SaveAs "c:\v.xls"
xlBook.Close False
xlApp.Quit
Set xlBook = Nothing
Set xlApp = Nothing这样处理,结果在进程里EXECL就关不掉了,求教
解决方案 »
- internet transfer控件的问题
- VB能否传递自定义类型(自定义Type类型的传递问题)?
- 急需一个可以支持选择多文件的模块 谢谢 特别着急 !!
- 怎样检测系统是否安装了打印机?
- Picture控件画图问题
- 怎么实现发票打印?
- 请教如何关闭监视器(无信号输入)◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎◎
- 怎样在VB中调用Access中的窗体
- sql查询数据库中时间字段的问题!
- 一个老问题:SmartMenuXP控件(一个OfficeXP的菜单控件),的中文显示问题
- 对付天文数字运算有没有什么办法
- VB中,动态给COMBOBOX添加内容,内容是一个表的字段,方法知道了,但一个窗体中有2个COMBOBOX时,2个数据表取数据,第二个没反应,请指点
Set xlapp = CreateObject("Excel.Application") '创建EXCEL应用类
xlapp.Visible = True '设置EXCEL可见
Set xlbook = xlapp.Workbooks.Open("D:\vb\mode\test.xls") '打开EXCEL工作簿
Dim xR As Range
Dim intFreeFile As Integer
intFreeFile = FreeFileSql = "select * from product "
Set xlsheet = xlbook.Worksheets(1) '打开EXCEL工作表
xlsheet.Activate
conn.Open ConnectString
rs.Open Sql, conn, 1, 1
i = 2
Do While Not rs.EOF
newsortid = rs("id")
newsortname = rs("englishname")
xlsheet.Cells(i, 1) = newsortname
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothingxlapp.Worksheets.PrintPreview
xlapp.DisplayAlerts = False
xlsheet.SaveAs FileName:="d:\mode\xls\" & Date & ".xls"
MsgBox "已成功导出到D盘mode文件夹内!", vbExclamation + vbOKOnly, "导出成功"
xlapp.Quit
Set xlapp = Nothing