Excel链接怎么查不出单元数据
zz421 2004-02-28 11:14:16 我程序中需要用Exce表格中单元数据来绘图,我对象变量,工作簿以及工作表变量都定义了,可是运行是怎么查出的数据全为0啊,请哪位大师指点一下.
Public appExl As Excel.Application
Public wksexl As Workbooks
Public wkexl As Workbook
Public shexl As Worksheet
Set appExl = CreateObject("excel.application")
Set wksexl = appExl.Workbooks
wksexl.Open App.Path & "\shujuku\AU.xls"
Set shexl = appExl.Worksheets(1)