Excel application scope doesn't save pasted values (the values are pasted with hotkey because are saved in clipboard)


#1

Hi:

I am trying to copy the values from a Excel file in a citrix environment to a Excel file saved in my desktop. I already copied the values with hoykey, get from clipboard and set to clipboard:

1

Then I paste the copied values in the Excel saved in my desktop (I add a message box activity to see if the robot is pasting the values):

When the robot arrives to the message box activity, we can appreciate that the values was pasted; nevertheless, when I click “Ok”, the Excel Application Scope activity closes the excel, the robot ends, I open the Excel and I can see that the values pasted wasn’t saved.


I would be grateful if you can help me to know why the pasted values are not saved.

Thank you!


#2

Hi Dgbaenar,

This is a somewhat strange issue, but I have a theory as to why this is happening. I noticed that the AutoSave property automatically saves on “each change activity”. I’m wondering if the Excel Application Scope doesn’t consider pasting into the Excel file to be a “change activity” as it’s not an Excel activity.

In terms of getting this to work, the first thing I’d suggest trying would be adding the “Save Workbook” activity to the end of your Excel application scope, as I think this should resolve the problem. Let me know if you’re still having issues!

Best,

Evan


#3

Evan_Bruns

Thank you for your answer, it worked adding the “Save Workbook” activity :slight_smile:


#4