Thread: VBA retrieve URL from Windows Clipboard

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:

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. www.test.com or a physical computer address, i.e. file:///C:\Users\ACF\Documents\test.xls) at the bottom when I paste text from the clipboard.

Does anyone know how to do this?
Regards,
Alex

Hello ACFeddes,

Welcome to the Forum!

It probably can be done but the answer depends on how the data is getting to the clipboard. Are you doing it manually or by code?