Save As vba code

Question

What is the VBA code for the File->SaveAs function in MS Word 2010?

Answer 1

Best way to answer these questions for yourself is to record a macro of you manually doing a save as and look at the recorded result.

You need to right click the status bar and select macro Recorder to display the macro Recording button.

---

Rod Gill
Author of the one and only Project VBA Book
www.project-systems.co.nz

Answer 2

They changed the SaveAs Function in MS Word 2010, it appears to be SaveAs2.

See below documentation:

http://msdn.microsoft.com/en-us/library/office/ff836084(v=office.15).aspx

Hop this helps,

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

Answer 3

SaveAs is still valid in Word 2010, to maintain compatibility with earlier versions. The syntax is

expression.SaveAs(FileName, FileFormat, LockComments, Password, AddToRecentFiles, WritePassword, ReadOnlyRecommended, EmbedTrueTypeFonts, SaveNativePictureFormat, SaveFormsData, SaveAsAOCELetter, Encoding, InsertLineBreaks, AllowSubstitutions, LineEnding, AddBiDiMarks)

The syntax for SaveAs2 (not available in Word 2007 and earlier) is

expression.SaveAs2(FileName, FileFormat, LockComments, Password, AddToRecentFiles, WritePassword, ReadOnlyRecommended, EmbedTrueTypeFonts, SaveNativePictureFormat, SaveFormsData, SaveAsAOCELetter, Encoding, InsertLineBreaks, AllowSubstitutions, LineEnding, AddBiDiMarks, CompatibilityMode)

---

Graham Mayor - Word MVP
www.gmayor.com