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.
@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....
@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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.