Preventing an Excel Data Source from closing

S

Simon

Hi All,

Office 97 & Windows 97

Question: Is there a way to prevent an excel data source
from automatically closing when you close the
corresponding mail merge document?


I've set up 2 mail merge documents(called Ltr.doc &
Stat.doc) that both use data from the same excel data
source(Data.xls)

I've set up a macro to merge the documents it basically
works as follows:

1) Open Ltr.doc
2) Merge Ltr.doc to the printer
3) Close Ltr.doc
4) Open Stat.doc
5) Merge Stat.doc to a new document
6) Save the resulting new document
7) Close Stat.doc

The problem is that when Ltr.doc is closed (Step 3) it
automatically closes Data.xls. Then when Stat.doc is
opened it reopens Data.xls (step 4), this slows down
execution.

Finally when Stat.doc is closed (step 7) it prompts me
with a "Do you want to save your changes to Data.xls?"
message (this is caused by automatic functions such as
=TODAY() updating themselves when Data.xls is reopened)

Thanks in advance

Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro doesn't work any more 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Cell data entering slow! 0
Merging from an Excel file with graphics 1
Paragraph numbering in Word 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Unable to save changes to recipient list on networked drive 0

Top