Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Build a link to an other excell document.
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Build a link to an other excell document.
The function you'd want to use is =indirect().
But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm That includes =indirect.ext() that may help you. === If you have trouble getting to the site, then search google for indirect.ext. I found this alternative site: http://download.cnet.com/Morefunc/30...-10423159.html I didn't look to see if it was the most current version. I'd check the original site every so often to see if it's working. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to build DDE link with text from another cell | Excel Worksheet Functions | |||
How do I link part of an Word document into an Excell workbook? | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Use Cell Content to Build Link | Excel Worksheet Functions | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) |