See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy7.htm


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 11:50:02 -0800, delali
wrote:

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