delali:

Try with Vlookup

Regards.

Luis Fernando Ortiz M.

"delali" escribió en el mensaje
...
Hi All,

Is it possible to get data from an external excel file without opening the
file?

using workbooks("fname").worksheets("shtname").range("A1 ").value only
works
when fname is open.

thanks