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.

bmurlidhar wrote:

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

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

Thx

"Dave Peterson" wrote:

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

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

bmurlidhar wrote:

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

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 wrote:

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

Thx

"Dave Peterson" wrote:

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

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

bmurlidhar wrote:

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


--

Dave Peterson

Dave,

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

"Dave Peterson" wrote:

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 wrote:

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

Thx

"Dave Peterson" wrote:

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

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

bmurlidhar wrote:

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


--

Dave Peterson

Maybe it's time to bite the bullet and open each of the possible files manually
and fix them that way????

vbrajpara wrote:

Dave,

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

"Dave Peterson" wrote:

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 wrote:

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

Thx

"Dave Peterson" wrote:

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

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

bmurlidhar wrote:

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


--

Dave Peterson


--

Dave Peterson