Can't you open the file in 2003 on another machine and change the name ?

If this is working I can help you with a macro to chnage the names in all workbooks

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Reeza" wrote in message oups.com...
On May 10, 1:24 pm, "Ron de Bruin" wrote:
Hi Reeza

You can change the name in all workbooks in Excel 2003 with a macro maybe ?.
If you want me to take a look at one of the files on my system
send the file to me private.

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Reeza" wrote in oglegroups.com...
Hi All,

I have about 800+ excel workbooks, with an apparent problem. If I
open one of the files in excel 07 it gives me an error message, Name
Conflict
Name cannot be the same as a built-in name
Old name=print_area
new name=

Problem is i don't want to manually go and change all 800 files, any
way around this?

Thanks,
Reeza

Catch 22..Confidential data, but can't open the file to clear the data
without first fixing the problem :)

Reeza