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

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

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

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