--------------------------------------------------------------------------------

Hi!
I've managed to link fileds to an other excell document.
IE. ='C:\[calc2009.xls]Page1'!A1
But now I'm trying to build a link so that it updates with a new year every
time you change the year.
IE.
in B1 I write the year 2010.
Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1

I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no
success.

Is this possible?
Thanks for your help!

Check your earlier post.

danielh wrote:
>
> --------------------------------------------------------------------------------
>
> Hi!
> I've managed to link fileds to an other excell document.
> IE. ='C:\[calc2009.xls]Page1'!A1
> But now I'm trying to build a link so that it updates with a new year every
> time you change the year.
> IE.
> in B1 I write the year 2010.
> Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1
>
> I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no
> success.
>
> Is this possible?
> Thanks for your help!

--

Dave Peterson

Try =INDIRECT("'C:\[calc"&B1&".xls]Page1'!A1")
The file cal2010 must be open for this to work
To link to a closed file use Indirect.ext()
Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"danielh" <(E-Mail Removed)> wrote in message
news:E7249236-0DF7-4F03-BE1C-(E-Mail Removed)...
> --------------------------------------------------------------------------------
>
> Hi!
> I've managed to link fileds to an other excell document.
> IE. ='C:\[calc2009.xls]Page1'!A1
> But now I'm trying to build a link so that it updates with a new year
> every
> time you change the year.
> IE.
> in B1 I write the year 2010.
> Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1
>
> I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no
> success.
>
> Is this possible?
> Thanks for your help!
>