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 - 24 Jul 2008 13:24 GMT
Hi
You can try DOM
http://www.automateexcel.com/index.php/2005/06/12/what_is_a_domdocument
Cheers

Signature
http://vbadud.blogspot.com
> 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
Jonathan West - 24 Jul 2008 13:27 GMT
> Hi,
> I still use ini-files to get/store information - for different reasons -
[quoted text clipped - 4 lines]
>
> // 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.

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Ulf Nilsson - 24 Jul 2008 13:45 GMT
Thank you both of you. Now I know where to start.
// Ulf
> 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
Karl E. Peterson - 24 Jul 2008 17:47 GMT
> 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), ...

Signature
.NET: It's About Trust!
http://vfred.mvps.org