Hi all, is the above possible ? If yes could i get some help please ?
Les Stout
*** Sent via Developersdex http://www.developersdex.com ***
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:%[email protected]...
> Thanks a million Bob.
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***
Thanks Tom.
Les Stout
*** Sent via Developersdex http://www.developersdex.com ***
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks