VB and VBA Users Source Code: Re: Copying data to and from Excel to the clipboard using the data object

VB/VBA Source Code
Re: Copying data to and from Excel to the clipboard using the data object

By:	Chap Lui
Email (spam proof):	Email the originator of this post
Date:	Wednesday, September 22, 2004
Hits:	958
Category:	Unspecified

Article:
Hi, I'm having problem with trying to use code to copy to/from clipboard. Mainly, it's a compile error saying: "User-Defined type not Defined" For example, even sample code from below, the error msg appears and the DIM objData as DataObject is highlighted. Sub ClearClipboard() Dim objData As DataObject Set objData = New DataObject objData.SetText ("") objData.PutInClipboard If OpenClipboard(0&) <> 0 Then Call EmptyClipboard Call CloseClipboard End If End Sub
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder