Forum

Excel 2003 Version ...
 
Notifications
Clear all

Excel 2003 Version pop up warning

5 Posts
2 Users
0 Reactions
69 Views
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 
Every time I try to save an xlsm, edit a CVS or 2003-2007 Excel file version it gives a warning that it will be saved in compatibility mode.
I have this habit of saving Excel work every now and then  via Ctrl+S and  Window keeps popping up the compatibility warning.
How can I disable this annoying 'Compatibility mode pop-up using a macro module

eg

Sub FileSave()

ActiveWorkbook.SaveAs Filename:="D: & ActiveSheet.Name & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
   ReadOnlyRecommended:=False, CreateBackup:=False
   Application.DisplayAlerts = Flase
   ActiveWorkbook.Close

End Sub

It cause pop up warning ...

 

 
Posted : 30/05/2019 2:45 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi David,

I assume you are using a version of Excel that supports the xlsx format.  If so, why are you saving files as .xls?

I don't know any way to turn off the annoying warning when saving CSV files in 2013, that drives me nuts too.  O365 doesn't do this though, or at least you can turn it off.

Regards

Phil

 
Posted : 01/06/2019 12:22 am
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

Thanks Philip the advice.

The point is I want to keep  the macro module in the Excel file for some one use;  but if in xlsx format,  macro module  will be lost unless switch to  xlsm, or xls format

but not so sure the following code do the work 

Sub FileSave()

ActiveWorkbook.SaveAs Filename:="D: & ActiveSheet.Name & ".xlsm", FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
   ReadOnlyRecommended:=False, CreateBackup:=False
   Application.DisplayAlerts = Flase
   ActiveWorkbook.Close

End Sub

Pls comment !

 
Posted : 01/06/2019 1:41 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

I'm confused.  So you want to save macros, but you don't want to use the .xlsm format?  If you have VBA in a file and save it as .xlsx the VBA will be removed.

If you save it as the older .xls you'll get the compatibility warning.

Phil

 
Posted : 03/06/2019 6:54 pm
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

OK , noted tks the clarifications.

 
Posted : 03/06/2019 8:57 pm
Share: