I am exploring a method to download and upload information from an excel spreadsheet stored on a SharePoint Site from a VB based form in a local excel file. Can you please assist me in understanding the method to do this. I intend to help my technical team with the responses that i receive from the community.
I also wanted to check whether this method will allow multiple users to access the data on the SharePoint Stored excel file and update records in it simultaneously.
in case you have a better solution to achieve this please do also let me know.