PDA

View Full Version : XML in VBA



ericc
03-26-2008, 08:52 AM
Hello all

In one of my macro, I have created an "XML generator" to store values in an XML file.
I have found by searching in the forum, an external XML Parser (http://www.xml-parser.com/) which can help me a lot to manipulate this XML file, but I have several question.
(for info: I use Excel 2000)

First of all, certainly stupid but I must ask to be sure:
If I write macro using this ActiveX component, then it must be installed on the computer of all the users ?

Second:
I see that I must declare the component in "Tools" -> "References" to be able to use it.
Is it a way to using it without this first activation ?
Or
Is it a way to activate it through a macro ?

ericc

Bob Phillips
03-26-2008, 09:13 AM
1 - Yes probably.

2 - you could probably just register it using RegSrv and that should do it.

Probably best to use an installer, http://www.jrsoftware.org/isinfo.php

ericc
03-28-2008, 01:52 AM
Ok, Thanks for your answers

This will be difficult to manage because I don't see how I can force users to install an extra component just to use my little application.
I will continue to do without

ericc