How to set Share Point 'ContentTypeProperties' at generating pdf in (Excel) vba

AadKabel

New Member
Joined
Oct 3, 2018
Messages
3
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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,223,243
Messages
6,170,971
Members
452,371
Latest member
Frana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top