Useful Links
Submitted by Ken Puls on Sun, 2006-06-04 10:04.
These are all links to information sites that I've found very useful.
Forums & Usergroups
- VBAeXpress.com:
- VBA specific help for all office applications
- JMT Excel Q&A Board:
- 100% Excel and Excel specific VBA
- OfficeArticles Forum:
- A sub forum dedicated to every office application!
- Excel User Group:
- A site dedicated strictly to all things Excel.
- MrExcel.com:
- Mainly Excel and Excel specific VBA, some Access as well.
- Tech Support Guy:
- The business applications forum support virtually all business applications.
- Tek-Tips:
- There is a help forum here for virtually everything
- UtterAccess.com:
- Mainly Access focussed, but some other applications as well.
Excel Blogs
- The Ken Puls Blog
- Okay, it's a shameless plug, but this is my own blog, which serves as my testing ground for Excel related material, among other things.
- Andrew's Excel Tips
- Andrew Engwirda's Excel Blog
- Daily Dose of Excel
- Dick Kusleika's Excel Blog
- .Net & Excel Blog
- This is Dennis Wallentin's new blog with a very specific focus on .Net and Excel
- Methods In Excel
- Ross McLean's Excel Blog
- Smurf on Spreadsheets
- Simon Murphy's Excel developer's blog
Reference Sites I Use
- 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.
- Dennis Wallentin's ExcelKB
- Dennis's site covers pretty much every flavour of VB that you can think of, Excel, Lotus Notes and databases. He has a great variety of KB articles and is well worth the visit.
- 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.
Recommended Addins and Tools(all free!)
- ASAP Utilities
- ASAP utilities is a standard install procedure for many advanced Excel users. Another addin full of great stuff!
- Dave Brett's Duplicate Master
- Dave's addin contains tools to quickly highlight, or delete duplicate data from lists, and can also extract unique items as well.
- HTML Maker
- Colo and Ivan's HTML maker has been used throughout this site to post interactive examples of Excel sheets. It was orignally designed for posting on messageboards.
- MZ Tools
- If you do any VBA developing, you need this addin. It is loaded with useful tools such as a code reviewer and much more to speed up your development process.
- Name Manager
- Jan Karel's name Manager is an essential add-in for working with names.
- PDF Creator
- A free PDF writer utility that supports VBA.
- Smart Indenter
- An awesome little add-in that makes indenting all of your code very simple. I find it really helps to know if you have an issue in a Case or If block, among other things.
- JMT Utilities (formerly Andrew's Utilities)
- JMT utilities is just full of items to extend the functionality of Excel.


