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!

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

VBA retrieve URL from Windows Clipboard

Status
Not open for further replies.

ACFeddes

Programmer
Jun 18, 2007
11
NL
When you paste text In OneNote from either the Web or a file on the computer, it pastes at the bottom the URL to the source.
Clipboard managers like Clipmagic shows the data copied to the Windows clipboard with the relevant URL (indicating that the data should be available on the clipboard).

I'm able to retrieve (access) text from the clipboard:

Code:
Dim MyData As DataObject
Set MyData = New DataObject
Dim strClip As String
MyData.GetFromClipboard
strClip = MyData.GetText
TB1 = strClip

But I would like to do the same as OneNote does and include the URL to the source (either Web address, i.e. or a physical computer address, i.e. file:///C:\Users\ACF\Documents\test.doc) at the bottom when I paste text from the clipboard.

Does anyone know how to do this?
Regards,
Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top