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

P

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
2,171
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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,215,745
Messages
6,126,634
Members
449,324
Latest member
AmirMalik

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