Hello,

I wonder if it is possible to change a cell contents based on the file name.
For example I am using Excel file 2003 in my workbook sheet 1 in cell A2 it
is populated with a text field - company name "Zenith Manufacturer" and in
cell A3 has the company location text field "Tampa Florida" I have about 50
reports.  The file name on one report can be Sch88 (Zen) or Ex 1 (Zen), etc.
All of the 50 reports have  unique names, but has the same identifier within
the parentheses (Zen).  Here is my problem I have to duplicate the same 50
reports with a different company name. I would  manually change each of the
50 report in sheet 1 in cell A2 change the company name to "Diver
Manufacturer" and cell A3 will have "Simi, California" instead and save the
file name as Sch88 (Diver), Ex 1 (Diver), etc..  What I like to do is to
change the file name from Sch88 (Zen) to Sch88 (Diver) and have cell A2
change from "Zenith Manufacturer" to "Diver Manufacturer" and Cell A3 from
"Tampa Florida" to "Simi, California"  base on changing the parentheses
within the file name.  Is this possible?  Any tips or web site to visit will
be appreciated.  Thank you in advance.

Cheers