Subject: xml

Yeah!!! It works!

Last weekend I tried VBA in Excel and it was a total fail.
Then I tried in portable Libre Office Calc (4.4.0.3) the python script sent by Kryminator, but my knowledge was not enough to get it run.
Finally I used the vba excel code from manus and it works!


I had to made a small modification to get it run. I removed this part:

ActiveWorkbook.Connections("Conexión").Delete
For Each sName In ThisWorkbook.Names
sName.Delete
Next

I have no idea what it is about, but finally I have a solution to save a lot of time! (On the german ntdb I could not see form and value...)

Thank you all and my special thanks to Kryminator, the developer of the SkUnk-extension, which is a big gift for the whole sokker community
and also my special thanks to Manus who also spent his time to help me, despite the fact that Kryminator had already offered me a solution.

My respect and my gratitude

I had to made a small modification to get it run. I removed this part:

ActiveWorkbook.Connections("Conexión").Delete
For Each sName In ThisWorkbook.Names
sName.Delete
Next

every time you download from the web, you create a new connection, better delete this because it takes memory.
Also, a range with an assigned name is created, I prefer to delete it.