How to access Onedrive folder using macro / VBA?

Hi All,

I have written a macro for merging multiple files in a folder. Please find the uploaded code and the code is working fine.
Problem: How can I access the files from OneDrive Folder path (online)? If execute this macro from another system, it will not work. So what I planned to keep all the files in OneDrive and access from there. So any user can execute this macro becouse the file in cloud.
How can I connect and access OneDrive folder (online) using VBA?
Thank in Advance, Maadi.Attachment 17640