Thanks to Mark for sorting my last query out... I've another question now.

Part of my procedure is responsible for controlling a 3rd party app to run a query, the results of which are copied to the clipboard when completed (and then pasted into the excel workbook). It's got to be done this way as although the app DOES support DDE it's useless, like pre-1998 software!

It is essential that the contents of the windows clipboard are emptied before this procedure is run - but I can't seem to control it properly. I'm running Win2K and Office2K.

How do I clear the clipboard using VBA?

Ad.