VB in the tree

October 21, 2007 9:39 PM

vbFilter: Outputting results to a treeview object in Excel.

Currently I am working on a script that will query an access DB and look for the first 4 users that's dates are less than 5 days of the current date which is shown below.

The current script is running in Excel's VB compiler. The one thing I want to do is output the results to a treeview object in excel.

Private Sub UserForm_Initialize()
Label1.Caption = Date
On Error GoTo Error
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\SAIO\Users.mdb"
Dim i As Integer
rst.Open "SELECT [ntlogin] FROM [scon] GROUP BY [ntlogin]" & _
" HAVING (Max([date]) <>


-- Feel free to probe me for more information if you need.

posted by dnthomps to computers & internet (1 comment total)

It did not like the code. Maybe I am missing something (code tag?).

Anyways, here is a txt file.
posted by dnthomps at 9:44 PM on October 21, 2007