Results 1 to 2 of 2

Thread: Error - The requested member of the collection does not exist

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2011
    Posts
    3

    Error - The requested member of the collection does not exist

    hi,

    I executed the below VB Script to compare two word documents.

    Code:
    option explicit
    
    dim sPath1,sPath2,objArgs,word,destination
    
    Set objArgs = WScript.Arguments
    sPath1=objArgs(0)
    sPath2=objArgs(1)
    
        set word = createobject("Word.Application")
        word.visible=1
        
        ' Open the first document
        set destination = word.Documents.Open(sPath2)
        ' Hide it
        destination.Windows(1).Visible=0
        
        ' Compare to the second document
        destination.Compare(sPath1)
        
        ' Show the comparison result
        word.ActiveDocument.Windows(1).Visible = 1
        
        ' Mark the comparison document as saved to prevent the annoying
        ' "Save as" dialog from appearing.
        word.ActiveDocument.Saved = 1
        
        ' Close the first document
        destination.Close
    I'm getting the below Error on executing this script.

    'The requested member of the collection does not exist'

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

    Re: Error - The requested member of the collection does not exist

    You shouldnt declare all variables on a single line as it makes them all Variants which is a heavy weight object and usually overkill.

    Looks lik ethe only potential collections where it could error is in the .Open or .Compare methods as the file path may be incorrect.
    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