Hi,



I have to save active document to SharePoint document library using VBA.

Appreciate your help.

Thanks & Regards,
Rose

What code have you tried? Have you implemented the process described at: https://msdn.microsoft.com/en-us/lib...or=-2147217396 ?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

Need to save xml file to sharepoint document library.
Using below code I can save the xml to shared drive

objDom.Save ServerShare & "\" & Split(ActiveDocument.Name, ".")(0) & ".xml"

How to save in sharepoint document library?
Appreciate your help

Thanks & Regards,
Rose

See my previous reply.

Please don't start new threads for the same question. I've merged both threads.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

Thanks for your reply.
I am able to save active document to share point document library
I have two task save as Xml and save active document.
I couldn't save xml using same.
Appreciate your help

Regards,
Rose

Does the code you're using save both the doc file and the xml file correctly if you save to a local folder?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes Paul, It saves correctly

Regards,
Rose

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:
(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).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

I have three values in word custom document properties.
I need to save this value to sharepoint document library column.
word also saved to sharepoint document library.

redactionRequired = ActiveDocument.CustomDocumentProperties("redaction Required").Value
restrictedAccess = ActiveDocument.CustomDocumentProperties("restricte dAccess").Value
remarks = ActiveDocument.CustomDocumentProperties("remarks") .Value

using VBA is it possible to save this value to sharepoint document library column?

Appreciate your help

Thanks & Regards,
Rose

Hi Rose,

I've never worked with a sharepoint document library, so each time you post a question about them, I'm having to go off and do the same research you could do for yourself. You obviously know how to read CustomDocumentProperties, so all you need to research is how to paste strings into sharepoint document library columns.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]