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

Copper Contributor

Hello,

 

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.

 

Hans

0 Replies