The contents of the clipboard

D

dolivastro

Is there anyway I can get to the contents of the clipboard. What I
want is this:

1. Select the contents of some application, eg, PDF or word.
2. Move to Excel, and select a cell
3. Run a VBA module that will alter the contents of the clipboard in
some way (eg, removing LF, trimming blanks, etc)
4. Paste the contents of the altered clipboard into excel.

What I'm thinking of is this:

Text = [GetClipBoard] ' No such function that I know of
[Alter Text]
activecell.value = activecell.value + " " + Text


Dom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preserve contents of Clipboard when altering display options 9
How to clear the clipboard contents in VBA 1
Clipboard manipulation 8
Copying cell text to clipboard (using Putinclipboard) 2
<Parent> of the Clipboard 5
clipboard doesn't always save contents 6
column to row macro 4
VBA: Answer YES to Contents of Clipboard 3

Top