Knowledge Base Articles By Category
Recent Knowledge Base Articles
Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I ended up heading off to a site to copy an example (usually from my colleague Ron de Bruin's excellent site), then customizing to make it work.
The goal of this article is to provide an even easier way to add email functionality to your Excel (or any other Office) project... something easy enough for beginner coders to use as effectively as master coders. I wanted a re-usuable chunk that I could just drop into my project with ease, and I believe I've accomplished that here.
... read more
- Anne Troy's Office Articles
- Anne has over 230 articles and tutorials available for the MS Office suite! Well worth the read!
- Andy Pope's "AJP Excel Information"
- Andy's site is very heavy on Charts, with lots of great pictures and examples. He's also got a collection of Excel based games as well.
- Bob Phillips xlDynamic
- Bob's site contains very comprehensive papers on Excel formulas and VBA. My personal favourite is his explanation of Multiple Condition tests using Sumproduct.
- Chip Pearson's Excel Information
- Chip has an incredible amount of information on his site, including using the Windows API to get at things not accessible through VBA alone.
- Colo's Junk Room
- Colo has all kinds of neat things at his site, including a Class Module tutorial, and tips for teaching VBA programmers how to program in javascript.
- Ivan F Moala's Xcel Files
- If it can't be done in Excel, Ivan will have an example of how it can... A site full of truly amazing information and undoubtedly bookmarked by every Excel developer.
- Jan Karel Pieterse's JKP-Ads
- Jan Karel Pieterse is the author of the Name Manager and a MS Excel MVP.
- John Walkenbach's Excel Information
- Author of the Excel VBA Power Programming series... a MUST have book for any aspiring VBA programmer!
- Jon Peltier's Site
- Jon's site is the first place I look if I need to know how to do somthing with Charts in Excel.
- Mark Rowlinson's Code Net
- Mark has some great articles including coverage of Visual Basic, Office and Web programming. My particular favourite is his tutorial on Passing arrays to and from functions
- MVPs Excel sites
- The above is the direct link to the MVPs.org Excel site listing. It lists all of the Excel MS MVPs and alumni sites
- Ron de Bruin's Excel Pages
- If you need to know something about sending email from Excel, this is the place to go. If you're looking for Outlook, Outlook Express or CDO, Ron has examples.
- Russell Proctor's Better Solutions
- Russell has an ever growing site with a host of information for Word, Excel and powerpoint.
- Stephen Bullen's Office Automation
- Stephen Bullen is one of the true Guru's of Excel, and co-author of Professional Excel Development, among other things. His site has some great utilities available for download.
Donations
Rate this article