+ Reply to Thread
Results 1 to 2 of 2

GetObject Worked Fine with Microsoft Office 2011 but having problems in Office 2019

  1. #1
    Registered User
    Join Date
    11-16-2020
    Location
    Toronto
    MS-Off Ver
    14.7.1 2010
    Posts
    10

    GetObject Worked Fine with Microsoft Office 2011 but having problems in Office 2019

    Hi All,


    I often use,

    Dim appWD As Word.Application
    ' Create a new instance of Word and make it visible
    Set appWD = GetObject(, "Word.Application")
    appWD.Visible = True

    In Office 2011 and recently moved to Office 2019 and noticed it doesn't work.

    I've tried,

    Set appWD = GetObject(, "Word.Application.16")

    Set appWD = GetObject("Word.Application")

    Set appWD = CreateObject("Word.Application")

    And still get run-time 7 error and Run-time error '-2147221020 (800401e4)'

    When I use CreateObject it does open up Word but then says an error and highlights the CreateObject line as an error when I click Debug.

    Would really appreciate any help or advice, thank you so much.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: GetObject Worked Fine with Microsoft Office 2011 but having problems in Office 2019

    I am not techie enough to try and tell you how to fix the problem, but here is a link to a page where you can contact MS for help on the issue. toward the bottom of the page you will see some options with chevrons to the right. Pick the option you want to use and click the corresponding chevron for more instructions.

    https://support.microsoft.com/en-us/...d-264c6907ea75

    Regards, JLG
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-26-2020, 06:53 PM
  2. Office Professional Plus 2019 or Office 2010
    By Philb1 in forum Excel General
    Replies: 2
    Last Post: 11-09-2019, 04:16 AM
  3. [SOLVED] Office 365 GetObject function
    By ByteMarks in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2019, 10:28 AM
  4. Please help. Did anyone encounter blurry Office 2019?
    By momchil.vladov in forum Excel General
    Replies: 4
    Last Post: 08-21-2019, 12:31 AM
  5. [SOLVED] Hyperlink OK in Office for Mac 2011 but problems in Office 2013
    By irose_57 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-15-2017, 11:02 PM
  6. Replies: 0
    Last Post: 02-09-2017, 10:06 AM
  7. Replies: 1
    Last Post: 08-07-2016, 05:52 PM

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