Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

Technology

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.

Categories Technology Tags Excel, VBA Leave a comment

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.

Categories Productivity Tags Excel, VBA Leave a comment

Function to Check If Workbook is Already Open Using Excel VBA

Excel VBA utility function to test if a workbook is already open.

Categories Productivity Tags Excel, VBA Leave a comment

Function to Check If File Exists Using Excel VBA

Excel VBA utility function to test if a file exists.

Categories Productivity Tags Excel, VBA Leave a comment

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.

Categories Programming Tags JavaScript, jQuery, SharePoint Leave a comment

Currency Formatted Field Addition in MS Access Report

How to perform mathematical addition on multiple currency formatted fields in MS Access.

Categories Productivity Tags MS Access Leave a comment

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.

Categories Productivity Tags MS Access Leave a comment

Setting Complex Oracle Job Intervals

How to set complex Oracle job intervals using a custom function call.

Categories Automation Tags Automation, Oracle, PL/SQL Leave a comment

Maintaining Data Change History in Oracle

How to programmatically maintain data change history in Oracle using PL/SQL triggers.

Categories Automation Tags Automation, Oracle, PL/SQL, Security Leave a comment
Older posts
Newer posts
← Previous Page1 … Page6 Page7 Page8 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Create Self-Signed S/MIME Certificates
  • How to Use Unicode Characters in Power BI
  • Display Total Inside Power BI Donut Chart
  • Mapping Continents and Countries in Power BI

Latest Posts

  • Creating a Power BI What-If Scenario Analysis
  • Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
  • Manually Create a WordPress Database from the MySQL Client
  • Upgrade PHP and PHP-FPM from the Command Line on a Debian LAMP Stack
  • Install a LAMP Stack Manually on a Debian OS Only Amazon Lightsail Instance

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.