https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83399#M34679 Thanks James, this is a good alternative. For a better solution, i cannot launch my macro. Here the exception : ""Internal : Could not execute code stage because exception thrown by code stage: Impossible d'exécuter la macro 'Macro5'. Il est possible qu'elle ne soit pas disponible dans ce classeur ou que toutes les macros soient désactivées."" It talks that event are not Enabled while i check everywhere for having ""Event Enables"" flagged ""True"" when i create my instance and later. I think i'm not far from the solution with this option... Thanks Wed, 25 May 2016 21:53:00 GMT kevin_guillemie 2016-05-25T21:53:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83395#M34675 Hello, I need to automate some actions in Excel as : - Change data source of a pivot table - Launch "Calculate Sheet" - Extends formula - Change filter data - Rename Worksheet By delay worries and lack of experiences on blueprism, can you tell me how can i do to launch a macro VBA from BluePrism ? if you know a quick way to implement these functions, can you tell me ? Thank you, With regards Wed, 25 May 2016 15:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83395#M34675 kevin_guillemie 2016-05-25T15:40:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83396#M34676 Hi, I would suggest that you create your own code page within the MSExcel VBO supplied by Blue Prism. If you use the following code: authorised by Blue Prism:- GetInstance(Handle).Run(Macro_Name) Ensure you have the following inputs: -Handle -Macro Name Once created simply call it from a process like any other Business Object actions. This should run any macro built. Let me know how you get on. Thanks, James Wed, 25 May 2016 15:55:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83396#M34676 jgreaves2 2016-05-25T15:55:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83397#M34677 Thanks for your replies. Indeed, i have macro blocking issue in Excel. I thought to add a delay of 15 sec with a timer which permits user to Allow Macro but i haven't real parameter to put ""in my wait"". Have you got an idea ? Can i just tell BP to wait without condition ? Like liva.celmina you said, write in code stage needs modification and i have not really the time required to bring in. Wed, 25 May 2016 18:53:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83397#M34677 kevin_guillemie 2016-05-25T18:53:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83398#M34678 Hi, I would advise looking at a permanent solution that won't need an interaction to ""allow macro"" however, to give you a quick answer regarding the wait stage, you can leave parameters blank which will give you a basic sleep period. For build efficiency & design: -If you are in a Business Object, use the Wait Stages depicted by duel stop watches -If you are in a Process, use the ""Sleep"" action within General Utilities Let me know if I can help with anything else. Thanks, James Wed, 25 May 2016 20:24:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83398#M34678 jgreaves2 2016-05-25T20:24:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83399#M34679 Thanks James, this is a good alternative. For a better solution, i cannot launch my macro. Here the exception : ""Internal : Could not execute code stage because exception thrown by code stage: Impossible d'exécuter la macro 'Macro5'. Il est possible qu'elle ne soit pas disponible dans ce classeur ou que toutes les macros soient désactivées."" It talks that event are not Enabled while i check everywhere for having ""Event Enables"" flagged ""True"" when i create my instance and later. I think i'm not far from the solution with this option... Thanks Wed, 25 May 2016 21:53:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83399#M34679 kevin_guillemie 2016-05-25T21:53:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83400#M34680 How to filter my worksheet data dynamically? please help Fri, 27 May 2016 15:06:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83400#M34680 LakshmananMasil 2016-05-27T15:06:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83401#M34681 HI, This one may be a little tricky as I can't really see what spread sheets you are using and your set up of both the Macro & document. I would suggest that you ensure the macro you are trying to run is in the spread sheet you are interacting, if not then do one of the following: -Add it to the spread sheet -Add it to the 'Personal' attributes so that the macro can be run within any spread sheet. Make sure you double check you don't have any problems with launching normal spread sheets when this is done, as it can cause pop ups on launch of Excel. Other than the above, you will need to check to see if the Spread sheet is macro enabled i.e. .XLSM extended. You may find some problems with 97' Excel documents as these have a different form setup for extensions but few companies will use documents this old. Give the above a try and let me know if it solves the problems. Thanks, James Fri, 27 May 2016 15:28:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83401#M34681 jgreaves2 2016-05-27T15:28:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83402#M34682 Hi, Can I ask what you are looking to do with the data as an end objective? It will allow me to assist more in an ideal solution. i.e. are you looking to filter & save the worksheet for others to more ideally view the information or are you looking to locate specific pieces of information to then extract? Thanks, James Fri, 27 May 2016 15:31:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83402#M34682 jgreaves2 2016-05-27T15:31:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83403#M34683 Thanks for quick reply. My Filter criteria is dynamic. I have a config file and excel. I need to filter worksheet based on the column name specified in the config file. Fri, 27 May 2016 17:18:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83403#M34683 LakshmananMasil 2016-05-27T17:18:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83404#M34684 Hi, Can you give me some more details around the purpose of the filter? It may be easier to pull the information from the spread sheet and use a loop and extract function to simply retrieve the data that you need. It will depend on what the filter is trying to achieve. Thanks, James Fri, 27 May 2016 17:47:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83404#M34684 jgreaves2 2016-05-27T17:47:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83405#M34685 I have a excel file which have details of passenger for booking trains. I have a Data variable in which filter column name specified. I want to filter the passenger details with respective to column name specified in the data variable. for example if my data variable having value as ""Gender"" then passenger details would be filter with Gender. Fri, 27 May 2016 18:23:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83405#M34685 LakshmananMasil 2016-05-27T18:23:00Z https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83406#M34686 Well when i click on launch, i open my file manually then i execute my program for simulate a clic which enable macro, it works. How can i do to include this into a program ? There are solutions that i've tried : Create instance --> Show --> Open file => Not connected. Launch --> Show --> Open file => I have two windows. I think i need to attach my window name. But i don't know why when i open my file with the process the name of the windows is never the same. So i can't attach it ""My file - Excel 08FF9389389R838F"" ""My file - Excel 490R803800858300"" instead of ""My file"" Have you got a solution for my problem ? Thanks, With Regards, KG Mon, 30 May 2016 20:22:00 GMT https://community.blueprism.com/t5/Product-Forum/How-launch-macro-VBA-from-BluePrism/m-p/83406#M34686 kevin_guillemie 2016-05-30T20:22:00Z