I use MS Access to track my business activities. I am an independent contractor that gets assignments from several different online sources. When I get a new work order I input all the info into my DB by doing a lot of copy and paste. This is VERY time consuming and tedious.
I am attaching output from one of these websites that was downloaded using Firefox.
I have tried to have VBA in Access parse the output from this website, but I believe the XML is wrapped up in HTML, so the parser is having trouble with it.
Dim objXML As DOMDocument60
Set objXML = New DOMDocument60
I think my question is: How do I separate the HTML from the XML so Access can import it?