Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Macro stops with "Large Amount of Data" Message

I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Macro stops with "Large Amount of Data" Message

You might like to add this to your macro before closing the workbook:

Application.DisplayAlerts = False

This will suppress the error message. Then turn it back on again with
this:

Application.DisplayAlerts = True

Hope this helps.

Pete

On Nov 12, 1:09*am, dhstein wrote:
I have macro that copies some data from a workbook and then tries to close
it. *I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". *Is there a
way to suppress that message so the macro will complete? *Thanks.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Macro stops with "Large Amount of Data" Message

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1



"dhstein" wrote:

I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 81
Default Macro stops with "Large Amount of Data" Message

Before closing the file, execute the following statement:

Application.CutCopyMode = False

If the problem still continues, which it may, copy a single cell. This will
make the contents of the clipboard very small and thus eliminate the
message.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"dhstein" wrote in message
...
I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there
is a
large amount of data in the clipboard - and I need to click "OK". Is
there a
way to suppress that message so the macro will complete? Thanks.




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Macro stops with "Large Amount of Data" Message

Thanks for the information - it worked great

"FSt1" wrote:

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1



"dhstein" wrote:

I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display "macro-free workbooks - VB project message" on closing Exc Gary Nguyen Excel Discussion (Misc queries) 4 April 4th 23 12:41 PM
How to disable "There is a large amount of data on the clipboard..." Bill Board Excel Discussion (Misc queries) 5 July 30th 08 12:10 AM
Help with handling large amounts of data - determine "MIN IF" ? Rayo K Excel Worksheet Functions 1 October 23rd 07 01:31 AM
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" Dennis Excel Discussion (Misc queries) 0 July 17th 06 03:38 PM
Utility to "clean up" or "defrag" large Excel file Sabrina Excel Discussion (Misc queries) 3 January 12th 06 10:57 PM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"