Browse by Tags

• Article
• Community
• Data
• DevCenter
• Entity Framework
• Speaking
• Visual Basic
• VS2008
• VSTO
• XML

Merging Text & Photos into a Word Document using Open XML SDK
24 September 09 02:55 PM

Yesterday I posted about how we could create a letter generator (mail merge) that took data from a database to create a Word 2007 document using the System.IO.Packaging class. I showed how to take data from Northwind using a single LINQ query to create Read More...

Postedby Beth Massi | 0 Comments    

Filed under: LINQ, VS2008, DevCenter, Article, XML, Office, VSTO

Mail Merging Into a Single Word Document Using XML Literals
23 September 09 04:18 PM

With the release of Microsoft Office 2007 we can work with a much simpler, standard, XML format called Open XML which opens the door for many types of applications that cannot work via COM. What if you needed to build a scalable web service that processes Read More...

Postedby Beth Massi | 5 Comments    

Filed under: Visual Basic, LINQ, VS2008, DevCenter, Article, XML, Office

DevProConnections Article: Taking Advantage of LINQ and XML in Microsoft Office 2007
17 August 09 10:05 AM

This month I have an article on DevProConnections: Taking Advantage of LINQ and XML in Microsoft Office 2007 In this article, I talk about how a lot of applications that need to take advantage of Microsoft Office can do so without going through COM. Many Read More...

Postedby Beth Massi | 0 Comments    

Filed under: Visual Basic, LINQ, VS2008, DevCenter, Article, XML, Office

I'm Speaking at Silicon Valley Code Camp on Saturday Nov. 8th
05 November 08 12:33 PM

There are over 1100 people registered for the Silicon Valley code camp this year! Wow! That's a couple hundred more than last year. This is a free event people, so there's no excuse not to come out to Foothill college this year. And it's not all Microsoft Read More...

Postedby Beth Massi | 2 Comments    

Filed under: Visual Basic, Speaking, LINQ, VS2008, Community, DevCenter, Office

First Day at SDN Conference
07 October 08 03:28 AM

I'm here in the Netherlands in a town called Noordwijkerhout near Amsterdam at the SDN Conference with a lot of great speakers and sessions . I took these shots while the attendees were in session. There's good food, great vendors and lots of entertainment Read More...

Postedby Beth Massi | 4 Comments    

Filed under: Visual Basic, Speaking, LINQ, Community, DevCenter, XML, Office, Entity Framework

Attachment(s):SDCDay1.zip

Accessing Open XML Document Parts with the Open XML SDK
30 July 08 07:30 PM

About a month ago the Open XML SDK 1.0 (June 08 update) was released . The SDK provides strongly typed document part access to Word 2007, Excel 2007 and PowerPoint 2007 documents. The SDK has been a CTP for a while, but last month version 1.0 was finally Read More...

Postedby Beth Massi | 4 Comments    

Filed under: Visual Basic, LINQ, DevCenter, Article, XML, Office

New Video Tutorials from the Community
18 March 08 04:15 PM

Bill Burrows, Visual Basic MVP has just released a new set of video tutorials on using Excel for business intelligence using the Excel 2007 Data Mining Add-in . Bill has done a lot of tutorials in the past. If you haven't seen them, I also recommend the Read More...

Postedby Beth Massi | 3 Comments    

Filed under: Visual Basic, LINQ, VS2008, Community, DevCenter, Office

Mail Merging with Word, LINQ and XML Literals in VB
06 December 07 05:50 PM

I've mentioned before that you can use XML literals in VB 9 to do text merging so I figured it should be pretty easy to do some mail merging in Word the same way. Word 2007 (and Excel, etc) now uses a standard XML format called Office Open XML to describe Read More...

Postedby Beth Massi | 20 Comments    

Filed under: Visual Basic, LINQ, DevCenter, Article, XML, Office

Attachment(s):WordMailMerge.zip

Quickly Import and Export Excel Data with LINQ to XML
30 October 07 08:00 PM

One really handy thing to do with relational data is to import and export it to Excel. This can be a total snap using LINQ to XML in Visual Basic 2008. For example, let's say I want to import data from an Excel spreadsheet into a local database file like Read More...

Postedby Beth Massi | 69 Comments    

Filed under: LINQ, VS2008, DevCenter, Article, XML, Office, Data

Attachment(s):ImportExportExcel.zip