Printing OLEObject from Excel

Hi All,

I'm trying to insert some code into my worksheet to print a word document that is embedded (not linked, there are no file paths) in the worksheet. I have it working right now using this code:

Please Login or Register  to view this content.

The problem is that I get multiple WINWORD.EXE instances running even though I have WordApp.Quit and Set WordApp = Nothing lines of code further down as well. Does anyone know why this is happening or if there is a more efficient way to print an embedded Word document from Excel? This is the first time I've ever customized Excel, usually I work in ArcMap. The documents are embedded, not linked, for the same reason I have to write this code in the first place; the people using the workbook are not computer friendly so we're trying to automate things from simple buttons and forms as much as possible.

Thanks in advance for the help!

Hello GISgirl,

Welcome to the Forum!

There are some rules you need to be aware of when you post.
1. Your thread title should clearly describe your problem or question.
2. To make the code easier to read and copy, format it with Code Tags.

Because you are new, I have wrapped the code for you.

As a new member, please take some time to familiarize yourself with the rules.
Forum Rules

Hello GISgirl,

You have multiple instances of Word because you are quitting the application. Closing the document does not close Word itself, only the open document. Here is the corrected code...

Please Login or Register  to view this content.