Starting Word from Access

P

Phil

I need to start Word 2000 from Access 2000 and open a file called New Month.Doc.

Any help?

Thanks
 
D

Doug Robbins - Word MVP

Hi Phil,

Dim WordApp As Object
Dim WordDoc As Object

On Error GoTo CreateWordApp
Set WordApp = GetObject(, "Word.Application")
On Error GoTo 0
'Open Document
Set WordDoc = WordApp.Documents.Open("Drive:\Path\New Month.Doc")
WordApp.Visible=True


CreateWordApp:

Set WordApp = CreateObject("Word.Application")
Resume Next

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 

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

Top