var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: dlookup in excel vba....
Assuming i have this mdb:
and a sheet TEST where into A2 is:OI14006 is possible to use the table into mdb to return in B2: GERVASIO CRISTOFARO
IN effect i would want to use all in vba for excel.
Dim cn As Object, rs As Object
Dim myReturn As Long
Const dbfullname As String = "c:\DATA\user.mdb"
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" _
& dbfullname & ";" 'Create DB connection
Set rs = CreateObject("ADODB.Recordset")
peraps here the code for matching?
If Not .EOF Then Let myReturn = .fields(0)
.Close: Set rs = Nothing
cn.Close: Set cn = Nothing
Last edited by sal21; 03-28-06 at 03:06.
I haven't looked at the database sample.
However, if you have the connection and CommandText / SQL OK, what is the problem exactly?
Check the solution provided at JMT Forums (link in my post above)
Thanks shades. I'm not a registered user at the other site - hence can not access the solution posted.
Would appreciate if you could post the gist of the answer from the other forum.
If not, no worries. I won't lose any sleep over it.