[AccessD] Excel Vlookup() question

Arthur Fuller fuller.artful at gmail.com
Tue Aug 14 10:59:49 CDT 2007


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)
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list