Office clipboard macro

  • Thread starter Thread starter Brian Holfield
  • Start date Start date
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?
 
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
 
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
 
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
 
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.
 
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.
 
Back
Top