Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / July 2008

Tip: Looking for answers? Try searching our database.

xml instead of ini

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ulf Nilsson - 24 Jul 2008 13:10 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.