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

XML and DOMDocument
 

On Dec 27, 8:11 am, "Diamond, Mark" wrote:
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

Hi Mark.

You must set a reference to Microsoft XML, v6.0.

To set references in VBA goto tool, references, and then select the
reference from the available references.

-Rob

XML and DOMDocument
 

Many thanks, Rob. I've checked the original worksheet VBA and it does,
indeed, have the appropriate reference ... and mine, of course, did not.

Thanks again.

Mark


"Rob" wrote in message
...
On Dec 27, 8:11 am, "Diamond, Mark" wrote:
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

Hi Mark.

You must set a reference to Microsoft XML, v6.0.

To set references in VBA goto tool, references, and then select the
reference from the available references.

-Rob