|
各位老师 请教如何修改下面的代码 以实现将查询出来的结果生成一个下拉列表,同时选择下拉列表当中的选项还能触发新的数据查询,并把结果显示出来呢??
Public Function QueryToCell(sql$, Optional rng As Excel.Range, _
Optional ByVal sqlInfo$ = "this", _
Optional withHeader As Boolean = True)
sqlInfo = GetSQLInfo(sqlInfo)
If cnn Is Nothing Then Set cnn = CreateObject("ADODB.Connection")
If rst Is Nothing Then Set rst = CreateObject("ADODB.Recordset")
cnn.Open sqlInfo
rst.Open sql, cnn
Set rng = rng.Cells(1, 1)
If withHeader = True Then
Dim i As Long
For i = 0 To rst.Fields.Count - 1
rng.Offset(0, i).Value = rst.Fields(i).Name
Next
rng.Offset(1, 0).CopyFromRecordset rst
Else
rng.CopyFromRecordset rst
End If
rst.Close
cnn.Close
End Function
|
|