Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
Can't copy without clipboard open | Excel Discussion (Misc queries) | |||
How do I use a" item description" in excel to consolidate totals? | Excel Discussion (Misc queries) | |||
XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) |