[AccessD] Excel Vlookup() question

Hi Arthur

You can use double quotes as well but as they are "inside" a set of outer double quotes, you would need to double the inside double quotes. I've always found that a bit confusing.
I don't think you need to do anything more but I'm no Excel guru.

/gustav

>>> fuller.artful at gmail.com 14-08-2007 17:59 >>>
Ok, I will do that. Just out of curiosity, why single quotes rather than
double? If there were no space, would I still need the quotes? Also, Do I
need to do anything special with the specific cell reference that is
argument 1?

Thanks, Gustav.
Arthur

On 8/14/07, Gustav Brock <Gustav at cactus.dk> wrote:
>
> 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)