vlookup from VBA on a closed workbook
 

Hello

Is there a way to use Vlookup from vba code to get data from a close
file? I am trying to construct a custom function that uses vlooku
mechanism to get data from another file, and for a number of reasons
really would like to keep that other file closed at all times.

Many thanks for any hints!

:confused

--
Message posted from http://www.ExcelForum.com

vlookup from VBA on a closed workbook
 

Hi

Try http://www.exceltip.com

loads of good stuff including VBA for improting etc from close
workbook.

Ji

--
Message posted from http://www.ExcelForum.com