How to save active document to SharePoint document library

macropod · #8 08-27-2015, 03:45 AM

So, when you use:
objDom.Save ServerShare & "\" & Split(ActiveDocument.Name, ".")(0) & ".xml"
Does anything get saved? I'd be surprised if you got an xml file out if it, though, as simply changing the extension doesn't create an xml file - you'd really need to use the SaveAs2 method and specify the file type. For example:

Code:

objDom.SaveAs2 _
  FileName:=ServerShare & "\" & Split(ActiveDocument.Name, ".")(0) & ".xml", _
  FileFormat:=wdFormatXML, AddToRecentFiles:=False

(assuming the Word XML format is what you want, though true xml files are only plain text files, as we've discussed before, and for which you could just as easily replace wdFormatXML with one of wdFormatText, wdFormatTextLineBreaks, wdFormatDOSText or wdFormatDOSTextLineBreaks).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Save As Macro using first line of document as document name	redzan	Word VBA	1	01-31-2015 09:24 PM
Uploading a document to SharePoint 2007 by email	bremen22	Misc	0	05-28-2014 07:36 AM
Copying text from another to Active document	AlexTeslin	Word VBA	1	03-08-2013 09:06 PM
Standard and SharePoint Library Properties	Kyron35	Word	0	02-20-2013 10:27 AM
Order of Folders in Document Library	eliz.bell	Word	2	04-03-2012 11:49 AM