[AccessD] Excel Vlookup() question

Hi Arthur

If so, in your code, wrap your filename in single quotes; you have a space inside the name.

/gustav

>>> fuller.artful at gmail.com 14-08-2007 17:43 >>>
Thanks for looking at this, Jim. That was just a typo on my part. In fact, I
don't think I expressed my problem accurately. When I use the second formula
directly in a worksheet, it works fine, but I cannot make it work in a
module and that's what I need to do. Something along the lines of

Dim x
x = VLOOKUP( $A6, "path_and_filename", relative_column, false)