Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an excel macro (in an add-in) that is called by the main excel macro
that is deleting various items in an xml file When it gets to the last line as below it generates the following message €śAn unhandled error occurred: Object variable or with block not set€ť the variable is dimensioned see Dim statement that I have copied here. This has worked for some time with no problem but suddenly out of the blue generates this error. I have tried replacing the xml file with a copy, also tried replacing the add-in with a copy (in case either have been corrupted). The error description is per €śErr.Description€ť Dim oInstNode As IXMLDOMNode Set oReplacedNode = oxml.selectSingleNode("/InstrumentList") Set oCheckNode = oReplacedNode.selectSingleNode("Instrument[OMR='" & OMRCode & "']") Any ideas will be gratefully received -- with kind regards Spike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 problem deleting an onsheet scrollbar | Excel Programming | |||
Deleting custom menu item createt in VBA | Excel Programming | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
deleting line item in import function causes REF# error | Excel Worksheet Functions | |||
Excel VBA - deleting populated folder problem | Excel Programming |