Hi All,

Is there a command which I can add at the beginning of a macro so
that it can access the data in other Excel files without opening them?

Thanks.

See Ron de Bruin's site:
http://www.rondebruin.nl/ado.htm
--
JB


"Berj" wrote:

> Hi All,
>
> Is there a command which I can add at the beginning of a macro so
> that it can access the data in other Excel files without opening them?
>
> Thanks.
>

You can have VBA do the same thing a user can do on the worksheet. Say we
want to get the value in cell A1 in sheet b in file b.xls in folder c:\temp2

Pick a helper cell (say Z100) and:

Sub dumpit()
Dim s As String
s = "='C:\temp2\[b.xls]b'!$A$1"
Range("Z100").Formula = s
End Sub
--
Gary''s Student - gsnu200760


"john" wrote:

> See Ron de Bruin's site:
> http://www.rondebruin.nl/ado.htm
> --
> JB
>
>
> "Berj" wrote:
>
> > Hi All,
> >
> > Is there a command which I can add at the beginning of a macro so
> > that it can access the data in other Excel files without opening them?
> >
> > Thanks.
> >