如何提取指定表格中单元格的值

来源:百度知道 编辑:UC知道 时间:2024/05/12 17:46:29
使用VBA如下代码,关闭工作薄后在桌面出现一个对话框“现在可以编辑09报销订。XLS,单击读-写按钮可以打开此文件进行编辑”请问如何不让此对话框显示,

Sub 提取报价单号值()

'声明Excel相关
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Set xlApp = New Excel.Application
'获取指定excel文件
Set xlBook = xlApp.Workbooks.Open("C:\Documents and Settings\DAVID\桌面\09报销订.xls")

Dim sheet As Excel.Worksheet
'获取指定sheet
Set sheet = xlBook.Worksheets(19)

Dim aa As String
Dim bb As String
Dim cc As String
Dim dd As String
Dim ee As String
Dim ff As String
Dim gg As String

'获取指定单元格的内容
aa = sheet.Cells(3, 1)
bb = sheet.Cells(3, 2)
cc = sheet.Cells(3, 3)
dd = sheet.Cells(3, 4)
ee = sheet.Cells(3, 5)
ff = sheet.Cells(3, 6)
gg = sheet.Cells(3, 7)
'内容显示
Sheets("编号汇总").Select
Cells(3, 9) = aa

问题在这里:
Set xlBook = xlApp.Workbooks.Open("C:\Documents and Settings\DAVID\桌面\09报销订.xls")

原本你就打开这个文件了
程序里又打开了一遍,
Set xlBook = Workbooks("报销订.xls")