Excel Data Transfer Actions
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-18 12:01 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-03-18 12:29 PM
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
