| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Word and Excel in one Macro
I need to copy and paste lots of graphs (over 600) from
Excel into word. I can get a macro to copy in Excel, and a macro to paste in Word, but I can't link the two together. Can any suggest a way of doing this? Thank you Ian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Word and Excel in one Macro
Hi Ian
Let one of the apps take control and do everything, don't try to make Excel run a Word macro. See mr Erlandsens page "Control Word from Excel": http://www.erlandsendata.no/english/...olecontrolword -- HTH. Best wishes Harald Followup to newsgroup only please "Ian Belcher" skrev i melding ... I need to copy and paste lots of graphs (over 600) from Excel into word. I can get a macro to copy in Excel, and a macro to paste in Word, but I can't link the two together. Can any suggest a way of doing this? Thank you Ian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Word and Excel in one Macro
A few more hints might be helpful:
http://www.geocities.com/jonpeltier/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Harald Staff wrote: Hi Ian Let one of the apps take control and do everything, don't try to make Excel run a Word macro. See mr Erlandsens page "Control Word from Excel": http://www.erlandsendata.no/english/...olecontrolword -- HTH. Best wishes Harald Followup to newsgroup only please "Ian Belcher" skrev i melding ... I need to copy and paste lots of graphs (over 600) from Excel into word. I can get a macro to copy in Excel, and a macro to paste in Word, but I can't link the two together. Can any suggest a way of doing this? Thank you Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel to Word Macro | Excel Discussion (Misc queries) | |||
| Excel to word macro | Excel Discussion (Misc queries) | |||
| Using Word from Excel Macro. | Excel Discussion (Misc queries) | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Macro - Open Word with Excel macro | Excel Discussion (Misc queries) | |||
![Ian Belcher[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
