you could try using the INDIRECT command, that will replace the bolded part and another cell with the TODAY() command so it can draw reference
I never got the INDIRECT command to work for me this way though, hopefully someone with better knowledge can help
Using INDIRECT would require that the linked file be open. This is usually not desirable specially if linking to many files.
There is a free add-in called Morefunc.xll that has a function called INDIRECT.EXT that works just like the built-in INDIRECT function except that the linked files do not need to be open. That might work.
The add-in can be downloaded here:
http://excelenthusiasts.sharepoint.c...s/Morefunc.zip
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
GoGoeGo 
Register To Reply
Bookmarks