Thursday, June 14, 2007

New Open XML file formats in Office 2007

If you have installed Office 2007 then you should be aware of the new file formats - xml.
If you haven't installed yet, then thre is plenty to learn about what they are and why they are great!

Joanna Bischel writes a great article about why the new xml formats are great and goes through some features in very easy to understand language.

First of all, Word, Excel and PowerPoint 2007 files now act as containers since they are actually compressed zip containers (just try changing the extension to a .zip and you'll know what I mean). To an end user, the file still looks like a single item but to the developer, the file is a package of parts, segmented in a logical tree structure, tied together by relationships which you can navigate through. No longer do you have the black box of a binary file from previous file formats. So knowing this, what are some of the benefits?

Read the rest of the article on her MSDN blog site.

Labels: ,


Monday, June 11, 2007

Maximum Length of Macros

Alan Wyatt has some great Excel tips.

I found this one the other day.
There actually is a maximum length for a VBA macro. Fortunately there are some solutions if you get this situation occurring. Read Alan's write up about it.

Labels: ,