create macro using data in excel ss to word

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

i'm trying to create a macro to copy data put into specific cells from excel
into an already built table into word. i started macro, went to excel,
highlighted the 3 cells, used the copy button, went to word, used the paste
button and stopped recording. when i ran the macro, it told me my clipboard
was empty.
tia
 
Ann said:
i'm trying to create a macro to copy data put into specific cells
from excel into an already built table into word. i started macro,
went to excel, highlighted the 3 cells, used the copy button, went to
word, used the paste button and stopped recording. when i ran the
macro, it told me my clipboard was empty.
tia
Click to expand...

Word's macro recorder can't follow you into Excel. That means there won't be
any code in the macro to represent selecting cells and copying.

You're going to have to write some of that code without the recorder's help.
If you don't know how, then post a detailed description of the task in the
vba.beginners group
(http://www.microsoft.com/communitie...t.aspx?dg=microsoft.public.word.vba.beginners)
to get assistance.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top