Not sure where to ask so I try here.
We all know data preparation is key to success. “Crap in means crap out”.
My favourite feeding tool for my RPA robot army is using good ol’ Excel with VBA.
People fill in Excel sheets and the data is validated with VBA, including API calls etc.
So when the robot gets the input it won’t fail because of error in the input.
My problem with web-forms is that you usually have to put in one transaction at a time. In Excel you can have hundreds of similar transactions filled in easily.
So are there other preferred methods people want to share their experience with?
E.g. SharePoint Forms?