Defined Names response
 

Hi all,

Have a macro that takes a .xlsm file and then saves it back to a '97-2003
..xls file. During the save, the following message shows:

"Defined names or formulas in this workbook may display different values
when they are recalculated in an earlier version of Excel if they:

- Reference cells outside of the row and column limit in an earlier version
of Excel
- Include functions that are not supported...
- Use formula limits that are not supported in ....

Do you want to recalculate all formulas when this workbook is opened?"

What code can I put into the macro to automatically answer 'Yes' to this, or
bypass it completely?

Thanks for any assistance.

Defined Names response
 

Haven't tried it myself, but try

Application.DisplayALerts = False

before the save and reset afterwards.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi all,

Have a macro that takes a .xlsm file and then saves it back to a '97-2003
.xls file. During the save, the following message shows:

"Defined names or formulas in this workbook may display different values
when they are recalculated in an earlier version of Excel if they:

- Reference cells outside of the row and column limit in an earlier
version
of Excel
- Include functions that are not supported...
- Use formula limits that are not supported in ....

Do you want to recalculate all formulas when this workbook is opened?"

What code can I put into the macro to automatically answer 'Yes' to this,
or
bypass it completely?

Thanks for any assistance.

Defined Names response
 

Hi Bob,

Thanks for the assist, but no luck with turning DisplayAlerts off.

Les

"Bob Phillips" wrote:

Haven't tried it myself, but try

Application.DisplayALerts = False

before the save and reset afterwards.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi all,

Have a macro that takes a .xlsm file and then saves it back to a '97-2003
.xls file. During the save, the following message shows:

"Defined names or formulas in this workbook may display different values
when they are recalculated in an earlier version of Excel if they:

- Reference cells outside of the row and column limit in an earlier
version
of Excel
- Include functions that are not supported...
- Use formula limits that are not supported in ....

Do you want to recalculate all formulas when this workbook is opened?"

What code can I put into the macro to automatically answer 'Yes' to this,
or
bypass it completely?

Thanks for any assistance.

Defined Names response
 

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi Bob,

Thanks for the assist, but no luck with turning DisplayAlerts off.

Les

"Bob Phillips" wrote:

Haven't tried it myself, but try

Application.DisplayALerts = False

before the save and reset afterwards.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi all,

Have a macro that takes a .xlsm file and then saves it back to a
'97-2003
.xls file. During the save, the following message shows:

"Defined names or formulas in this workbook may display different
values
when they are recalculated in an earlier version of Excel if they:

- Reference cells outside of the row and column limit in an earlier
version
of Excel
- Include functions that are not supported...
- Use formula limits that are not supported in ....

Do you want to recalculate all formulas when this workbook is opened?"

What code can I put into the macro to automatically answer 'Yes' to
this,
or
bypass it completely?

Thanks for any assistance.

Defined Names response
 

Hi Bob,

Thanks for the check. The code that I'm using is:

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = False

When I run this, the message still comes up. Doing a bit of searching I'm
not sure if I should be addressing the ConflictResolution parameter of the
save? Yours works, so maybe it's more my code than anything else.

Thanks again.

"Bob Phillips" wrote:

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob

Defined Names response
 

You have to set

Application.DisplaAlerts = True

before the save.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi Bob,

Thanks for the check. The code that I'm using is:

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = False

When I run this, the message still comes up. Doing a bit of searching I'm
not sure if I should be addressing the ConflictResolution parameter of the
save? Yours works, so maybe it's more my code than anything else.

Thanks again.

"Bob Phillips" wrote:

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob

Defined Names response
 

That should have been

Application.DisplayAlerts = True


--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi Bob,

Thanks for the check. The code that I'm using is:

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = False

When I run this, the message still comes up. Doing a bit of searching I'm
not sure if I should be addressing the ConflictResolution parameter of the
save? Yours works, so maybe it's more my code than anything else.

Thanks again.

"Bob Phillips" wrote:

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob

Defined Names response
 

Ahhh, that would make more sense.

Thanks for the help Bob, appreciate it!

"Bob Phillips" wrote:

That should have been

Application.DisplayAlerts = True


--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi Bob,

Thanks for the check. The code that I'm using is:

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = False

When I run this, the message still comes up. Doing a bit of searching I'm
not sure if I should be addressing the ConflictResolution parameter of the
save? Yours works, so maybe it's more my code than anything else.

Thanks again.

"Bob Phillips" wrote:

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob

Defined Names response
 

Hopefully, final posting with the correct info

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Application.DisplayAlerts = True

That is how it should be.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Ahhh, that would make more sense.

Thanks for the help Bob, appreciate it!

"Bob Phillips" wrote:

That should have been

Application.DisplayAlerts = True


--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi Bob,

Thanks for the check. The code that I'm using is:

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = False

When I run this, the message still comes up. Doing a bit of searching
I'm
not sure if I should be addressing the ConflictResolution parameter of
the
save? Yours works, so maybe it's more my code than anything else.

Thanks again.

"Bob Phillips" wrote:

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob