Hi all,

Hopefully someone here can point me in the right direction. I have a database which I want to host on OneDrive, it is updated from a user form which I have created. I need to distribute the form to various staff members and have them input data and submit the form. I am looking for the VBA code to access OneDrive on the net (using a predesignated username and password) open the file, add the data and save it again.

What are the best solutions to this when not everyone has a OneDrive account.

Many thanks in advance.