The ODB extension is a text file in XML format so you should be able to
read the file just like a XML file. Try renaming the file to an XML
file extension and see if that works if you can't just read the file
directlyby selecting *.* and opening the file. I haven't done it
before. You may have to strip off the header and trailer portion of the
file becuase the XML may not recognize some of the tags that are used in
the header. You can do a web search to find examples of reading XML
files using VBA. There have been numerous request for read XML in VBA.
If you can't find what you are looking for I can help.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160601

Microsoft Office Help