Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clipboard Object

Status
Not open for further replies.
chesterex

chesterex

Technical User
Joined
May 23, 2001
Messages
4
Location
CA
Is it possible to treat the clipboard as an Object in VBA.
I know in VB6.0 you can simply write Clipboard.GetText and it gets the text from the clipboard. Is this possible in VBA?
Any help appreciated.
Thanks
Tim
 
Sort by date Sort by votes
Try this Code:

Sub GetFromClipboardToImmediateWindow()
Set MyData = New DataObject

MyData.GetFromClipboard
Debug.Print MyData.GetText(1)
End Sub

Assaf
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rj771972
  • Question Question
Powerpoint VBA - Assign manipulate object
Replies
1
Views
188
rj771972
rj771972
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
morechocolate
  • Locked
  • Question Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
2K
morechocolate
morechocolate
DylaBrion
  • Locked
  • Question Question
Excel VB - Object Reference not set to an instance of the object?
Replies
18
Views
908
DylaBrion
DylaBrion
DylaBrion
  • Locked
  • Question Question
VB to Resize inserted object into Cell on Excel Worksheet
Replies
2
Views
255
DylaBrion
DylaBrion

Part and Inventory Search

Sponsor

Back
Top