Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing
Edit|links|change source might be quicker.
The function you'd want to use that's built into excel is =indirect(). But that function returns an error if the sending workbook is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. Trevor Williams wrote: I have a number of cells referencing named ranges stored in external workbooks e.g: ='C:\Clients\Client Name\Response Files\ClientFile.xls'!Groupconfidence Currently I change each of these cells manually. Is it possible to update this programmatically? Ideally I'd input the Route Directory into a cell (A1), and the filenames into a separate cell (A2), and then use something like the following to pull it all together. =TEXT(CHAR(39)&A1&"\"&A2&CHAR(39) &"!Groupconfidence",) (If I type this into a cell it doesn't recognise it as a linked file) The linked cells will use this info to call the named ranges into the workbook The named ranges always stay the same. Hope that makes sense?! Thanks Trevor -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the range for averages with out changing the formula. | Excel Worksheet Functions | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
Changing background color when changing value | Excel Programming | |||
changing a cell to changing the link | Excel Worksheet Functions |