controling a .xls from another .xls

does anyone know if it is possible to control one excell file from another. i.e lets say there are two files:

a.xls

&

b.xls


in "a.xls" cell A1 we input the number "100", is it possible for this number to automatically be populated in to cell A1 of "b.xls"??? if so how???

thanks guys

In cell A1 of b.xls, put this formula

=[a.xls]Sheet1!$A$1

Vaya con Dios,
Chuck, CABGx3



"on-a-mission" wrote:

>
> does anyone know if it is possible to control one excell file from
> another. i.e lets say there are two files:
>
> a.xls
>
> &
>
> b.xls
>
>
> in "a.xls" cell A1 we input the number "100", is it possible for this
> number to automatically be populated in to cell A1 of "b.xls"??? if so
> how???
>
> thanks guys
>
>
> --
> on-a-mission
> ------------------------------------------------------------------------
> on-a-mission's Profile: http://www.excelforum.com/member.php...o&userid=31630
> View this thread: http://www.excelforum.com/showthread...hreadid=513234
>
>

brilliant, thanks, works a treat....