name cannot be same

  • Thread starter Thread starter bmurlidhar
  • Start date Start date
B

bmurlidhar

Dear friends

I am finding message "print_area - name cannot be same" this error
while opening 2003 xls file in 2007 version
May be this problem was discussed earlier but please anybody can help
me to come out from this problem

Murlidhar
 
Aren't you given a prompt asking you to rename one of them?

If you are, just give it a nice legal (unique) name.
 
I'm not sure if it's possible to do this through code.

Maybe (untested!) you could try:
application.displayalerts = false
code to open the workbook
application.displayalerts = true

I'm not sure if these are the kinds of warnings that will respect that
..displayalerts setting.
 
Maybe it's time to bite the bullet and open each of the possible files manually
and fix them that way????
Dave,

Thanks for the reply. I tried it but seems to be no way to resolve this
Click to expand...
 
Back
Top