Hi,
I have used VBA to generate a pdf of an Excel worksheet.
The pdf is saved at a Share Point site.
Share Point settings require document properties to be able to group the files.
For saving an Excel file the Share Point, the file properties are set with: "ActiveWorkbook.ContentTypeProperties("PropName").Value = "GroupName"".
Because the pdf saving at Share Point is done in one run, this property can't be set.
I can't find how to set the Share Point properties to the pdf before uploading or immediately after, using VBA in Excel.
Current VBA code to generate the pdf in Exel and save at Share Point:
ActiveSheet.Range("D1:O87").ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=DRAMName, _
OpenAfterPublish:=False, _
IncludeDocProperties:=True, _
Quality:=xlQualityStandard
Appreciate if you can be of help.
Regards,
Aad
I have used VBA to generate a pdf of an Excel worksheet.
The pdf is saved at a Share Point site.
Share Point settings require document properties to be able to group the files.
For saving an Excel file the Share Point, the file properties are set with: "ActiveWorkbook.ContentTypeProperties("PropName").Value = "GroupName"".
Because the pdf saving at Share Point is done in one run, this property can't be set.
I can't find how to set the Share Point properties to the pdf before uploading or immediately after, using VBA in Excel.
Current VBA code to generate the pdf in Exel and save at Share Point:
ActiveSheet.Range("D1:O87").ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=DRAMName, _
OpenAfterPublish:=False, _
IncludeDocProperties:=True, _
Quality:=xlQualityStandard
Appreciate if you can be of help.
Regards,
Aad
