assuming i have this code, is possible to use this vlookup withnthe adta
into mdb access?...

old scenario:
Private Sub TextBox25_Change()
Dim CODICE As Integer
Select Case Me.TextBox25
Case ""
Me.TextBox4 = ""
Case 1 To 8
CODICE = Val(Me.TextBox25)
Me.TextBox4 = Application.WorksheetFunction.VLookup _
(CODICE, Worksheets("TABELLA").Range("Q2:R9"), 2, False)
Case Else
Call MULTI_LINE_BOX
End Select
End Sub


new scenario:
Inested column Q and R in excel i have created a mdb into:

\\my server\myserverdir\USER.MDB

and into this mdb have inserte a table USER_NAME with:

Field1(with the same data of column R)
Field2(with the same data of column Q)

is possible now to make a vlookup?

EXAMPLE:
Filed1 Field2
OI14006 PPPPPPPPPP
OI15535 GGGGGGGGGGGG
OI15795 HHHHHHHHHHHHH
OI16135 HDSFDDFDFD
OI16696 DFFDFDFDSFD
OI16780 EREREWERERWER
OI16821 AAAADSDASDAD


+-------------------------------------------------------------------+
|Filename: USER.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4530 |
+-------------------------------------------------------------------+

--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=526768