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 <(E-Mail Removed)>
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" <(E-Mail Removed)> escribió en el mensaje
news:B1C0825C-968B-4F39-8533-(E-Mail Removed)...
> 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