Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSXML2.DOMDocument | Excel Programming |