Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to clear clipboard programatically?
Message
From
20/10/2003 16:22:46
 
 
To
20/10/2003 16:07:35
General information
Forum:
Visual Basic
Category:
VBA
Miscellaneous
Thread ID:
00840444
Message ID:
00840449
Views:
17
>A coworker, in another department, has an Excel spreadsheet where he runs a VBA macro. They get an error when it tries to save saying "not enough memory".
>
>I have not seen the code, but they suspect it might be related to the clipboard having lots of saved data. They confirm they do a copy/paste in the program and they would like to clear the clipboard before saving, to make sure.
>
>I am not a VB expert. Is there some code (VBA or even WinAPI) to clear the clipboard?


Never mind. A quick search in Google (which should've been done before posting < g >) gets these:
http://www.mvps.org/word/FAQs/MacrosVBA/ManipulateClipboard.htm
http://www.cpearson.com/excel/clipboar.htm
http://www.visualbasicforum.com/t100104.html
http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm

I sent them to the worker in question to see if they help. Notice that one of them gives an alternate as more efficient that copy/paste.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform