Create Sharepoint Folder using Access VBA

I am trying to write VBA code in Access to check if folder exists on Sharepoint site and if it doesn’t the create it, if it does then just open a location of it.

I managed to get it to open existing ones using some of my old codes, but can’t figure out how to make it work to create and check for existing.

Help would be appreciated, thank you.