Hi I am very new to VB so if this is simple I am sorry now.
I am trying to write some code that will open Word then run a macro. It does not need to open a specific document as the macro itself does all the work. I currently have the following code.
Sub BENDAILYMACRO()
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
Application.ActivateMicrosoftApp xlMicrosoftWord
WordApp.Run "TEST"
End Sub
It is opening word without any issue but then failing with the above error before running the macro. I am using Excel and Word 2007.
Bookmarks