| Always Refer to the Cell Above | 2008-05-05 23:12 |
| Break All Links In An Excel Workbook | 2008-09-10 19:24 |
| Connecting To/Creating A New Application Instance Via Late Binding | 2006-01-15 00:00 |
| Controlling When Application Properties Are Toggled and Controlling Events | 2006-08-25 22:15 |
| Count Files (with a specific extension or not) in a folder | 2008-03-02 10:55 |
| Count Files (with a specific extension or not) in a folder and subfolders | 2009-10-14 20:58 |
| Creating a Debugging Mode | 2006-08-23 20:00 |
| Creating an Access Database (on the fly) Using VBA and SQL | 2006-09-04 20:22 |
| Creating Your Own Constants For Functions | 2006-11-08 19:41 |
| Deploying Add-ins in a Network Environment | 2006-07-11 21:08 |
| Disable the Excel Compatibility Checker | 2008-09-24 19:26 |
| Displaying Quick Numerical Info | 2006-11-01 09:28 |
| Error Messages: User-Defined Type Not Defined | 2007-03-01 21:43 |
| Error Messages: Can't Initialize PDFCreator | 2007-02-19 21:52 |
| Examples Of Using Late Binding To Connect To Other Applications | 2006-01-19 00:00 |
| Export A Range Of Excel Data To A Database | 2004-12-20 00:00 |
| Fill MultiColumn Listbox With Worksheet Range | 2006-06-19 12:22 |
| Five Very Useful Functions For Working With Text | 2006-01-10 00:00 |
| Force user to enable macros | 2007-11-10 18:33 |
| Forms Controls in Excel | 2008-01-20 20:46 |
| Formula To Average Letters | 2006-01-17 00:00 |
| Function to Check if File or Directory (Folder) exists | 2006-09-24 21:51 |
| Function To Get File Name From Specific Directory | 2006-07-24 07:18 |
| Function to return various Environment Names | 2005-01-04 21:38 |
| Have Excel read a range of data to you | 2008-05-04 19:24 |
| Maintaining Version and Build Information | 2006-08-14 21:39 |
| Populate Multi-Column Listbox With Data From Access | 2006-02-16 00:00 |
| Print To PDF Using Microsoft's PDF/XPS Add-in | 2008-01-03 22:50 |
| Print To Picture Using PDFCreator | 2006-06-23 21:29 |
| Printing Worksheets To A PDF File (Using Early Binding) | 2006-04-10 23:00 |
| Printing Worksheets To A PDF File (Using Late Binding) | 2006-04-10 23:00 |
| Quickly Eliminate Duplicate Records From A Specific Column | 2005-10-07 23:00 |
| Replace External Links With Values | 2006-06-02 22:00 |
| Resetting PDFCreator Options via Code | 2006-06-23 21:12 |
| Restore Default Comment Colour | 2006-06-02 22:11 |
| Retrieve Data From A Database To Excel Using SQL | 2006-04-11 23:00 |
| Send Email Via Groupwise | 2007-06-08 21:31 |
| Some Notes On Developing With PDFCreator | 2006-06-14 13:10 |
| Spreadsheet Design Tips | 2006-06-02 22:58 |
| Text to Speech Utility - Proof Reader for Excel 2007 | 2008-05-06 21:12 |
