ExcelBanter - How delete the cliboard

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How delete the cliboard (https://www.excelbanter.com/excel-programming/288007-how-delete-cliboard.html)

Aldo Miele

How delete the cliboard

I need to know under windows Xp how is possible thru a Excel Macro to delete
the values in the clipboard?

Clipboard.clear dosnt' work

Etien[_11_]

How delete the cliboard

Application.CutCopyMode = Fals

--
Message posted from http://www.ExcelForum.com

Ron de Bruin

How delete the cliboard

Hi Aldo

After you paste use this line
Application.CutCopyMode = False

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl

"Aldo Miele" wrote in message ...
I need to know under windows Xp how is possible thru a Excel Macro to delete
the values in the clipboard?

Clipboard.clear dosnt' work

Ed[_9_]

How delete the cliboard

This is how I do it with Windows 2000 and Excel 2000:

Dim doFName As MSForms.DataObject

Set doFName = New DataObject

doFName.SetText ""

doFName.PutInClipboard ' clears clipboard

HTH

Ed

"Aldo Miele" wrote in message
...
I need to know under windows Xp how is possible thru a Excel Macro to
delete
the values in the clipboard?

Clipboard.clear dosnt' work

All times are GMT +1. The time now is 07:32 AM.