Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear Clipboard after Copy
I am using the following code to cut and paste data from a csv file
into a sheet within a workbook. The problem is that when I close the csv file, I get prompted as to whether or not I want to save the contents of the clipboard as the clipboard contains a large amount of data. How do I clear the clipboard to avoid this prompt? Any help would be appreciated. Thanks! Connie ************************************************** ************************************************** ************* Set wkbk = ActiveWorkbook Set sh = Worksheets("Employee List") Set wb = Workbooks.Open(FileName:= _ "C:\Documents and Settings\Connie Maldonado\My Documents\Mastec\Employee List\hourly employees.csv") wb.Worksheets(1).Cells.Copy wkbk.Worksheets("Employee List").Cells.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=False wb.Close savechanges:=False |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear Clipboard after Copy
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What if copy crtl+c is not working it says cannot empty clipboard | Excel Discussion (Misc queries) | |||
Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
how to copy on double-click the cell value to Clipboard | Excel Worksheet Functions | |||
how to copy on double-click the cell value to Clipboard | New Users to Excel |