https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57645#M11616 Hello !  MS Excel VBO dont have ""Run Macro"" option , Please help where to check. Thu, 15 Mar 2018 12:05:00 GMT RamakrishnaVinn 2018-03-15T12:05:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57640#M11611 Hello! DO you know how to call a vba macro after opening the spreadsheet? Fri, 10 Nov 2017 20:49:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57640#M11611 Anonymous 2017-11-10T20:49:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57641#M11612 I think the MS Excel VBO object has a run macro action. I have also had to create an interface to the run macro button on the Excel developer tab before because of a threading issue with the dialog that the Excel button opened. Fri, 10 Nov 2017 22:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57641#M11612 Denis__Dennehy 2017-11-10T22:05:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57642#M11613 Store the macro in Personal.xlsb. You can check out this URL for storing macro is a single workbook: https://support.office.com/en-us/article/Create-and-save-all-your-macro… Now you ll have Personal.xlsb file containing the macro and the excel file on which you want to run the macro. 1. Copy the Personal.xlsb file to My Documents folder. You can Hide or Unhide Personal.xlsb in View->Unhide/Hide 2. Open the file on which you want to run the macro and get the handle number in variable. Then use MS Excel VBO and Input Macro name as Personal!. and provide the handle number. Wed, 15 Nov 2017 11:43:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57642#M11613 NitinSafaya 2017-11-15T11:43:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57643#M11614 Hi Nitin, Thanks for your explanation. I followed your process but I got the error message saying ""Cannot run the macro 'Personal!.'.The macro may not be available in this workbook or all macros may be disabled."" However, the macro is in this place for sure. Do you know why I have this message? Do I need to do something in Excel to ""enable Macro"" before Blue Prism could call it? Thanks a lot!   Wed, 10 Jan 2018 15:46:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57643#M11614 GeJiang 2018-01-10T15:46:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57644#M11615 By Creating personal.xlsb macro file, it'll open with each and every excel file which you open. So inside the personal.xlsb file if you're dealing with any code try to write code with ActiveSheet.. Here ActiveSheet will refer to current opened workbook's sheet. Steps to create and run Macros using BP: 1. Create a personal.xlsb file it will store (By default) copy that file and paste at ...... location which BP access will be there. 2. Open an excel --> go to File --> select Option --> select Trust Center --> Open Trust Center Setting --> Go to Trusted Location --> Add path of .xlsb file 3. Then we can directly use the Macro in Excel using BP by passing parameter  NOTE: If step number 2 is skipped, you'll get The macro may not be available in this workbook or all macros may be disabled this message.This is one time setting.   Sun, 14 Jan 2018 15:50:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57644#M11615 VijayDodamani1 2018-01-14T15:50:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57645#M11616 Hello !  MS Excel VBO dont have ""Run Macro"" option , Please help where to check. Thu, 15 Mar 2018 12:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57645#M11616 RamakrishnaVinn 2018-03-15T12:05:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57646#M11617 check the image below Thu, 15 Mar 2018 23:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57646#M11617 guna_vardhanmee 2018-03-15T23:01:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57647#M11618 MS Excel VBO that i have does not having Run Macro action at all , Is there a place where i can down load latest MS Excel VBO with Run Macro available  Mon, 19 Mar 2018 13:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57647#M11618 RamakrishnaVinn 2018-03-19T13:38:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57648#M11619 You can download it from portal it has al updated VBO's Sat, 24 Mar 2018 00:11:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57648#M11619 guna_vardhanmee 2018-03-24T00:11:00Z https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57649#M11620 Save the Macro Function in a Module, not in the worksheet. Otherwise you will get an error. Fri, 24 Aug 2018 17:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Call-Macro-VBA-Excel/m-p/57649#M11620 Anonymous 2018-08-24T17:30:00Z