Pass data from excel to Sharepoint using VBA Script
Currently my requirement is , by clicking a Button present in Excel sheet, the data from the excel need to be moved to Sharepoint list. The data exist in excel is full of Form and Active X controls.
Now, I need to push this data into Sharepoint list. I thought of implementing this requirement with VBA script. But itâs not successful. Kindly let me know, is there any other method of Implementing this functionality.
If I need to go with VBA scripting kindly get me some example.