Changing a text name within a cell based on file name

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

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
 
CAM said:
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
Click to expand...

see the reply from Shah Shailesh to my question "sheet tab" at 13:48 today.

Peter
 
Back
Top