Save and check in a PDF file RRS feed

  • Question

  • Hi,

    I have written some Excel VBA code to create a .pdf file from an Excel file and load it onto SharePoint, but it is always checked out to me once saved. How do I check it in when I save it. Below is my code which works fine.

        Worksheets("Summary").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        LocationToSaveTo & "Daily Christmas Report Summary_" & Year(Date) & Month(Date) & Format(Day(Date), "00") & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False _
        , OpenAfterPublish:=False


    • Edited by Gazza101 Tuesday, November 4, 2014 3:40 PM
    Tuesday, November 4, 2014 3:39 PM

All replies