ExcelBanter - Item in clipboard

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Item in clipboard (https://www.excelbanter.com/excel-worksheet-functions/7181-item-clipboard.html)

jamessinc

Item in clipboard

I have a macro that will open a file and copy a range to another file. Then
I will close the file I copied the range from but I am asked if I wish to
clear the clipboard after each copy. How do I stop the clipboard request
from stoping the macro?

Thanks
Jim

Frank Kabel

Hi
try
application.displayalerts=false
'close the file
application.displayalerts=true

"jamessinc" wrote:

I have a macro that will open a file and copy a range to another file. Then
I will close the file I copied the range from but I am asked if I wish to
clear the clipboard after each copy. How do I stop the clipboard request
from stoping the macro?

Thanks
Jim

Gord Dibben

Jim

After the copy and paste is complete and before you close the file add this
line

Application.CutCopymode = False

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 03:05:02 -0800, jamessinc
wrote:

I have a macro that will open a file and copy a range to another file. Then
I will close the file I copied the range from but I am asked if I wish to
clear the clipboard after each copy. How do I stop the clipboard request
from stoping the macro?

Thanks
Jim

All times are GMT +1. The time now is 09:45 PM.