About Us

Connie

Thanks, Paul. This worked!

Connie

paul wrote:
at the end of you cut copy pricedure
Application.CutCopyMode = False
--
paul

remove nospam for email addy!

"Connie" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What if copy crtl+c is not working it says cannot empty clipboard	Heidi	Excel Discussion (Misc queries)	0	June 27th 06 11:38 PM
Disable Cut & Copy then restore on exiting	sparx	Excel Discussion (Misc queries)	0	April 30th 06 08:43 PM
reminder notifications in a column	L Mieth	Excel Discussion (Misc queries)	6	June 10th 05 11:00 AM
how to copy on double-click the cell value to Clipboard	cyrille	Excel Worksheet Functions	2	February 15th 05 05:56 PM
how to copy on double-click the cell value to Clipboard	cyrille	New Users to Excel	2	February 11th 05 11:29 PM

Menu

About Us