當目錄里沒有a.xls文件,則創建。
但用下列語句.quit時會提示保存對話框。我的意思就是不要出現那個對個框而直接保存為a.xls。不知有什麼方法?
Dim appexcel As New Excel.Application
Dim workspc As Workbook
Dim worksh As Excel.Worksheet
Set workspc = appexcel.Workbooks.Add
Set worksh = workspc.Worksheets.Add
worksh.Cells(1, 1) = "MFG中料號"
worksh.Cells(1, 2) = "料號描述"
worksh.Cells(1, 3) = "原料"
worksh.Cells(1, 4) = "工單ID"
worksh.Cells(1, 5) = "工單"
worksh.Cells(1, 6) = "工單ID需求個數"
worksh.Cells(1, 7) = "供應商"
worksh.Cells(1, 8) = "產品組"
worksh.Cells(1, 9) = "日期"
appexcel.Quit
但用下列語句.quit時會提示保存對話框。我的意思就是不要出現那個對個框而直接保存為a.xls。不知有什麼方法?
Dim appexcel As New Excel.Application
Dim workspc As Workbook
Dim worksh As Excel.Worksheet
Set workspc = appexcel.Workbooks.Add
Set worksh = workspc.Worksheets.Add
worksh.Cells(1, 1) = "MFG中料號"
worksh.Cells(1, 2) = "料號描述"
worksh.Cells(1, 3) = "原料"
worksh.Cells(1, 4) = "工單ID"
worksh.Cells(1, 5) = "工單"
worksh.Cells(1, 6) = "工單ID需求個數"
worksh.Cells(1, 7) = "供應商"
worksh.Cells(1, 8) = "產品組"
worksh.Cells(1, 9) = "日期"
appexcel.Quit
解决方案 »
- 高手帮我看下这代码转换字符有没有错?怎么老显不出来呀?
- DataGrid控件的刷新问题
- 如何选择DataGrid中某一个单元格?
- 在WORD中如何编写这样的宏,在某一范围内输入文字!/急,详情请进
- 在 win2000 中使用 DCOM(COM+ Win2003) 的问题
- 各位高人谈谈ObjPtr是干什么用的!!
- 我有一个局域聊天程序?有谁要,发邮件给我?
- 各位高手,低手我今天在这里有一个关于算法的问题想问,这个问题是我在写程序时遇到的。很棘手,望知解的高手请速给小弟一个解法。本人是
- VFP 问题:
- 关于MSflexgrid和txtbox查询联动的问题!请高手看一下!
- 如何在VB中設置excel的cell中的文字顏色呢?
- 一个NTService的问题,帮忙看看
appexcel.Quit