Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using vba to copy from excel to embedded word doc
I am writing a macro which embeds a blank Word document
into an Excel spreadsheet. After embedding the document (which works), I want to copy information from the Excel spreadsheet into the embedded Word document. Although I can manually copy and paste the information, I cannot figure out how to get the macro to do this. When I use record macro, it stops recording as soon as I enter the Word document. When I look directly at the code, I can't find a command that will do the pasting? Is there a way to do this? If so, what is the code for it? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using vba to copy from excel to embedded word doc
I have the same problem, I am still using Office 97 and I am trying to sort
out a macro which will allow me to filter an excel document - save the information in to a new excel document - then mail merge it with a Word Template. The macro I created seems to remember everything within Excel, but completely ignores everything else outside the application. I wasn't sure if there was a way round this or whether I needed to get a separate macro creator which doesn't mind what application you are in? Have you managed to find a way around this yet? Paul "susan b." wrote: I am writing a macro which embeds a blank Word document into an Excel spreadsheet. After embedding the document (which works), I want to copy information from the Excel spreadsheet into the embedded Word document. Although I can manually copy and paste the information, I cannot figure out how to get the macro to do this. When I use record macro, it stops recording as soon as I enter the Word document. When I look directly at the code, I can't find a command that will do the pasting? Is there a way to do this? If so, what is the code for it? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
size an embedded word doc in Excel | Excel Discussion (Misc queries) | |||
how to copy an embedded image into excel from word or from any oth | Excel Worksheet Functions | |||
Excel with an embedded Word Doc | New Users to Excel | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
excel with embedded word doc | Excel Programming |