View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tonja Tonja is offline
external usenet poster
 
Posts: 1
Default Opening a Word Document in Excel

Hi -
1. How do I open a specific word document from Excel?
The document is actually mail merged to the excel
spreadsheet (which isn't a problem).

Ex. I have excel doing a loop of about 200 calculations
which stores the information for the word doc. and it
prints off the results. Next, I want the word document to
open and run through a macro. I have the document to
close each time because I need the original document to
open for each calculation. This is handled through word -
no problem (I already have this programmed). However,
this leads me to my 2nd and final question.

2. How do I keep Excel from prompting me to save? I do
not want to have to hit cancel (about 200 times) everytime
the document closes.

*****If you can't answer 2 right away, that's okay, but
please help me with #1. I'm in great need of an answer.

XP is the OS.

Thanks so much!!!!!

Tonja