Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
create macro using data in excel ss to word
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
create macro using data in excel ss to word
Ann wrote:
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 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/communities...ba.beginner s) to get assistance. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro: Fill Word with data from Excel | Microsoft Word Help | |||
How do I create a macro to data sort in a table within a protecte. | Tables | |||
How do I create a report in Word from data in Excel, I need to au. | New Users | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help |