cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Data Transfer Actions

HumpigouniHaree
Level 3
Hi All, I need to give the right click on particular cell in excel sheet and select the cut option from the list.can any one give the suggestion for this.
1 REPLY 1

BastiaanBezemer
Level 5
Hi Harsha, Right Click & Cut = Reading the value of the cell into the clipboard, and empty the cell. Use the Excel VBO, to first read out the cell value, and store it in a data item. Then use the Excel VBO to write """" (an empty string) to that cell... And with the cell value which is in your data item, you can do whatever you want; Even moving it to the clipboard with the object Utility - Environment and the action Set Clipboard