Results 1 to 4 of 4

Thread: VBA cannot create MS Word Object- ActiveX Error

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2005
    Posts
    2

    VBA cannot create MS Word Object- ActiveX Error

    I am trying to create a word object using VBA.

    Word Object is created when the word is installed as a Office
    Component.
    Word Object is not created when the word is installed as a stand alone
    product. It gives a ActiveX Error.

    Can any one tell where I have gone wrong or Is some .dlls are
    missing in a stand alone product.

    Thanks in advance

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: VBA cannot create MS Word Object- ActiveX Error

    Welcome to the Forums.

    Are these on different systems? What version of Word? What version of
    Office Word? Could you post some code to show how you are creating the
    objects and comment which fails where?

    Sorry for all the Q's but its hard to answer with limited data.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3

    Thread Starter
    New Member
    Join Date
    Feb 2005
    Posts
    2

    Re: VBA cannot create MS Word Object- ActiveX Error

    Hi,

    The VBA and Word are on the same machine.
    Word 2000 stand alone product and
    Office 2000 was used for the test purpose.
    I am deprived of showing the code.
    It is the simple Word object creation in VB-
    Word.getObject(...) Something like this.

    Most of the solution, I heard was a few .dll are missing. I don't know the name of the .dll.

    Thank you

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: VBA cannot create MS Word Object- ActiveX Error

    Since we can not see the code, or a logical generic code simulation, I can only say that you may be
    using references in Office Word that are not included in Standalone Word. The dlls are not redistributable, though .
    So you need to develop on stand alone Word and see if it works the same on Office Word.

    HTH
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width