Issue with looping through Word with Excel

Hello Everyone,

Please help me with my issue with looping through a Word doc with Excel VBA.

I use a sub called GetFile() which opens a word doc the user chooses.
Once the word doc is open I run a sub called ParseBill() which should loop through the word doc.

It fails, however, with a type mismatch. See the code below for where I point this out.

Also, I have Option Explicit on.
My Office VBA References are Visual Basic For Applications, Microsoft Excel 16.0 Object Library, OLE Automation, and Microsoft Word 16.0 Object Library

Thank you for your help!

-------------------------------------------------------

Please Login or Register  to view this content.

-------------------------------------------------------

Please Login or Register  to view this content.

Don't play around with Word VBA much, but 'StoryRanges' seems like an odd choice if you want sentences. Why not just
objWord.ActiveDocument.Sentences
Plus, I assume you don't necessarily want the active document. You probably want to use the one you opened - so
objDoc.Sentences

I am unsure of the type mismatch error since https://docs.microsoft.com/en-us/off...rd.storyranges says it is a collection of ranges (just like Sentences), but it not returning the sentences I think you are expecting.