Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clearing Clipboard after DataToClip Method
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Clearing Clipboard after DataToClip Method
Miscellaneous
Thread ID:
00857933
Message ID:
00857933
Views:
61
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
Map
View

Click here to load this message in the networking platform