View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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