Hi all, is the above possible ? If yes could i get some help please ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Simple enough Les, just like so

=VLOOKUP("b",'C:\Documents and
Settings\Bob\Desktop\[Def_sample.xls]Sheet2'!$A$1:$B$6,2,FALSE)

You shoukld be able top work it out to suit your workbook.

--

HTH

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


"Les Stout" wrote in message
...
Hi all, is the above possible ? If yes could i get some help please ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Thanks a million Bob.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Bob gave you a good answer for using in a worksheet cell.

You can't do that in VBA code however. You would need to have your code
put the formula in a cell and then get the value it returns.

there are other methods, but none that are as direct or as fast.

John Walkenbach's site
http://www.j-walk.com/ss/excel/tips/tip82.htm
A VBA Function to Get a Value From a Closed File

You can modify the formula to do a Vlookup

Ron de Bruin's site
http://www.rondebruin.nl/ado.htm
Copy a range from closed workbooks (ADO)

--
Regards,
Tom Ogilvy


"Les Stout" wrote in message
...
Thanks a million Bob.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Tom.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***