General information
Category:
COM/DCOM and OLE Automation
Title:
Clearing Clipboard after DataToClip Method
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only