Skip to main content

Programming Excel with VBA & .NET

Go Search
Home
Read Now
  

Excel Visual Basic Workshop

Welcome!

This site supports Programming Excel with VBA and .NET by Jeff Webb and Steve Saunders. Click the Samples link to the right to get all of the code samples for the book. The Samples folder contains all of the books samples in VBA and .NET versions. The VBA versions of the samples are featured in print (because we wanted to keep the book length down to 1100 pages or so!), but parallel samples are provided in .NET as well.

There's a significant benefit to parallel VBA/NET samples: by comparing the two versions, you can learn a lot about making the transition from VBA to Visual Basic .NET. I think that is where most readers are coming from. If you are primarily a .NET programmer, please start with Chapter 25 and then work back to the earlier chapters for specific Excel tasks (and corresponding code samples).

Check out the other links to the right for samples from my earlier work, Excel 2003 Programming: A Developer's Notebook, as well as a bonus chapter on InfoPath and a feature that lets you explore the Excel object model online.

Don't forget to sign the guest book to get announcements and updates for the book.

Good luck, and thanks for reading!

-- Jeff Webb

 
 

 Excel Explorer

AllObjects.htmlAlphabetical list
control.htmlChapter 07
files.htmlChapter 08
range.htmlChapter 09
links.htmlChapter 10
publish.htmlChapter 11
data.htmlChapter 12, 13
xml.htmlChapter 14, 15
chart.htmlChapter 16
chartappearance.htmlChapter 17
drawing.htmlChapter 18
OfficeObjects.htmlChapter 19, 20
dialogs.htmlChapter 20
fm20.htmlChapter 20
mail.htmlChapter 21
addin.htmlChapter 22
hidden.htmlx Appendix B