#HOW TO SYNC LOCAL FOLDER WITH ONEDRIVE FOR BUSINESS MANUAL#
Since sharepoint has changed it's path protocol from local to URL, i can't get this to work, resulting in a manual process, therefore, resulting in errors and inconsitencies. the filename (the quote number) was used to lookup a query from the Tender register to return all the client/contact/quote information. I had a macro that would run when a user clicked a button, that would create an appropriately named folder in the relevant local sharepoint directory, create a standard set of folders within that folder (Client Documents, Contract, Product Files, Drawings etc.) then open a Tender Form and save it in the created folder.
Prior to OneDrive/Sharepoint path change (previously the file path would be local, now it is a sharepoint URL) It is a tender register, used to enter client, client contact and tender information, which generates a quote number, folder and file name etc.
However, there are constantly problems and errors arising due to knowledge levels of each user, the spreadsheet needs to have structure and consistency, so in order to achieve that, i have created a userform with a suite of parameters to help people enter accurate data and avoid errors. I have a spreadsheet that many people need to access (on sharepoint), for a few reasons, we need to do this locally (synced).