Using Named Range for filename

[David Heaton]

I have a workbook that references various other workbooks on the server.
All the files relate to the current month, so every month we do a
find/replace to update the filenames.

What I would like to do is store the filenames in the workbook and have each
on as a named range.

So instead of the formula =[g:\finance\shared]book1.xls!a2 I can use
=book1!a2

I've tried doing this but each time it opens up the file explorer window and
asks for a file.

Thanks in advance

David

 

[CLR]

How about just making each one of your stored names as a Hyperlink?

Vaya con Dios,
Chuck, CABGx3