Thanks!
I must not be making myself very clear. :(
(Can I blame it on a head cold?)

Intralink (our data manaement program) appends a dot numeric value to
the name of the file if/when you view it through a workspace (Intralink
verbiage)

5098000.xls becomes 5098000.xls.209
(209 is a random number based on the number of objects in your
workspace)

Old naming conventions had the revision of the file in the filename
(5098000_116.xls) When people are printing out of Intralink, they are
seeing the dot numeric value and assuming it is the rev of the file.

So, I have exported the files to a new folder, unrelated to Intralink
These files are named correctly (i.e. 5098000.xls)

The headers for these files utilize &F
The tabs have unrelated references, which I can not change

I need to replace &F with 5098000.xls for this file. I have 442 others
which need the same thing, replace &F with the actual file name, in
text, in the header

There must be an easier way!!
Michelle


--
amthyst826
------------------------------------------------------------------------
amthyst826's Profile: http://www.excelforum.com/member.php...o&userid=28308
View this thread: http://www.excelforum.com/showthread...hreadid=478853