Search results for query: *

Thanks for your reply. POI is faster indeed. Now I have converted my script to use POI and it works very fast. Also it showed I had some errors in my code, which are now fixed... --------------------------------------------- Yes, the world is full of strange people.

Dear all, Is there a maximum number of columns I can retrieve from an excel sheet? I am using Selenium with Excel through an ODBC connection. When I get to columnnr 256, my program just stops. No warning or exception is given. I'm using jdk1.7.0_03 with Excel driver version 12. If there is a...

When trying to append the 438-Error is thrown, but my XMLNode is appended to my XMLNodeBasisBody. So I have put On Error Resume Next above it, so it does not bother me again, and again, and again, and again...... Did anyone else have this problem? ---------------------------------------------...

In my Dictionary I have several DOMDocuments. These are taken out of the dict with XMLDocAOHA. To append this document to a Node I have to convert the DomDocument to an IXMLNode. I'm using Xpath to do this. Then I am adding the new XMLNode to XMLNodeBasisBody, but then I get Error 438. What...

You could add 'DoEvents' (no quotes ofcourse) to your loop. It gives the other processes a little bit more processor time. --------------------------------------------- Yes, the world is full of strange people.

Thanks, that is something I will look into. The downside of this choice is I have to find a way to skip <?xml version="1.0" encoding="utf-8"?> and the root element. --------------------------------------------- Yes, the world is full of strange people.

Hello, In Excel 2003 I have made a script that copies the contents of xml files. But this is done one element at the time (rootNode.appendChild(xmlElement)). This takes a lot of time with large files (50mb+). Is it possible to copy the entire content of a xml file? The first thing I did to...

Hello tsui, My code has been stripped down. It is exactly like your example. The quote is not a problem, all the namespaces come from an excel worksheet. Many thanks for your help! --------------------------------------------- Yes, the world is full of strange people.

THATS IT!!!! Thanks Combo!!! --------------------------------------------- Yes, the world is full of strange people.

Because otherwise I cannot use my xpath. This contains the element that has to be copied several times. This is my current version: If StrComp(strNs, vbNullString) <> 0 Then On Error Resume Next Debug.Print "SelectionNamespaces: " & XMLDoc.getProperty("SelectionNamespaces")...

How do I do that? During runtime I used getProperty("SelectionNamespaces"), but it returns an empty string. This is before the namespaces are added to the document. --------------------------------------------- Yes, the world is full of strange people.

Yes, that was the error message. Duplicate attribute. The error number is -2147467259 (80004005). --------------------------------------------- Yes, the world is full of strange people.

The contents of strNS is copied out of the original. But it contains several urls. These are a few of them: xmlns:sch="http://www.ascc.net/xml/schematron" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gml="http://www.opengis.net/gml" xmlns:xlink="http://www.w3.org/1999/xlink". In...

What do you mean with an already processed file? When I create the new xml document, first I delete the old one. Does Excel keep a sort of lock on the file? After I set 'Break on all errors' the first run stopped when I try to delete the new xml document. After I solved this one, the first run...

Thanks tsjui for your answer. I think you are right. But what I do not understand is that at the end of the first run everything is set to Nothing. Should not that prevent things like <elem x="abc" x="123">...</elem>? Also at the begin of the run i create new msxml documents (Dim XMLDoc As New...

Above problem occurs when I use MSXML2.DOMDocument60. When I use MSXML2.DOMDocument also, but with "On error resume next" I can continue without problem. This is not the case with MSXML2.DOMDocument60, "XMLDoc.selectNodes(strXPath)" will come with an error. I hope someone has the answer to my...

What you can do is get an application like XMLSpy. Here you can open you xmlfile and go to a location you are looking for. Then select "xopy xpath" with a right-mouse-click. This you can use in your code. There are other programs like this, but i have not worked with them...

Hello all, In Excel 2003 I want to copy the contents of XML files. I open the original and copy the content to a new xml file. Also I can change the number of a certain element, the first one under the root element. My xml files contain namespaces. This is done with help of XPath. But to use...

What Operating System do you use? If it is winXP, it does not have to. In your configuration you can change the user settings. Try to do this first before installation. Check if the current user has admin rights. If not, change it. Sjakie --------------------------------------------- Yes, the...

Hello, After I have made my outlook add-in I built a shim for it with some help from the MSDN. Everything works, but I still get an exception: First-chance exception at 0x7c81eb33 in OUTLOOK.EXE: 0xE0434F4D: 0xe0434f4d. What does this mean? How can I solve it? My second question is how can I...