doing something wrong
recorder with macro recorder worked fine in letterhead now can't find?

Dim Word As New Word.Application
Dim WordDoc As New Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("C:\parade\letterhead.doc")
With WordDoc
Application.Run MacroName:="Macro3"
ActiveWindow.Close
End With

Curt,

I'm not familiar with Word objects, but seems like you missed a "." to
qualify the application object as the word application..

Perhaps these lines:

Application.Run MacroName:="Macro3"
ActiveWindow.Close

should be like these:

..Application.Run MacroName:="Macro3"
..ActiveWindow.Close


--
Hope that helps.

Vergel Adriano


"Curt" wrote:

doing something wrong
recorder with macro recorder worked fine in letterhead now can't find?

Dim Word As New Word.Application
Dim WordDoc As New Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("C:\parade\letterhead.doc")
With WordDoc
Application.Run MacroName:="Macro3"
ActiveWindow.Close
End With

made it go thru as needed now other parts are needing adjustment
thanks
Takes a long time to open excel then run macro also said letterhead was locked
Thanks Again

"Vergel Adriano" wrote:

Curt,

I'm not familiar with Word objects, but seems like you missed a "." to
qualify the application object as the word application..

Perhaps these lines:

Application.Run MacroName:="Macro3"
ActiveWindow.Close

should be like these:

.Application.Run MacroName:="Macro3"
.ActiveWindow.Close


--
Hope that helps.

Vergel Adriano


"Curt" wrote:

doing something wrong
recorder with macro recorder worked fine in letterhead now can't find?

Dim Word As New Word.Application
Dim WordDoc As New Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("C:\parade\letterhead.doc")
With WordDoc
Application.Run MacroName:="Macro3"
ActiveWindow.Close
End With