VBA code to save workbook with no prompt

[sagain2k]

What's the syntax for saving an Excel workbook file so it saves over the existing same filename without prompting you? Can't seem to find it...thanks!

The code I'm using to save the workbook is:

ActiveWorkbook.SaveAs Filename:="C:\Data\testfile.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

 

[an9elia]

Your solution used to work for me, but now I get another alert:

"Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web components. These may include personal information that cannot be removed by the Document Inspector."​

​

Any ideas?

PS. I use Windows XP, Excel 2007.

https://answers.microsoft.com/en-us/msoffice/forum/all/be-careful-parts-of-your-document-may-include/fae98705-d078-4fc5-843a-908dda5be559