Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
How do I set up a daily call out response response register? | Excel Worksheet Functions | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
Defined Names | Excel Programming | |||
Using defined names in VBA... | Excel Programming |