IBM Business Automation Community Come for answers. Stay for best practices. All we’re missing is you. Join / Log in Ask a question
Hi I am trying to automate working with 2 excel files where if an order number doesn't exist in the main file then take it from the new file and add the data in.
And loop through the file until every row has been checked.
Is it better to do this work in a Macro then use RPA to run the Macro?
Generally speaking, IBM RPA can provide a straightforward solution to automate the process of comparing and updating data between two Excel files. By using RPA, you can automate the tasks of opening, reading, and writing data to Excel files, as well as performing the necessary comparison and update operations without the need for a separate Macro.
All the best,
Good question, Thomas. If you have RPA tooling and skills handy, you can certainly use that approach. A skilled VB developer could also do this with macros and lookups. Parameters for a fit-for-purpose between both would include the frequency of the procedure and the stability of the structure of the files to compare. Some authentication/security considerations as well. More importantly in favor of RPA, if additional automation could bring business value beyond the creation of another file (for instance, by adding the data straight into another system).
Hi, RPA can surely provide added value with regard to automation of the process end to end, in reality if you also need to add some formatting or other additional steps in excel, or you need to work with .xlsm or template files, you will still need to use a macro. So if you make sure to handle exceptions correctly, running macro from RPA is definitely the most preferred option by RPA users.
Thanks for the input Dominik!
another way how to do that is to use SQL, plesse refer to the following thread:
Thanks Jiri, I'll check it out