Search results

Hi, Can any one tell me how to extract data from Windows/Desktop application using Blueprism? is there any way?

Hi, One of the external API is adding data to the queue. Once it is added automatically my bot should execute that data immediately? How it can be done?

Hi, I am trying to apply autofilter to one of my date column inorder filter data between two dates. I am using code stage to achieve this, below is the code I am using GetWorkbook(handle,Nothing).Worksheets(sheetName).Activate...

Hi, I am reading data from excel where it has around 20 column. One of the column is a date format( eg. 28-02-2019)... But after reading it the value is coming as Date Time. How Can I get only date value?

Hi, I have spied elements using AA and UI mode in internet explorer for particular web page. It works fine till date in my local machine. But when i moved this to Cloud environment none of the elements spied using AA and UI mode is not working. When I tried to identify the same element again it...

Hi, I want to execute below like query using oledb (referring two different excel) UPDATE [Onboarded resources$] a SET End_Date = (SELECT End_Date FROM [Sheet1$] b where b.POP_Notes_ID=a.Notes_ID); How can a

Hi, I want to copy the file to clipboard is there any utility available to do that?

Hi, I am sending email using pop3 vbo (using GMAIL as host) but after sending email I am not able see that mail in the sent item of Gmail account. How can I Make that as visible?

Hi, Can any tell me how to read top 10 mails using lotus notes VBO ?

Hi, Attached is the snap of my excel which contains charts. Once the new set of datas are inserted i need to update the data range of the graph with updated row number. Currently i am achieving this by the combination of sending global send key event and Region mode. It is working fine. But...

Hi, I am using below code in MSExcel VBO object to unhideAll rows and columns across all sheets in excel For Each ws In GetWorkbook(handle,Nothing).Worksheets ws.Activate ws.Columns.EntireColumn.Hidden = False ws.Rows.EntireRow.Hidden = False Next ws. the code is working fine when...

Hi, What are dll and NameSpace required to use Micorsoft.Office.Interop.Excel

Hi, Now a days my BP tool is hanging and also it is very slow. For one of the use case i am regressive testing with huge amount of data. Should want to do any clean up activities in environmental level like clearing templogs and other temps stuffs?

Hi, I am using below script for insert copied cell by shifting the cell down With GetWorkbook(handle,Nothing).ActiveSheet.Range("B15:I47") GetWorkbook(handle,Nothing).ActiveSheet.Rows(24).Resize(.Value).Insert GetWorkbook(handle,Nothing).ActiveSheet.Rows(23).Resize(.Value +...

I am automating excel which has graph and charts. But sometime warning window is appearing in the excel which is breaking the code. This is general warning. How Can i suppress this.?

Hi, How I can get the formula of a particular cell in excel.

Hi , I want to find the row and column index of particular value in excel. How can I achieve this using Blue prism? Eg: if "State" is in A1,B1 then in my code if I pass state it should return the index as A1:B1 some thing like this.

Hi , I have source file which has around 500 records before reading entire excel into collection I want to add one column called filter key and need apply formula for that column like = concat("I1","J1"). How i do this ? I am new to BP and I am from Java background. So, if anything need to...

Hi, I have a collection of data populated based on some business logic which originally populated from one the source excel. Now after updating this collection of data I want to add to this to the excel. For which the requirement is like, First copy the source file and paste in the new...

Hi, I have below scenario, I have two collection let say: Collection 1 Collection 2 Now I will iterate collection 1, for each iteration I will check in collection2 whether that particular value is present or not If presetn I will fetch the entire row data from collection 2 and will placed it...