name cannot be same

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
 
D

Dave Peterson

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

If you are, just give it a nice legal (unique) name.
 
V

vbrajpara

Hi, what to do when you are opening excel file programmatically through
objects?

Thx
 
D

Dave Peterson

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.
 
D

Dave Peterson

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...
 
Top