Import Worksheets From One Workbook to Another Using VBA
Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.
Technology
Excel VBA Procedures to Break All External References in Workbook
Excel VBA functions to break all external references and delete defined names containing external workbook references.
Function to Check If Workbook is Already Open Using Excel VBA
Excel VBA utility function to test if a workbook is already open.
Function to Check If File Exists Using Excel VBA
Excel VBA utility function to test if a file exists.
Replace Text With Images in SharePoint View Using jQuery
How to dynamically replace text values with Unicode characters or images in a SharePoint list view using jQuery.
Currency Formatted Field Addition in MS Access Report
How to perform mathematical addition on multiple currency formatted fields in MS Access.
MS Access Formula To Determine First Day of Following Month
How to calculate the first day of the following month using a formula in MS Access.
Setting Complex Oracle Job Intervals
How to set complex Oracle job intervals using a custom function call.
Maintaining Data Change History in Oracle
How to programmatically maintain data change history in Oracle using PL/SQL triggers.