Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement