xml instead of ini

[Ulf Nilsson]

Hi,
I still use ini-files to get/store information - for different reasons - and
thinking of replacing them with xml-files. Is this possible? if so, how do I
navigate in a xml-file using vba?

// Ulf

 

[Shasur]

Hi

You can try DOM

http://www.automateexcel.com/index.php/2005/06/12/what_is_a_domdocument

Cheers

 

[Jonathan West]

Hi,
I still use ini-files to get/store information - for different reasons -
and
thinking of replacing them with xml-files. Is this possible? if so, how do
I
navigate in a xml-file using vba?

// Ulf

In your VBA project, go to Tools, References, and set a reference to a
version of "Microsoft XML". there are several versions of the XML library
available, you will have to make a decision on which one to use. I've tended
to use the oldest available on my system (2.6) on the assumption that it is
most likely to be installed in the widest number of systems.

This makes available an object model for accessing XML files. An article
describing the object model and how to use it is available here

http://msdn.microsoft.com/en-us/library/aa468547.aspx

Depending on which version of the XML object library you use, you might need
to find a different version of that article.

 

[Ulf Nilsson]

Thank you both of you. Now I know where to start.

// Ulf

 

[Karl E. Peterson]

I still use ini-files to get/store information - for different reasons - and
thinking of replacing them with xml-files. Is this possible? if so, how do I
navigate in a xml-file using vba?

I hate to ask, but are you rearchitecting due to an actual need, or is this just a
fashion statement? Nothing beats an INI file for the ease of remote troubleshooting
and user support. If XML doesn't provide you with *significant* advantage (clearly,
application specific), ...