Clearing the Clipboard

[pcdaveh]

Does anyone know how to programatically clear the clipboard in VBA. I've seen the command clipboard.clear in VB but I haven't been able to get it to work in VBA. I have a process that is running and when it switches to another table. I keep getting the warning that there is a lot of data on the clipboard do you want to have it available the next time you want to paste. I have warnings turned off but this keeps coming up. So, I decided to try and clear the clip board.

Thanks!

 

[THoey]

I did a keyword search and found lots of posts. Try these in order as I think the first one is best:

thread181-13802
thread705-89946
thread181-103902

Hope that helps... Terry M. Hoey