Search results

Use Run Macro Action in Ms Excel VBO object. Here u have to keep file extention as .xlsxm(macro enable). Open the excel , AND THEN RUN MACRO action give the macro name. Thats it. Faced any issue please reply.

@vmaneesh which keys are u using insince send key or send key events. That also matters. Uts better to use send key to enter the credential.

@naveedraza Thank u for this code.

@rajeev2509 yes we can if required. Better to go same way.

@ps4 does ur collection has the feild name that u wanna get. Please share the attachment of ur collection so that we can help u further. Thanks

@Ivan.Hurynenka The best way us using filter collection. Or if u know the fix position of ur row in the given column then use this particular method given below: 1.Get row count 2.In Collection Object use copy row action and provide the no. Of rows u wanna copy from collection. 3. Now u get...

@saurabh singh the best and relible one are shotcut commands for working in excel. For eg.To save we can use Send key event :<{CTRL}S>{CTRL} For File use:<{ALT}F>{ALT} For any issue just ping. Happy to help....

@saurabh singh U can use ui automation mode and region mode for cell.

@arjunk3110 Hi, Use MS-Excel VBO for ur work. In that use Save as Action for saving the file with the name u want. 1. Create instance 2. Open/Create the workbook 3. Save as action in MS EXCEL VBO give the handle and workbook name and file name as path and name that u wanna use. Eg...

@sivagelli @naveedraza Thanks for Your Reply. I have used vb.net code for this issue im sharing the same for ur reference. Code: moConnection = New OLEDBConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="& Excel_File_Path &";Extended Properties=""Excel 12.0 Xml;HDR=YES"";")...

@ritabrata7 Hi Team, I have solved the issue by using SQL-DATA VBO, in BluePrism. The object contains Action called as Execute is the one to call the Procedure by giving command in query- "EXEC Procedure_Name" and the work is done. Note : don't forget to set Connection before using any...

Hii, I m working with excel which has data around 80k to 1L per sheet. While taking the data in collection i get error of memory exception. What i wanna to do is to send the excel sheet data to sql table(tables are already created). And the call procedures which are also done. How can i...

Hii, Im also working on citrix application where we have to click on bottons , drag drop function enter input (Passwords), etc is to be done. I m stuck due to blueprism region mode is not working in my situation. Whenever i try to spy the excel (open in citrix) it gives me no result. I tried...

Hiii, I have sql (Mysql)procedure which i have to only call from blueprism. How should i do that??? Please help Thanks