Changing file explorer directories to Sharepoint directories

[jon1315]

Good afternoon
I have a number of Excel files which use VBA to create 'dynamic' filepaths, which then proceed to do whatever is needed of them

For example:
Var1 = [directory root]
Var2 = [month]
var3 = [Filename]
FullFilePath = Va1 & "\" & Var2 & "\" & Var3
...

and then the rest of the script.

I have to move my files onto Sharepoint, so have made some test areas to temporarily house the files.
The Sharepoint filepaths I have been using are essentially the URL on the area I've saved the files, but some of them are huge and quite complex:

https://[company].sharepoint.com/sites/AutomationTest/Sharepoint%20VBA%20Test%20Area/Forms/AllItems.aspx?newTargetListUrl=%2Fsites%2FAutomationTest%2FSharepoint%20VBA%20Test%20Area&viewpath=%2Fsites%2FAutomationTest%2FSharepoint%20VBA%20Test%20Area%2FForms%2FAllItems%2Easpx&id=%2Fsites%2FAutomationTest%2FSharepoint%20VBA%20Test%20Area%2FBanking%2FTransfers%2FSource%20Files%2FClient%20Funds%20Transfer%20Generator%2F2024%2F03%2E%20Mar&viewid=1e68819c%2Da059%2D412e%2Db488%2Db10361df658e

Is there an easier way to manipulate these directories? That's quite a simple one, but can see them potentially doubling in size once the required subfolders are created

Thank you in advance

Jon