Can anyone post some simple vba code that I can plug in to my own code to allow me to automatically check in PDF files that have just been automatically created and saved on a SharePoint site?
I'm using the simple procedure, below, which works but means that I have the inconvenience of having to do manual check-ins afterwards.
Sub SaveAsPDF(ByVal theFileName As String, theID As String)
Dim myPath As String
myPath = Range("IssueDefectPath") & theFileName & ".pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=myPath, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False