Forum Discussion
Excel VBA to import data from Excel to Sharepoint Approval
Getting ready to start a project where I need to upload data from an Excel sheet into a Sharepoint site that has a custom Approval Form. I have a few ideas on how I might do it but with Excel, Sharep...
heylookitsme I would advise you to look into the options that Powerautomate have to offer. VBA is not the best tool for this job I'm afraid.
- It is looking that way. I have setup several PA processes so I am pretty familiar with it. Do you or anyone here know how to create a new approval but not submit it?
Why you ask, because I want it to populate some data into the approval form automatically
and leave it open and in view for the user to review, add the approvers and then the user selects submit. The approval form has a lot of data entries that the user has already done in an Excel sheet. I am preventing them from having to enter the data twice.- Perhaps this article gives some pointers? Not sure, I know nothing about approvals
JKPieterseI do not see your link.
