Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.
Excel VBA functions to break all external references and delete defined names containing external workbook references.
Excel VBA utility function to test if a workbook is already open.
Excel VBA utility function to test if a file exists.
How to dynamically replace text values with Unicode characters or images in a SharePoint list view using jQuery.
How to perform mathematical addition on multiple currency formatted fields in MS Access.
How to calculate the first day of the following month using a formula in MS Access.
How to set complex Oracle job intervals using a custom function call.
How to programmatically maintain data change history in Oracle using PL/SQL triggers.