Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export excel data to a word template using a macro
I am trying to poulate a word document with excel data using a macro
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
export excel data to a word template using a macro
I never found an efficient way to do this, I did find a hokey way to do
this though: In your word template run a macro that open your excel file. In the excel create a macro that runs when opened. In the excel macro, write what ever groups of text you need to multiple temporary text files, and have your macro close with out saving changes. Then have your word macro import the temp files one at a time where ever you want them, then delete them from the hard drive. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create macro for export excel data to word in to letters | Excel Discussion (Misc queries) | |||
export information from excel to word doc template | Excel Worksheet Functions | |||
Export excel data to word document | Excel Discussion (Misc queries) | |||
How can I Export data from to Access to an Excel Template | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) |