Recent content by Ritansh_Jatwani

Hi @tiger19 , Please uncheck parent URL as well since sometimes the URL keeps on changing in various websites so there should not be any dependency on the parent URL as well. Also, are you using sufficient wait stages to make sure the speed from control room is not that fast that it just...

For changing the background color of a cell using Blue Prism, please refer the below video which teaches step by step execution using blue prism:

Hi @tiger19 , It seems you are using a lot of attributes in the application modeller which are not required. Just try using limited set of attributes such as Tag name, input type, Match Index, Path, ID (optional). Try using the above attributes and then run the bot. If you again face issues...

Hi @meghanirale , In Excel 1, create a new column and insert the formula to concatenate both the column data i.e. name and number using CONCATENATE function of Excel. Similarly, perform the same action in Excel 2 as well. Now perform a vlookup on Excel 2 to search for the records in Excel 1...

Hi, To remove filter from Excel using Blue prism, please refer the below video:

Hi, To perform autofit in Excel cells, please refer the below video:

For applying filter in Excel using blue prism, please refer the below video:

Hi, If you want to remove duplicates from a single column, please refer to the below video:

ActiveWindow can also be used like ActiveWorkbook or ActiveWorksheet, its just we should be aware about the parent of the ActiveWindow. The parent of ActiveWindow is Excel Application which can be easily identified using the workbook name. I have written the vb.net code to freeze the panes in...

Please refer the video for setting filter in Excel using Blue prism: Hope it helps