Is it possible to open a Word97 Doc from Excel97??

[GaryB]

I am trying to write a macro that will extract a bunch of information from a spreadsheet and use it to produce letters in Word97 using mailmerge. The data extraction bit works fine and generates a data file for me, and I can switch to Word using "Application.ActivateMicrosoftApp xlMicrosoftWord", but how do I get my Word doc to open automatically?

 

[Anne Troy]

Gary, I believe this is already automated for you using Mail Merge. See the steps at my site by clicking on the Word Stuff link. Let me know if you have any problems with that. Basically, you don't need to create a separate file to do a mail merge, which has its own query options.

 

[Guest]

I had the same problem as you. This code should work.

Sub MtoOpenWord()

Dim wdApp As Object
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = True
wdApp.documents.Open "C:FILENAME.doc"
End Sub

Where FILENAME type the name of your file.

 

[GaryB]

That seems to do the trick!
Many thanks
Gary