Help Saving Word Document From Excel - Compiler Error "Named Argument Not Found"

[JimHol]

I copied the code below from a source I found online which is purported to work but for me I get a Compiler Error "Named Argument Not Found" on "FileFormat" I am using Office 2007 and the Word document I am attempting to save is open.

ActiveDocument.SaveAs Filename:="test.docx", FileFormat:=wdFormatXMLDocument _
 , LockComments:=False, Password:="", AddToRecentFiles:=True, _
  WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
  SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:=False

Thanks,
Jim

 

[Macropod]

Try changing 'SaveAs' to 'SaveAs2'.

 

[JimHol]

That didnt work I got a "Method or Data Member Not Found" Error while compiling. Not sure if it matters but the VBA macro is part of an Excel document.

 

[Macropod]

Not sure if it matters but the VBA macro is part of an Excel document.

Hardly surprising, then, that it didn't work - that VBA code is for Word, not Excel....

 

[Norie]

Which version of Word are you using?

Does this work?

ActiveDocument.SaveAs FileName:="test.docx", FileFormat:=wdFormatXMLDocument

 

[JimHol]

What I had was an Excel macro that searched PowerPoint presentations for embedded Word documents, open them then save them out as separate files. Below is the code I finally come up with for saving the Word documents. Works Great!

relativePath = PresPath & oPPTPres.Name & "(" & ThisSlide & ")(" & ThisEmbdName & ").docx"
Set oSaveWdDoc = Shape.OLEFormat.Object
oSaveWdDoc.SaveAs Filename:=relativePath, FileFormat:=wdFormatDocumentDefault

Thanks for the assist,
Jim