MS Access FileSystemObject

Recently, my organization migrated to SharePoint 365. Prior to the migration, I had a routine that was able to access files in SharePoint Document libraries. I used FileSystemObject to access the files however, it appears FileSystemObject is no lone a viable solution to this task. I have been look for other methods but I can’t seem to find any solutions. Is it possible to access folders and files located on SharePoint 365 servers via VBA? If yes, how do we perform this task?

Thanks,

Henry