Create pdf from Excel and upload to SharePoint site by using vba

Copper Contributor



I have an Excel worksheet with a form for calibration. The idea is that people after they completed the form start vba by clicking a button. The code will create a pdf and save it in a folder on a SharePoint site.


The code I created works when I save the file on a local drive, but when I want to save it on a SharePoint site I get an error.


When I paste the link to the folder in the browser, it will bring me to the correct folder. When using the file explorer I get the message 'Windows can't find 'https:........'. Check the spelling and try again.


Who can help?


Thank you in advance for your kind cooperation.



0 Replies