>>All,
>>
>>I have an application that copies about 8,000 records from a table to the clipboard using the DataToClip method and then pastes the data to an existing Excel workbook. This part work fine. However, If I open up the workbook in Excel and view the Office Clipboard, the clipboard still has my copied records in it. As a work-around, after pasting I then copied only one record to the clipboard so that the clipboard memory req'ts are much lower. However, this still is not a very elegant solution.
>>
>>Using the macro recorder in Excel to see the VB code when I manually cleared the clipboard indicated that the
>>
>>obj.Application.CutCopyMode = "False"
>>
>>statement should have worked but it didn't do anything from the VFP application. Any ideas or hints (such as the DataFromClip method)?
>>
>>Stephen
>
>How about:
>
>

>_cliptext = ""
>

>
>(in VFP)

Hilmar,
This makes for an even smaller clipboard content than the two-record workaround but still doesn't get rid of the clipboard contents entirely. I tried various combinations of CLEAR, RELEASE, CLOSE and setting to .NULL. of the _CLIPTEXT variable but none of these worked either.