你这个界面做的实在是太好了!超出我的想象,实在是高!!! 不过我在运行时提示:运行时错误9 下标越界出错,不知道是怎么回事? Set sqladodb = CreateObject("adodb.connection") str_key = UserForm1.txt_key.Text str_rout = ThisWorkbook.Path sum_cout = Workbooks("定额库").Sheets(data_name).UsedRange.Rows.Count str_sql = "SELECT 定额编号,定额名称,单位 FROM[" & data_name & "$A1:C" & sum_cout & "] where " & data_filds & " like'%" & str_key & "%'" sqladodb.Open "provider=microsoft.jet.oledb.4.0;extended properties='excel 8.0;imex=1';data source=" & str_rout & "\定额库.xls" 'sqladodb.Open Set data_sort = sqladodb.Execute(str_sql) If data_sort.EOF = True Then Exit Sub zs = data_sort.GetRows For i = 0 To UBound(zs, 2) '添加记录 Set ITM = ListView1.ListItems.Add() ITM.Text = "" & zs(0, i) ITM.SubItems(1) = "" & zs(1, i) ITM.SubItems(2) = "" & zs(2, i) Next i sqladodb.Close End Sub
[此贴子已经被作者于2008-1-11 11:16:06编辑过] |