VBA to Create PDF File on Sharepoint and set .ContentTypeProperties() values

P

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
2,162
Office Version
  1. 365
Platform
  1. Windows
HI,

Using VBA I'm able to create and save an excel file to SharePoint and set relevant tags using the .ContentTypeProperties() value. In order to publish the spreadsheet I want to create a PDF version in the same location, but seem to be unable to do so because the 'tags' aren't set.

Grateful for your thoughts - even if that's only 'It can't be done!".

Regards

Peter
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

S
  • Question
Neep help setting up table for plot graph
Replies
0
Views
93
supermom28115
S
J
  • Question
Changing file explorer directories to Sharepoint directories
Replies
0
Views
202
jon1315
J
T
  • Question
How do you populate a list of Sharepoint Files in A combobox
Replies
0
Views
295
thardin
T
M
  • Solved
PDF's won't open in Sharepoint/Teams but will in C:drive Documents folder
Replies
3
Views
697
Mr_Ragweed2
M
M
  • Question
"Bad path or filename" runtime error 52 - sharepoint pathway issue
2
Replies
11
Views
979
Mr_Ragweed2
M

Forum statistics

Threads
1,214,982
Messages
6,122,573
Members
449,089
Latest member
Motoracer88

Share this page

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