Revathi Sowmya
New Member
Hi......How to run a link given in excel one by one in Internet explorer, Google chrome and Mozilla....Using Blue Prism..........Please anyone help me with this...........
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
HOW TO RUN LINK WRITTEN IN EXCEL
- Thread starter Revathi Sowmya
- Start date
Hi,
You can get the cell values in to a collection from excel and using loop stage you can achieve this.
Use 'Run Process' action of Utility - Environment VBO with Inputs:
Post back if this works!
You can get the cell values in to a collection from excel and using loop stage you can achieve this.
Use 'Run Process' action of Utility - Environment VBO with Inputs:
Application: Path for IE or Chrome or Firefox
Arguments: [Collection.Value] which contains the link value
Post back if this works!
Revathi Sowmya
New Member
Sir am Attaching the errors am facing while doing the program
Revathi Sowmya
New Member
Revathi Sowmya
New Member
Hi,
You can get the cell values in to a collection from excel and using loop stage you can achieve this.
Use 'Run Process' action of Utility - Environment VBO with Inputs:
Application: Path for IE or Chrome or FirefoxArguments: [Collection.Value] which contains the link value
Post back if this works!
Attachments
Revathi Sowmya
New Member
Revathi,
1. Use 'start process' action with the path of exeutable file, not the path of shortcut.
2. Can you share the collection screenshot , the error says that the field value is not matching.
3. Also, share a screenshot of the entire process flow
Attachments
Revathi Sowmya
New Member
Revathi Sowmya
New Member
Sorry Sir i didn't get ............
Revathi Sowmya
New Member
Revathi Sowmya
New Member
There is no header for the collection, that is causing error when you are using [data1.Value] . You can either add a header to you Excelsheet do OR you can add a field of type text to the collection; making the collection a defined collection.
Attachments
Revathi Sowmya
New Member
Sir Thank You SO MUCH..............It Worked...i Got How to do
Alright! To your excel column add a header, meaning, to the top row of the column. Let's say you have data in column A in you excel sheet, the value in cell A1 is treated as header to identify the column.
Put 'Value' in the top cell of the column, that should fix the error if you are using [Data1.Value] as argument in the 'Start Process' action.
Put 'Value' in the top cell of the column, that should fix the error if you are using [Data1.Value] as argument in the 'Start Process' action.
Cheers!Sir Thank You SO MUCH..............It Worked...i Got How to do