If you insert a link to a cell in an external file in your worksheet cell,
Excel will ask if you want to update links when your file is opened.

If you can anticipate from which cells in the external file data is
required, then just set-up links to them and pickup data data when your file
is opened.
--
Gary's Student


"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