Jump to content
Sign in to follow this  
Joon

Help with using _XMLDomWrapper UDF

Recommended Posts

Joon

I am hack of time trying to work with XML file.

How can I read value from below XML file? One with URL. I need to update the value also.

I have tried with

MsgBox(0, 'Value', _XMLGetValue ('//configuration/userSettings/OutlookAddIn.MySettings/setting[@name="WebServerPath"]/value'))

but doesn't work...

Thank you.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <userSettings>
        <OutlookAddIn.MySettings>
            <setting name="WebServerPath" serializeAs="String">
                <value>http://www.myserver.com/db/</value>
            </setting>
            <setting name="AccountID" serializeAs="String">
                <value />
            </setting>
            <setting name="UserID" serializeAs="String">
                <value>NETWORKID</value>
            </setting>
            <setting name="Password" serializeAs="String">
                <value />
            </setting>
            <setting name="ProxyServerPath" serializeAs="String">
                <value />
            </setting>
        </OutlookAddIn.MySettings>
    </userSettings>
</configuration>
Edited by Joon

Share this post


Link to post
Share on other sites
Joon

Got it _XMLGetValue returns values as Array... Duh. :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×