name cannot be same

[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

 

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

 

[vbrajpara]

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

Thx

 

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

 

[vbrajpara]

Dave,

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

 

[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