There is a Action called ""Run Macro"" in ""MS Excel VBO"" which lets us to run a macro on a particular data. For this first we have to write the data to Macro WB...the same way how we deal with normal Excel WB except that we are using the file with extension ""*.xlsm"" instead of ""*.xlsx"". I hope this is what you are expecting for.
