View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diamond, Mark Diamond, Mark is offline
external usenet poster
 
Posts: 4
Default XML and DOMDocument

I'm a reasonably experienced programmer, but not with VBA.
I have a copy of a workbook which downloads some information from a website.
In the VBA code, there are references to DOMDocument ... e.g.

Dim oDom as New DOMDocument

However, when I try the same thing myself in a new spreadsheet, I get an
error indicating that DOMDocument is undefined. I presume that the original
spreadsheet automatically loads a library of some sort but I can't find any
other reference to it (a library).

So, the questions, with which I'd very much appreciate some help, are ...

Is there a library being loaded?
What library would it be?
Where should I be looking in the original spreadsheet to find the statements
that cause the loading?
What should I be putting in my own new workbook so that I can use
DOMDocument (and where should it go).


Cheers,

Mark