Creating a command to clear clipboard in Excel 2010

Question

I would like to make a command that will clear (reset) Clipboard while I am using Excel 2010.

I would prefer this as a button in Excel, but it can be a shortcut on the desktop as well.

Is there any way to make something like this in Windows 7(32-bit).

I am making this because as I copy data from one excel file to another, I run out of free RAM memory and at that point my computer crashes.

You could easily write a script in AutoIt or autohotkey to clear the clipboard contents. In AutoIt, ClipPut() passing an empty string will clear the clipboard. — MaQleod, Jul 2, 2013 at 4:31

itmilos · Accepted Answer · 2013-07-02 14:09:53Z

3

This can be done within the excel in two steps.

Fist step

Step One

Second step

Step Two

answered Jul 2, 2013 at 14:09

itmilos

3855 silver badges15 bronze badges

Add a comment |

matan129 · Accepted Answer · 2013-07-02 05:20:26Z

0

Download and install AutoIt (full installation)
Open SciTE Script Editor
Write ClipPut("") and save the file.
Open Compile Script to .exe (x86), browse to you script file you have created earlier and choose a destination (exe) file and click Convert

Now whenever you run it it will clear the clipboard (you also can uninstall autoit now, because the exe file is standalone).

answered Jul 2, 2013 at 5:20

matan129

1,9502 gold badges18 silver badges24 bronze badges

Add a comment |

2 Answers 2