I have a part of VBA code that reads:

Windows("Data 31 Dec 05.xls").Activate

This works fine at the moment but at somepoint the file is going to be saved again with its name changed. This part of the formula kicks in after 6 pages are copied out of the main document and into a new one, which is saved under a new file name, ie:

Macro is run
6 Pages are copied out into a new book
New book is saved
Old file (Data 31 Dec 05.xls) is selected.

What i want to be able to do is to have a formula in the main doc that reads:
=CELL("Filename") so that the correct filename is known, then have this copied in with the 6 pages and have the Windows formula link to this cell reference.

Any ideas?