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

RE: xml instead of ini by Shasur

Shasur
Thu Jul 24 05:24:03 PDT 2008

Hi

You can try DOM

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

Cheers
--
http://vbadud.blogspot.com


"Ulf Nilsson" wrote:

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

Re: xml instead of ini by Jonathan

Jonathan
Thu Jul 24 05:27:03 PDT 2008


"Ulf Nilsson" <UlfNilsson@discussions.microsoft.com> wrote in message
news:BA1ED807-4000-4B88-95F5-4BD1EE2EEE92@microsoft.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
>
>

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.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup



RE: xml instead of ini by UlfNilsson

UlfNilsson
Thu Jul 24 05:45:01 PDT 2008

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

// Ulf

"Ulf Nilsson" wrote:

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

Re: xml instead of ini by Karl

Karl
Thu Jul 24 09:47:43 PDT 2008

Ulf Nilsson wrote:
> 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), ...
--
.NET: It's About Trust!
http://vfred.mvps.org