Hi,

I can without any problem with vba copy files to my onedrive folder the only thing that I can't seem to get done is get the downloadable link through VBA.

Onedrive has a local folder on your c drive which is this one C:\Users\username\OneDrive by using this I'm able to copy and zip files using my vba code.

2 things that I can't seem to get fixed is after zipping all content of a given directory I'm not able to delete all the files that where zipped.

I also try to figure out how to get " share a onedrive link" through VBA.

is there a way to get this done through "the right click menu" under windows?

thanks for your thoughts in this matter

Paul