![](/images/CodeNetLogo2.jpg)
VBA Links
Office
- Better Solutions - Help and advice for all Microsoft Excel, Word and PowerPoint users.
- Compiling VBA Code - A detailed discussion on the Why's, Do's and Don'ts of your VBA code project
- FIX: Add-ins, smart documents, or smart tags that you create by using Microsoft Visual Studio 2005 do not run in Office - MS buf fix for created managed office addins
- ID Automation - How to make barcodes in Excel and Word
- MSKB: Determine IDE mode - Find out if the IDE is in design, run, or break mode from an Add-in
- Ozgrid - Many code and formula examples and free downloads
- VBA Programmer - Many useful VBA code examples.
- VBAexpress - Check out the knowledge base for many fully documented examples.
Excel
- AJP Excel Information - Excellent VBA code for charts in Excel
- Andrew's Excel Tips - An excellent blog with many tips, and a nice guy too.
- Automate Excel
- C Pearson - Learn how to turn Excel into a powerful application platform
- Colo's Excel Junk Room - A site dedicated to Excel, including interviews with many MVP's
- David McRitchie - Excellent VBA & Formulas / UDF's (must see)
- Decision Models - Excel only rather than VBA but useful info on: Optimising Speed, Calculation Secrets and Memory
- Erlandsen Data Consulting - On this site you will find tips about Excel and VBA programming
- Excel and the API - Stephen Bullens compact synopsys of this murky area of Excel dev
- Extras4Excel - Extras 4 Excel features how-to articles plus links to a wide selection of learning aids, add-ins, macros and templates for spreadsheet users.
- Ivan F Moala - Advanced VBA/API/WMI
- J-Walk - The website of John Walkenbach
- JLXL Excel Pages - The website of Justin Labenne
- Jon Peltier - Charts - Pivot Tables - VB Script - Using Excel with Other Office Applications
- MrExcel - The site provides beginner tutorials and examples
- MSKB: Create =RTD() Server - How to Create a RealTimeData Server for Excel
- The Excel MVP Page - The website of Stephen Bullen, co-author of Excel 2000/2002 Programmer's Reference (Wrox)
- Tommy Flynn - Excellent site for beginners, lots of examples
- XL-Dennis - A website focused on VBA Excel, ADO and MS Office Automation (Swedish)
- XL-Logic.com from Aaron Blood - Exploring advanced concepts in spreadsheet formulas and logic
Word
- How to control the page numbering in a Word document
- MSKB: Word Built-in Dialogs Argument lists
- Word MVPS - Word FAQs and tutorials
- Word's numbering explained
Access
Forums
- Developer Shed Network
- Experts Exchange
- Extreme VB Talk Forum - A great site for all programming problems, especially VB
- Mr Excel
- Ozgrid
- Techimo
- The Office Experts
- VBAExpress (VBAX) - VBA and MS Office Integration Forum. Superb talent, particularly within Excel
- vbForums
Tools & Downloads
- Add-in Express - A visual tool for developing COM add-ins, Smart Tags and RTD Servers on .NET and VCL
- Lost Password - Password recovery software
- Synkronizer - A tool to help compare, update and synchronize your Excel spreadsheets
If you would like to suggest a link please email suggestions@thecodenet.com.