Question

4
Replies
1611
Views
 Dinakara Prasad Hasthi (HDP_RPA01)
Accenture

Accenture
US
HDP_RPA01 Member since 2016 5 posts
Accenture
Posted: June 25, 2017
Last activity: June 26, 2017
Posted: 25 Jun 2017 20:40 EDT
Last activity: 26 Jun 2017 20:33 EDT
Closed
Solved

Excel Copy cell value and write into another cell

I'm new to PEGA studio. Can you please let me know how to copy a excel sheet cell value and write into another cell in another excel sheet.

When i run the automation i don't see the value was written to the cell. Attached the screenshot. Appreciate your help.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 26 Jun 2017 13:44 EDT
Mitchell Vega (Mitchell)
PEGA
Software Engineer
Pegasystems Inc.
US

From your screenshot, the automation does not seem to be connected to anything. Do you have anything that is triggering your automation to start? For example, an event like a button click?
Posted: 4 years ago
Posted: 26 Jun 2017 15:16 EDT
Dinakara Prasad Hasthi (HDP_RPA01)
Accenture

Accenture
US

On start of the automation the excel sheet opened by itself and hence I didn't added any triggering event.


Please suggest if I need to add any event, if yes what would be required.


 

Accepted Solution

Posted: 4 years ago
Posted: 26 Jun 2017 15:51 EDT
Ed Lebeau (Ed_Lebeau)
Comptech Associates Inc

Comptech Associates Inc
US

Create a Windows Form with a Button. Add the "Clicked" event to your automation you posted, and connect that "Clicked" event to the Properties Workbook Tile...