Articles
Please click the category name to see a summary of each article, or click the article name to see the article in full.Excel
- Excel - ADO (4)
- Excel - Formulas (9)
- Count Files (with a specific extension or not) in a folder and subfolders
- Count Files (with a specific extension or not) in a folder
- Function to return various Environment Names
- Always Refer to the Cell Above
- Understanding Dates in Excel
- User Defined Function To Sum And Round To Two Decimal Places
- User Defined Function To Show Formulas In A Cell
- Formula To Average Letters
- Five Very Useful Functions For Working With Text
- Excel - General Tips (13)
- XLG Favourites Add-in
- UseTemplate Add-in
- Text to Speech Utility - Proof Reader for Excel 2007
- Always Refer to the Cell Above
- Have Excel read a range of data to you
- Using Styles in Excel - Why and How
- Understanding Dates in Excel
- Forms Controls in Excel
- Deploying Add-ins in a Network Environment
- Creating a Debugging Mode
- Displaying Quick Numerical Info
- Where To Place VBA Code
- Spreadsheet Design Tips
- Excel - SQL (3)
- Excel - UDF (6)
- Excel - VBA (38)
- Count Files (with a specific extension or not) in a folder and subfolders
- Count Files (with a specific extension or not) in a folder
- Send Email Via Groupwise
- Using Help in Your Applications
- Disable the Excel Compatibility Checker
- Break All Links In An Excel Workbook
- Maintaining Version and Build Information
- Export A Range Of Excel Data To A Database
- Fill MultiColumn Listbox With Worksheet Range
- Function to return various Environment Names
- Have Excel read a range of data to you
- Function to Check if File or Directory (Folder) exists
- Quickly Eliminate Duplicate Records From A Specific Column
- Print To PDF Using Microsoft's PDF/XPS Add-in
- Force user to enable macros
- Error Messages: User-Defined Type Not Defined
- Some Notes On Developing With PDFCreator
- Error Messages: Can't Initialize PDFCreator
- Print To Picture Using PDFCreator
- Using PDFCreator with security options set
- Printing Worksheets To A PDF File (Using Late Binding)
- Printing Worksheets To A PDF File (Using Early Binding)
- Resetting PDFCreator Options via Code
- Using a Treeview Control
- Creating a Debugging Mode
- Creating Your Own Constants For Functions
- Function To Get File Name From Specific Directory
- Populate Multi-Column Listbox With Data From Access
- Restore Default Comment Colour
- Replace External Links With Values
- Connecting To/Creating A New Application Instance Via Late Binding
- Examples Of Using Late Binding To Connect To Other Applications
- User Defined Function To Sum And Round To Two Decimal Places
- User Defined Function To Show Formulas In A Cell
- Retrieve Data From A Database To Excel Using SQL
- Controlling When Application Properties Are Toggled and Controlling Events
- Where To Place VBA Code
- Formula To Average Letters
Access
- Access - ADO (4)
- Access - General Tips
- Access - SQL (3)
- Access - VBA (11)
- Send Email Via Groupwise
- Using Help in Your Applications
- Creating an Access Database (on the fly) Using VBA and SQL
- Export A Range Of Excel Data To A Database
- Printing Access Reports To A PDF File
- Creating Your Own Constants For Functions
- Populate Multi-Column Listbox With Data From Access
- Connecting To/Creating A New Application Instance Via Late Binding
- Examples Of Using Late Binding To Connect To Other Applications
- Retrieve Data From A Database To Excel Using SQL
- Controlling When Application Properties Are Toggled and Controlling Events
General
- Add-ins (3)
- General Tips (4)
- General VBA & Programming (19)
- Count Files (with a specific extension or not) in a folder and subfolders
- Count Files (with a specific extension or not) in a folder
- Send Email Via Groupwise
- Using Help in Your Applications
- Break All Links In An Excel Workbook
- Creating an Access Database (on the fly) Using VBA and SQL
- Print To PDF Using Microsoft's PDF/XPS Add-in
- A Discussion On Early vs Late Binding
- Error Messages: User-Defined Type Not Defined
- Some Notes On Developing With PDFCreator
- Error Messages: Can't Initialize PDFCreator
- Print To Picture Using PDFCreator
- Using PDFCreator with security options set
- Resetting PDFCreator Options via Code
- Using a Treeview Control
- Creating a Debugging Mode
- Creating Your Own Constants For Functions
- Controlling When Application Properties Are Toggled and Controlling Events
- Where To Place VBA Code
Internet Explorer
Other Programs
- Novell Groupwise (2)
- PDF (11)
- Printing Multiple Word Documents to a Single PDF
- Print To PDF Using Microsoft's PDF/XPS Add-in
- Error Messages: User-Defined Type Not Defined
- Some Notes On Developing With PDFCreator
- Error Messages: Can't Initialize PDFCreator
- Printing Access Reports To A PDF File
- Print To Picture Using PDFCreator
- Using PDFCreator with security options set
- Printing Worksheets To A PDF File (Using Late Binding)
- Printing Worksheets To A PDF File (Using Early Binding)
- Resetting PDFCreator Options via Code
Outlook
- Outlook - General Tips (2)
- Outlook - VBA (6)
- Using Help in Your Applications
- Creating Your Own Constants For Functions
- Send Email Using ClickYes
- Connecting To/Creating A New Application Instance Via Late Binding
- Examples Of Using Late Binding To Connect To Other Applications
- Controlling When Application Properties Are Toggled and Controlling Events
Powerpoint
- Ppt - General Tips
- Ppt - VBA (6)
- Send Email Via Groupwise
- Using Help in Your Applications
- Creating Your Own Constants For Functions
- Connecting To/Creating A New Application Instance Via Late Binding
- Examples Of Using Late Binding To Connect To Other Applications
- Controlling When Application Properties Are Toggled and Controlling Events
Publisher
- Pub - VBA (6)
- Send Email Via Groupwise
- Using Help in Your Applications
- Creating Your Own Constants For Functions
- Connecting To/Creating A New Application Instance Via Late Binding
- Examples Of Using Late Binding To Connect To Other Applications
- Controlling When Application Properties Are Toggled and Controlling Events
Word
- Word - VBA (7)
- Send Email Via Groupwise
- Using Help in Your Applications
- Printing Multiple Word Documents to a Single PDF
- Creating Your Own Constants For Functions
- Connecting To/Creating A New Application Instance Via Late Binding
- Examples Of Using Late Binding To Connect To Other Applications
- Controlling When Application Properties Are Toggled and Controlling Events