Hello - This is my first post and question ..
I have built an Excel VBA application relating to Finance, that is highly data centric. As part of the Monthly Reporting, the application sends Data to a set of users and seeks their critical data inputs - without which the reporting cannot be done.
Following is my objective:
1. From the VBA Application - upload Data to One Drive
2. Microsoft Forms should pick up this Data and send to the Users - and get their Inputs
3. The Data should then get imported into Excel on One Drive
4. The VBA Application will then pick up the Data from One Drive and Import the same back
I have been able to achieve 1 and 4 - So, currently the End Users Update the Data in One Drive - But, my objective is for them to be able to fill up the data using their mobile APP or Forms
Can anyone help me with some pointers to how this can be done. I am totally new to Forms or Power Automate
Thank You