How to use Excel as User Interface with Access DB, w/ both files on Sharepoint

Can someone provide example connection VBA code for connecting Excel Table to an Access DB file with both files stored on Sharepoint?
I want to use Excel as the user interface for entering & editing data that then uses VBA in order to write the data to an Access DB file.
I know how to do this with both files stored on normal computer drive folders, but I do not know how to do the connection & update commands when both files are on Sharepoint.
I'm unable to find help via searching the internet.
Any help is appreciated!

Later on 3-3-2024, I edited this post so to add the following text to it. I am hoping that by showing the VBA for non-https pathways that this may facilitate assistance on finding the code for a https pathway.

Below is the VBA for Excel to connect to Access via standard, non-https pathways. Notice the comment line at the 3rd line for a https pathway. If I enable this line, the connection does not work.
NOTE: For security reasons, I have altered this comment line so to hide company sensitive information.
I have been unable to find help on this over the internet.
Any help on making this connection "https friendly" would be greatly appreciated. Thank you!

Please Login or Register  to view this content.