VBA retrieve URL from Windows Clipboard

[ACFeddes]

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:

Please Login or Register  to view this content.

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

[Leith Ross]

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?

[ACFeddes]

Hello Leith,
thanks for reply.

I copy manually to the clipboard ([Ctrl C] and want to retrieve data either through a userform or 'only' by code (without the visual interface).

Regards,
Alex