Welcome to Office Zealot Sign in | Join | Help

December 2004 - Posts

Excel 2003: XML Toolbox for Microsoft Office Excel 2003 *Seeking Input*

We are putting specifications together for a XML toolkit for Excel 2003 developers. This is a project we actually started a while ago but it appeared that folks simply hadn’t had enough time working with XML in Excel to think out what their needs
Posted by charles | 0 Comments

A (long awaited!) Office Developer Conference from Microsoft

Nice to see MS putting the marketing muscle behind the Office System as a solutions development platform. This event, written up on CNet (“ Microsoft Office developers get own venue “) features Bill Gates himself as one of the keynote speakers.
Posted by charles | 0 Comments

GMail invites available (5)...

If you are interested in a Gmail account from Google, post a comment here along with a current e-mail address (Be sure to mask it so you don't get spammed, e.g. MyName MyProvider !dot! com). I have 5 to give.... first come first served. If five names
Posted by charles | 0 Comments

Where can you find 10 years of Office expertise rolled into one hour?

I attended Stephanie Krieger 's web cast this morning on Microsoft Office System Webcast: Tips and Tricks for Simplifying Complex Documents with Word, Excel, and PowerPoint . Stephanie did such an awesome job!!! I highly would recommend looking for posting
Posted by charles | 0 Comments

Amazon-based Research Task Pane write-up

Microsoft's Frank Rice has posted a nice article on MSDN ( Creating an Office 2003 Research Service Using the Amazon Web Service API ) that explains how my original Amazon Research Services sample functions. Thanks to Frank for writing this up - well
Posted by charles | 0 Comments

InfoPath or Word?!

.NET developers have their religious argument of VB.NET vs. C#, well us Office-types have a nice religious battle brewing too and that's InfoPath vs. Word. Well okay, not so much a battle but at least a nice little polarizing question; when should you
Posted by charles | 0 Comments

Microsoft Fingerprint Reader...

Fingerprint Reader Product Info on MS.com I have been waiting for this to go mainstream and it looks really cool... thinking I will probably get one. But I did come up with a few questions: What if I forget what finger I used? Can I use my middle finger
Posted by charles | 0 Comments

Whither VBA from Joel on Software

A new, interesting thread on Joel on Software 's forums discussing the future of VBA. Entitled Whither VBA , I liked one of the final posts by Albert Kallalw. Albert makes some great points but leaves it without providing that final definitive answer...
Posted by charles | 0 Comments

Excel VBA: Function to get logged in user name (plus the Environ Function)

One commonly asked task is how can you get the name of the current user of an Excel spreadsheet into a cell in the spreadsheet. A lot of people quickly stumble across the UserName property in VBA and create a function similar to this: Function UserNameOffice()
Posted by charles | 5 Comments

Word VBA: Function to get logged in user name

Figured I should follow my post on getting the user name in Excel with a flavor for Word. In the case of Word VBA, much is the same from the API standpoint but instead of a Function, I used a sub routine coupled with a Word varialbe and Field Code. Here
Posted by charles | 0 Comments

Making cents out of nothing...

Did you ever even notice that the ¢ has slipped into obscurity? Basically, the poor little symbol that went by the wayside along with the manual typewriter hasn't been seen too much lately. Maybe that's because you simply can't buy much of anything
Posted by charles | 0 Comments

IBF: Unit Testing Information Bridge Framework Smart Tags

An article by (our very own) Chris Kunicki and John Murray has just been published out on MSDN explaining how you can better unit test IBF smart tags . I was a beneficiary of their work when I was building IBF smart tags using the beta code from their
Posted by charles | 0 Comments