Office clipboard macro

B

Brian Holfield

From docA I first clip TextA to the Offfice Clipboard, then I clip
TextB to it.
In docB I record Mymacro with these actions: First I open the
clipboard, then paste TextB, then delete TextB from the clipboard. Now
I paste TextA from the open clipboard, then delete it from the
clipboard. Now I close the clipboard.

When I next have a new TextA and Text B on the clipboard I run Mymacro.
It pastes TextB two times and leaves TextA and TextB on the clipboard.

Any way to get the macro to do what I need, that is paste TextA and
TextB and delete them from the clipboard?
 
D

Doug Robbins - Word MVP

Tell us exactly what it is that you want to do. There may be other, better
ways to do it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
B

Brian Holfield

In DocA, clip TextA and clip TextB.
In DocB
insert a table with one row and two columns
paste TextB into the left cell
paste TextA into the right cell
 
D

Doug Robbins - Word MVP

But what are TextA and TextB? How are they arranged in the original
document?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
B

Brian Holfield

TextA is any selection of text which I choose.
TextB is any other selection of text which I choose.
There is no repeatable pattern of relationship between the two
selections.
That is why I was clipping them onto the clipboard.
Putting them in was no problem. Getting them back out was the problem.
I imagine the selections could be trapped as varA and varB in a program
instead of using the clipboard.
 
B

Brian Holfield

Thanks, Paul
Looked at ClipMate, but it needs more clicking around to accomplish
what I want than I currently need to do in Word itself.
To recap:
In a document I need to select and clip two separate pieces of text.
In another document with one click on one button I need to:
insert a table of 1 row and 2 columns
paste text B in the left hand cell and paste text A in the right hand
cell
clear the clips from memory.
 

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

Top