View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default writing excel data into word document

Couple of suggestions:

This code 1st tries to 'hijack' a running instance of Word (very bad
practice) instead of using its own automated instance from the start. I
recommend you just go with CreateObject()!

What are you using Word for that you can't just use a blank worksheet
in Excel for your report? (I've never found anything Word can do that
can't be duplicated in Excel!!!) You can use a template sheet and just
populate it with your data laid out in the report format.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion