Prev: Combobox Vs Combobox
Next: Excel
From: ben on 15 Feb 2005 14:15
What is the proper syntax for using

application.worksheetfunction.vlookup(emb,"c:\lists\filename.xls"!sheet1.A1:AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open
From: Bob Phillips on 15 Feb 2005 15:14
application.worksheetfunction.vlookup(emb,workbooks("c:\lists\filename.xls")
..worksheets("sheet1").range("A1:AB300"),5,false)

don'tknow what emb is.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"ben" <ben(a)discussions.microsoft.com> wrote in message
news:3C411A8C-F036-48AF-BF53-5C463E1449B8(a)microsoft.com...
> What is the proper syntax for using
>
>
application.worksheetfunction.vlookup(emb,"c:\lists\filename.xls"!sheet1.A1:
AB300,5,false)
>
> Basically how do you use the worksheetfunction vlookup looking up in a
> different file, with the full path in case the file is not open


From: Tom Ogilvy on 15 Feb 2005 15:52
The file must be open:

application.worksheetfunction.vlookup(emb,Range("[filename.xls]sheet1!A1:AB3
00"),5,false)

--
Regards,
Tom Ogilvy


"ben" <ben(a)discussions.microsoft.com> wrote in message
news:3C411A8C-F036-48AF-BF53-5C463E1449B8(a)microsoft.com...
> What is the proper syntax for using
>
>
application.worksheetfunction.vlookup(emb,"c:\lists\filename.xls"!sheet1.A1:
AB300,5,false)
>
> Basically how do you use the worksheetfunction vlookup looking up in a
> different file, with the full path in case the file is not open


From: Tom Ogilvy on 15 Feb 2005 15:58
workbooks("c:\lists\filename.xls")

Come on Bob - No way!

--
Regards,
Tom Ogilvy

"Bob Phillips" <bob.phillips(a)notheretiscali.co.uk> wrote in message
news:uxaj6r5EFHA.2832(a)TK2MSFTNGP14.phx.gbl...
>
application.worksheetfunction.vlookup(emb,workbooks("c:\lists\filename.xls")
> .worksheets("sheet1").range("A1:AB300"),5,false)
>
> don'tknow what emb is.
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "ben" <ben(a)discussions.microsoft.com> wrote in message
> news:3C411A8C-F036-48AF-BF53-5C463E1449B8(a)microsoft.com...
> > What is the proper syntax for using
> >
> >
>
application.worksheetfunction.vlookup(emb,"c:\lists\filename.xls"!sheet1.A1:
> AB300,5,false)
> >
> > Basically how do you use the worksheetfunction vlookup looking up in a
> > different file, with the full path in case the file is not open
>
>


From: Tom Ogilvy on 15 Feb 2005 17:27
Whoops, forgot my smiley face <g>

Come on Bob - No way! ;-)

--
Regards,
Tom Ogilvy


"Tom Ogilvy" <twogilvy(a)msn.com> wrote in message
news:OeXVeE6EFHA.3596(a)TK2MSFTNGP12.phx.gbl...
> workbooks("c:\lists\filename.xls")
>
> Come on Bob - No way!
>
> --
> Regards,
> Tom Ogilvy
>
> "Bob Phillips" <bob.phillips(a)notheretiscali.co.uk> wrote in message
> news:uxaj6r5EFHA.2832(a)TK2MSFTNGP14.phx.gbl...
> >
>
application.worksheetfunction.vlookup(emb,workbooks("c:\lists\filename.xls")
> > .worksheets("sheet1").range("A1:AB300"),5,false)
> >
> > don'tknow what emb is.
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "ben" <ben(a)discussions.microsoft.com> wrote in message
> > news:3C411A8C-F036-48AF-BF53-5C463E1449B8(a)microsoft.com...
> > > What is the proper syntax for using
> > >
> > >
> >
>
application.worksheetfunction.vlookup(emb,"c:\lists\filename.xls"!sheet1.A1:
> > AB300,5,false)
> > >
> > > Basically how do you use the worksheetfunction vlookup looking up in a
> > > different file, with the full path in case the file is not open
> >
> >
>
>


 | 
Pages: 1
Prev: Combobox Vs Combobox
Next: Excel