+ Reply to Thread
Results 1 to 2 of 2

Run-time error 438 "Object does not support this property or method"

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    11

    Run-time error 438 "Object does not support this property or method"

    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.

  2. #2
    Forum Contributor vikas.bhandari's Avatar
    Join Date
    04-07-2006
    Location
    Delhi, India
    MS-Off Ver
    Office 2007 and 2010
    Posts
    303

    Re: Run-time error 438 "Object does not support this property or method"

    It is coming because application is unable to find Test Macro.

    If your macro is in Normal.dot, please ensure that the macros are enabled.
    If your macro is in any other document, please ensure you open that document.

    Thanks,
    Vikas B

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1