Home
What's New?
July 2005
Excel's Rounding functions
June 2005
Squashed Lists
INSERT records into a closed workbook using SQL
SQL in Excel
Worksheet Tabs - Color
Worksheet Tabs - Font Size
Worksheet Tabs
Data Validation
Lotus Books
Lotus Conversion
Lotus to Powerpoint
Lotus 123 to Excel
123 and WordPro
May 2005
Menu in the Active Workbook
Menu and sub-menu
Menu Bar Maker
PopUp Menu Demo
Log File
Validated List
Page Settings
Built in Document Properties
Lotto
Cricket
June 2004
Windows Scripting Host
VBS Script
Procedure Wrapper
Email from Lotus Notes
INI Files
Saving
Environment
Calculation
Sorting
Naming conventions
17 November 2004
VLookUpX - look up with up to three parameters
18 January 2004
Goan Prawn Curry
15 September 2003
Byg Software: Examples
Check for duplicate entries using Conditional Formatting
15 September 2003
Byg Software: Examples
Get column numbers from an letter value, or column letters from a numeric value
15 September 2003
UDF Untrapped Error in Excel 97
15 September 2003
ADO demonstration of using SQL -
SQL in Excel
11 September 2003
Updated UsingSqlRequest.Xls - includes a new demo on extracting data from the active workbook -
Byg Software: Examples
07-September-2003
Save and BackUp your Excel work with one click
14 May 2003
Byg Software: Example - Cash Analysis for a Payroll
Last updated: 01 March 2011 20:49