Microsoft turns to XML

CT Witter

MrExcel MVP
Joined
Jul 7, 2002
Messages
1,212
from Money.CNN http://money.cnn.com/2005/06/02/technology/microsoft_xml.dj/index.htm

Microsoft Corp. (MSFT) said it is adopting XML technology for the default file formats in the next version of Microsoft Office editions to give users improved data interoperability and dramatically smaller file sizes.

So my question is how will this affect developers? I know that I haven't done too much XML in the past and am interested in how this will play out for importing/exporting processes.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
I have implemented Excel 2003's XML capabilities in my coding, and it's bloody awesome. I create URLs using WebSmart containing dynamic XML documents, and then query them using Excel. This allows me to get away from having to import text files and the like to produce Excel reports. For instance, I'll have a cell that allows the user to input a number, and that cell is a variable in the code that is part of the URL. I then use Excel formulas to lookup the XML values and, voila!, everything's real-time.

I think it's definitely a move in the right direction.
 

Forum statistics

Threads
1,225,062
Messages
6,182,628
Members
453,128
Latest member
Dinesh Shukla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top