Recent content by sjakiePP

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...