Microsoft Updates Office Developer Code Librarian With ISV Libraries

Microsoft Corp. today launched what is essentially a code-snippets-of-the-month club for corporate developers writing applications that build on Microsoft Office 2000 and Visual Basic for Applications (VBA).

The new service is called the Code Librarian Update, and will consist of free monthly updates to a Microsoft Web site of code libraries from third-party software companies with VBA-embedded products. The site can be found at

Lest anyone conclude this announcement out of the Office Deployment and Developer Conference in Phoenix is a step from Redmond toward open source, users will only be able to view the libraries via the Code Librarian, a searchable database of prewritten code in Microsoft Office 2000 Developer.

The Code Librarian consists of hundreds of reusable code snippets that can be dragged and dropped by developers writing applications using Office and VBA.

The first add-on library comes from Visio, formerly an ISV selling a business drawing application but now a division of Microsoft ( Microsoft predicts libraries from actual ISVs will come from WRQ ( ), Lawson Software ( and Elsinore Technologies ( Microsoft claims many ISVs are eager to be included.

Dave Edson, technical product manager for Developer Tools at Microsoft, sheds light on how Microsoft expects ISVs to view the opportunity. Edson, who is a technical evangelist for Visio, explains how the Code Librarian Update could affect Visio: "We see Visio as a great graphics front end to all forms of data. People don’t necessarily know how to transfer that data back and forth between applications." With the appropriate code snippets, developers can drag and drop the code for transferring data between Visio and Access, Excel or Word. About a quarter of Visio development scenarios are used with Microsoft Office, and about 57 percent of Visio developers use VBA automation, according to Microsoft.

The Visio library includes about 100 functions. The total size of the library is about 1.4 MB, although it zips to about a 100 KB download.

According to Microsoft, there are about 2.6 million developers targeting the Office environment. – Scott Bekker

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.


  • Gears

    Top 10 Microsoft Tips and Analyses of 2018

    Here are the year's most popular explainers and how-to columns -- along with some plain, old "Why did Microsoft do that?" musings thrown in.

  • Sign

    2018 Microsoft Predictions Revisited

    From guessing the fate of Windows 10 S to predicting Microsoft's next big move with Linux, Brien's predictions from a year ago were on the mark more than they weren't.

  • Microsoft Recaps Delivery Optimization Bandwidth Controls for Organizations

    Microsoft expects organizations using its Delivery Optimization peer-to-peer update scheme will optimally see 60 percent to 70 percent improvements in terms of network bandwidth use.

  • Getting a Handle on Hyper-V Virtual NICs

    Hyper-V usually makes it easy to configure virtual network adapters within VMs. That is, until you need to create a VM containing multiple virtual NICs.

comments powered by Disqus
Most   Popular

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.