How to get folders using Sharepoint URL

I have a vba script that uses the legacy file path to get a list of folders. We are moving over to Sharepoint, and the url folder path does not work. Do I need to do something g different?

thanks.