PrimePrism
Member
Hi,
I need to run an excel macro with parameters. To achieve this, I wrote a procedure in the Excel module that can accept parameters but, couldn't find it in the macro run dialog box at all. To overcome this, I moved this procedure to the sheet code area and called this from worksheet_change event. So, my intention is to pass the values for the parameters by writing in the cells of Excel. This code as it is works perfectly fine. But, when I run it from Blue prism passing the values from there, it works fine until macros for SAP Business Analysis macros run command. But, even these commands work fine when the code in the excel file run as it is. The problem is when it runs from Blue Prism. Could anyone please help and suggest what steps need to be taken to solve this issue?
Thanks in Advance.
I need to run an excel macro with parameters. To achieve this, I wrote a procedure in the Excel module that can accept parameters but, couldn't find it in the macro run dialog box at all. To overcome this, I moved this procedure to the sheet code area and called this from worksheet_change event. So, my intention is to pass the values for the parameters by writing in the cells of Excel. This code as it is works perfectly fine. But, when I run it from Blue prism passing the values from there, it works fine until macros for SAP Business Analysis macros run command. But, even these commands work fine when the code in the excel file run as it is. The problem is when it runs from Blue Prism. Could anyone please help and suggest what steps need to be taken to solve this issue?
Thanks in Advance.