How to dim, set NameSpace object in VBA

[batteam]

The web is full of examples on how to dim, declare and use the NameSpace object in VB when parsing a XML file. However, I need to dim and use NameSpace and and MakeTable property/method in VBA - behind a MSAccess 2007 Project Form in order to parse a rather large XML file with a namespace, and examples of those are few and far between. The first line of my XML file - with namespace - is: <TXLife Version="2.20.01" xmlns="

http://ACORD.org/Standards/Life/2"

xmlns:xsi="

http://www.w3.org/2001/XMLSchema-instance">

"<TXLife" is the root element.

Any assistance you could provide is appreciated.