我这么写总是报错:
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlBook = xlApp.Workbooks.Open("*:\*\*.csv")
Set xlSheet = xlBook.Worksheets("sheet1")
lblIntensity1.Caption = xlBook.Worksheets("sheet1").Range("E2")
lblIntensity2.Caption = xlBook.Worksheets("sheet1").Range("E3")
lblIntensity3.Caption = xlBook.Worksheets("sheet1").Range("E4")
Set xlApp = Nothing
Set xlBook = Nothing
Set xlSheet = Nothing所报的错误是:Run_time error'9':
Subscript out of range.
Debug 指向:
Set xlSheet = xlBook.Worksheets("sheet1")
请问各位大侠*.csv 的EXcel表到底应该怎么引用?
用我写的这种方法引用*.xls 的Excel表就没有问题.
多谢各位了!!!!!
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlBook = xlApp.Workbooks.Open("*:\*\*.csv")
Set xlSheet = xlBook.Worksheets("sheet1")
lblIntensity1.Caption = xlBook.Worksheets("sheet1").Range("E2")
lblIntensity2.Caption = xlBook.Worksheets("sheet1").Range("E3")
lblIntensity3.Caption = xlBook.Worksheets("sheet1").Range("E4")
Set xlApp = Nothing
Set xlBook = Nothing
Set xlSheet = Nothing所报的错误是:Run_time error'9':
Subscript out of range.
Debug 指向:
Set xlSheet = xlBook.Worksheets("sheet1")
请问各位大侠*.csv 的EXcel表到底应该怎么引用?
用我写的这种方法引用*.xls 的Excel表就没有问题.
多谢各位了!!!!!
我自己用VB6.0编了一个程序,在自己的机器上运行的挺正常的,可到了别人的机器上运行时,到了从Excel表取数的那一步就会报错,说:内存出什么问题了.
用Microsoft Visual Studio 6.0 Tools 里的Package&Deployment Wizard做了一个安装程序也是这种情况.
这到底是怎么回事啊?
怎么让自己的程序在没有VB的机器上运行?
那位大侠能指导一下?
不胜感激!!!
网上的例子不是很好的,看office2000(最好是xp)的帮助最有效了,但是帮助默认安装没有装上。
Dim Ex As Object Set Ex = CreateObject("excel.sheet")
Ex.Sheets(1).Name = "人员"
Ex.Sheets(1).Activate
Ex.ActiveSheet.Cells.Font.Size = 10
Ex.ActiveSheet.Columns("a:i").AutoFit
Ex.ActiveSheet.Cells.HorizontalAlignment = xlVAlignCenter
Ex.ActiveSheet.Range("a1").Value = "人员1"
Ex.ActiveSheet.Range("a2").Value = "姓名" Ex.SaveAs "c:\111.xls"
Ex.Application.Quit
Set Ex = Nothing
用readtxtfile 的readline一行一行读
用Split(strLine,",")分割成数组来处理,要快得多。用VS installer来打包试试!