Search results

Hi Shweta, Try this code, Dim excel, sheet, range As Object Try wb = GetWorkbook(Handle, Workbook) ws = GetWorksheet(Handle, Workbook, Worksheet) wb.Activate() ws.Activate() excel = ws.Application sheet = excel.ActiveSheet range = sheet.Range(Reference) range.Select()...

Better solution for a case like this would be.... Read all the files from the Network path and refine with Regex or any filtering.. Say for example you need only ".xlsx". The collection will give you the file paths as well. If you want to use them , then loop them and that's it. Hope it...

Hey Camicat, Global send key doesn't work here. You should use Global Send Key Event... "<{CTRL}H>{CTRL}" Hope this will help you

So you want to replace a "." with "," and a ". " should be placed after the first number? If not please explain in detail.

You can use "Sort Collection" action in "Utility - Collection Manipulation" VBO and pass the Inputs Collection Name: On which collection you want to perform sorting. Sort Field: The column name in the collection on which the sorting should be based on. Ascending order: True is ascending and...

Hi Soraj, Which 0.00% you are trying to get? The one beside 35,002 value? or the one beside 1,379,630? If it is beside 1,379,630, will it have only one empty row above it as shown in the pic?

Take a counter of value 1 1. Create instance & Open Workbook 2. Get number of rows 3. Format Cell - Inputs : Cell reference is "A"&[Counter] ; Format is "##,###" Note: A can be changed according to the column required. 4. DecisionStage (Counter = Number of Rows) if No , Calc stage to Increment...

Hi Soraj, As per my understanding you want to get a cell value which is at the bottom row of a sheet but wanted to know which cell it is to get the value. If it is so . 1. Get Data into Collection. 2. Reverse the collection. 3. Copy first row into a temp collection. 4. Now Transpose the temp...

Hi Absak, Yes we can do it with Blueprism. There are 2 ways to do it. 1) One is to Create a loop of Format cell. Take a counter data item of initial value 1. a. Create instance b. Open Workbook c. Get number of rows d. Format Cell - Cell reference is "A"&[Counter] ; Format is...

Hi Kiran, As per my understanding, you are trying to open and spy an MS Access database file. Here is the way , we can achieve it. Set Application Modeller as Windows Application Type and pass the .accdb file in command line parameters and then launch it. But the only mode you can spy a .accdb...

Wait let me understand this clear. So you have some credentials in the main page of the process and that credentials has to be used in object too. if this is so, then go to object give the input parameters and then call that object's action in the process. Now open that action stage and you will...

Hi Patnaik, There is an action in MS Excel VBO called "Write collection" to write the data into excel from a collection which contains inputs like Handle: the reference you are using for that particular excel. Workbook name: the workbook to store the data. Worksheet name: the worksheet name in...