I have an excel macro that pulls data down from columns within worksheets that will take an excel spreadsheet and save it as a PDF file into seperate folders based off criteria set in the files. Getting the files into the proper directory is not the problem
i'm having. When the script executes it saves the documents directly to our sharepoint site, but the custom columns A B C D etc are all blank and some are 'required' items which sets the document as checked out until i go into the list and enter the required
Is there anyway to make this macro export as PDF and set the required data for me in the sharepoint column so it checks the documents in for me?
I'm figuring this is a simple set of meta datatags but I don't know the syntax for them and I didn't find anything like this on the forum anywhere else.
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"http://DirectoryStructureHere/corporate%20BoFi/pdfs/" & NewFileName & ".pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False 'Exports the print area as a PDF document named the new filename "Modified: to sharepoint"
View Complete Post