How to clear clipboard content programatically
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 |
How to clear clipboard content programatically
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 |
How to clear clipboard content programatically
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 |
How to clear clipboard content programatically
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 |
All times are GMT +1. The time now is 08:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com