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 b
saved again with its name changed. This part of the formula kicks i
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 tha
reads:
=CELL("Filename") so that the correct filename is known, then have thi
copied in with the 6 pages and have the Windows formula link to thi
cell reference.

Any ideas

--
chalk
-----------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...fo&userid=2375
View this thread: http://www.excelforum.com/showthread.php?threadid=51326