PC Review


Reply
Thread Tools Rate Thread

Clear clipboard memory

 
 
John
Guest
Posts: n/a
 
      30th Aug 2007
After running the following, how do I keep the message of "Do you want to
keep the large amount..blah blah" Yes No Cancel?

Dim bk as Workbook
set bk = Workbooks.Open( Filename:="C:\temp\jul 07.xls")
bk.Worksheets(2).Range("B216:Y242").Copy

ThisWorkbook.Activate
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Thanks,
John


 
Reply With Quote
 
 
 
 
New Member
Join Date: Aug 2007
Posts: 18
 
      30th Aug 2007
Sorry...not sure quite what you mean...do you want the message to come up or do you want to clear the clipboard?
 
Reply With Quote
 
JW
Guest
Posts: n/a
 
      30th Aug 2007
Application.CutCopyMode = False

John wrote:
> After running the following, how do I keep the message of "Do you want to
> keep the large amount..blah blah" Yes No Cancel?
>
> Dim bk as Workbook
> set bk = Workbooks.Open( Filename:="C:\temp\jul 07.xls")
> bk.Worksheets(2).Range("B216:Y242").Copy
>
> ThisWorkbook.Activate
> Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
> False, Transpose:=False
>
> Thanks,
> John


 
Reply With Quote
 
John
Guest
Posts: n/a
 
      30th Aug 2007
Thank you!

John
"JW" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Application.CutCopyMode = False
>
> John wrote:
>> After running the following, how do I keep the message of "Do you want to
>> keep the large amount..blah blah" Yes No Cancel?
>>
>> Dim bk as Workbook
>> set bk = Workbooks.Open( Filename:="C:\temp\jul 07.xls")
>> bk.Worksheets(2).Range("B216:Y242").Copy
>>
>> ThisWorkbook.Activate
>> Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=
>> _
>> False, Transpose:=False
>>
>> Thanks,
>> John

>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to clear window's clipboard memory? Eric Windows XP General 10 10th Apr 2010 08:41 PM
How to clear clipboard memory? Eric Microsoft Excel Misc 2 6th Apr 2010 06:09 PM
error in code, Clear Clipboard Memory Corey Microsoft Excel Programming 4 8th Nov 2006 04:53 AM
Do you wish to clear clipboard memory? =?Utf-8?B?V2VuZHlVSw==?= Microsoft Excel Programming 2 4th Feb 2005 01:51 PM
cannot clear clipboard when clipboard appears empty =?Utf-8?B?U2hhbmk=?= Microsoft Excel Misc 1 4th Nov 2004 02:58 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:29 PM.