Hi,

I am writing a macro program which copies the contents whole sheet1 of
workbook1 and paste it to sheet1 to workbook2. After that, the program closes
workbook1. But I always got a prompt and saying that I have a large amount of
information in Clipboard and it askes if I want to be able to paste into
another program later. Actually I don't want this prompt and closes workbook1
directly. Anyone knows how to bypass this programatically?
Thanks!

Ivan

Hi Ivan,

See Chip Pearson's Clipboard page at:

http://www.cpearson.com/excel/clipboar.htm

See particularly the section at the foot of the page entitled:
'Clearing the Clipboard'


---
Regards,
Norman



"Ivan" wrote in message
...
Hi,

I am writing a macro program which copies the contents whole sheet1 of
workbook1 and paste it to sheet1 to workbook2. After that, the program
closes
workbook1. But I always got a prompt and saying that I have a large amount
of
information in Clipboard and it askes if I want to be able to paste into
another program later. Actually I don't want this prompt and closes
workbook1
directly. Anyone knows how to bypass this programatically?
Thanks!

Ivan

Ivan:

try,
Use Application.CutCopyMode = False

example,

****.copy
.................

****.Past
Application.CutCopyMode = False
--
天行å�¥ï¼Œå�›å*�以自強ä¸�æ�¯
地勢å�¤ï¼Œå�›å*�以厚德載物

http://www.vba.com.tw/plog/


"Ivan" wrote:

Hi,

I am writing a macro program which copies the contents whole sheet1 of
workbook1 and paste it to sheet1 to workbook2. After that, the program closes
workbook1. But I always got a prompt and saying that I have a large amount of
information in Clipboard and it askes if I want to be able to paste into
another program later. Actually I don't want this prompt and closes workbook1
directly. Anyone knows how to bypass this programatically?
Thanks!

Ivan

Hello Ivan,

Application.CutCopyMode = False

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=487502