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.

Haven't tried it myself, but try

Application.DisplayALerts = False

before the save and reset afterwards.

--
__________________________________
HTH

Bob

"LA-Alc" <LA-(E-Mail Removed)> wrote in message
news798D444-0135-47DC-BC89-(E-Mail Removed)...
> 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.

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" <LA-(E-Mail Removed)> wrote in message
> news798D444-0135-47DC-BC89-(E-Mail Removed)...
> > 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.
>
>
>

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

--
__________________________________
HTH

Bob

"LA-Alc" <(E-Mail Removed)> wrote in message
news:5CD19BDE-BC05-4340-AAAA-(E-Mail Removed)...
> 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" <LA-(E-Mail Removed)> wrote in message
>> news798D444-0135-47DC-BC89-(E-Mail Removed)...
>> > 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.
>>
>>
>>

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
>

You have to set

Application.DisplaAlerts = True

before the save.

--
__________________________________
HTH

Bob

"LA-Alc" <(E-Mail Removed)> wrote in message
news:9A8C63B4-7028-4E83-948F-(E-Mail Removed)...
> 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
>>
>

That should have been

Application.DisplayAlerts = True


--
__________________________________
HTH

Bob

"LA-Alc" <(E-Mail Removed)> wrote in message
news:9A8C63B4-7028-4E83-948F-(E-Mail Removed)...
> 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
>>
>

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" <(E-Mail Removed)> wrote in message
> news:9A8C63B4-7028-4E83-948F-(E-Mail Removed)...
> > 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
> >>
> >
>
>
>

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" <(E-Mail Removed)> wrote in message
news:0FA8F4BB-CDAF-448B-A6E8-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:9A8C63B4-7028-4E83-948F-(E-Mail Removed)...
>> > 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
>> >>
>> >
>>
>>
>>