How do you close word from access using VB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I click on a button on myt access form which:
1. Opens Merge document in word
2. merges data
3. Prints the ouput to the default printer
4. NEVER closes the original merge & merged document as well as leaving
Word open.

I would like to eliminate #4

Please help

Thanks
Jim Rendant
 
Hi Jim

Somewhere in your code your will have opened an instance of Word..i.e.

Set WordBasic = CreateObject("Word.Basic")

....and once you finished processing and want to close Word, then simply call

Set WordBasic = Nothing


Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top