Printable View
I know where in my script my clipboard fills up and i put in a clipboard clear but I still get an system message saying my clipboard is to full and asks if i want to keep or remove the data. Is there somewhere i can set the size of the clipboard a little larger.
Are you copying anything back to clipboard after Clipboard.Clear
I have never seen a message like that.
Could you post a screen shot?
show the code where you are getting the problem
How much data are you trying to put in the clipboard?
I tried 128 MB, but VB told me it was out of string space!
I'm copying a excel sheet. I'm not sure the size of the sheet it's self, but there is only 10 lines in it so it can't be that big. I did read somewhere the size of the clipboard is dependent on the memory in your computer. I'm on an older computer with 512 meg of ram. My hard drive is getting close to full. I think that might be my problem. I will know better when I run the program on another system when it's done.
Could you post the screen shot of the message you get, or at least exact text of the message?
Here is a screen shot. Sorry it took so long i had other issues to deal with. Now I seriously need help with this problem. How can I disable this message.
Actually, that message doesn't say that the clipboard is full. It simply says that there is data in it, and it is asking you if you want it saved there after Excel exits or should Excel clear the contents.
That's Excel asking you... and it's not because you're running out of resources... but rather because what you do have consumes a lot. So when Excel (and Word and Access and Visio and most other Office apps do this too) closes, it is asking if you want to keep the clipboard data so you can paste it else where, or are you done with it, in which case ti will clear the clipboard for you.
-tg
Maybe the solution would be to clear the clipboard before you exit Excel.
as it is an excel alert, you should be able to prevent it by setting the displayalerts of the excel object to false
application.displayalerts = false
change application to you excel object, make sure not to conceal any alerts you still want
the clipboard clear worked. I had that already in the program but I put it in after Excel closed. When I moved it to the line before Excel closed the problem was gone. Thank you for your help.