Opening Existing Word file from Excel VBA

**rbyrd023** · 12-07-2010, 12:10 PM

Hello All!

I have read the many threads across the internet on this and copied and pasted so much code that my fingers hurt!

The only error that I am getting from any code that I try is

Run-time Error '5174'

This file could not be found
(c:\test.doc)

The file that it is looking for is there, and is not hidden or a read only.

Anyone have any ideas?

**mrice** · 12-07-2010, 04:26 PM

Try

Sub Test()
Dim WordApp As Word.Application

Set WordApp = Nothing
Set WordApp = New Word.Application
WordApp.Visible = True
WordApp.Documents.Open "C:\New Word 2007 Document.docx"

End Sub

having made a reference to the Word object model.

**rbyrd023** · 12-08-2010, 12:57 PM

That worked great.

THANK YOU

I have added the printout method to the file that I am opening, and after the printout method, I want Word to close. I've tried a few lines but all it does is close the document. ANy way to close Word entirely?

**mrice** · 12-08-2010, 01:30 PM

Try

WordApp.Quit
Set WordApp = Nothing

at the end.

**rbyrd023** · 12-10-2010, 01:01 PM

Ok that Worked!!!!

One last thing! (Sorry)

The doc that I have is set up so that a warning on the print margins comes up when I print it. It prints just fine, but I want it to no give that warning. Any code for that?